project_api/seed_data.sql at main · oleneen/project_api · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
--
-- PostgreSQL database dump
--

\restrict TmuTrEfboFsbcbddVF6UrCceWYhqDaPtcwLfGZdNpVoqGW06eaaAhK4szZ12aky

-- Dumped from database version 15.15
-- Dumped by pg_dump version 15.15

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Data for Name: instruments; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.instruments (ticker, name, "timestamp") VALUES ('USD', 'US Dollar', '2026-01-07 08:47:07.986601+00');
INSERT INTO public.instruments (ticker, name, "timestamp") VALUES ('AAPL', 'Apple Inc.', '2026-01-07 08:47:07.986601+00');
INSERT INTO public.instruments (ticker, name, "timestamp") VALUES ('GOOGL', 'Alphabet Inc.', '2026-01-07 08:47:07.986601+00');
INSERT INTO public.instruments (ticker, name, "timestamp") VALUES ('MSFT', 'Microsoft Corporation', '2026-01-07 08:47:07.986601+00');
INSERT INTO public.instruments (ticker, name, "timestamp") VALUES ('TSLA', 'Tesla Inc.', '2026-01-07 08:47:07.986601+00');
INSERT INTO public.instruments (ticker, name, "timestamp") VALUES ('RUB', '╤А╤Г╨▒╨╗╨╕', '2026-01-07 13:13:36.117734+00');


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.users (id, name, api_key, role, "timestamp") VALUES ('64947659-27b9-4413-a87a-486801ee2033', '╨Ь╨░╤И╨░', 'key-65758a71-b6a5-4972-b01a-bb7155c9462b', 'USER', '2026-01-07 10:12:17.265682+00');
INSERT INTO public.users (id, name, api_key, role, "timestamp") VALUES ('d2adff8b-d839-4fda-ba4e-0f5437fa1ae2', '╨Ф╨░╨╜╤П', 'key-7ff41fe8-226b-4215-9fec-e8af5bb0a910', 'USER', '2026-01-07 10:18:08.573327+00');
INSERT INTO public.users (id, name, api_key, role, "timestamp") VALUES ('11111111-1111-1111-1111-111111111111', 'Test User', 'test-api-key-123', 'ADMIN', '2026-01-07 08:47:07.987374+00');
INSERT INTO public.users (id, name, api_key, role, "timestamp") VALUES ('346639ac-b734-4902-b9db-ccdaeddbba11', 'admin', 'key-af910956-8eca-4d65-b350-a0fbbdbd178b', 'ADMIN', '2026-01-07 13:02:40.434515+00');


--
-- Data for Name: balances; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.balances (user_id, instrument_ticker, amount, locked) VALUES ('11111111-1111-1111-1111-111111111111', 'USD', 100000, 0);
INSERT INTO public.balances (user_id, instrument_ticker, amount, locked) VALUES ('11111111-1111-1111-1111-111111111111', 'AAPL', 100, 0);
INSERT INTO public.balances (user_id, instrument_ticker, amount, locked) VALUES ('64947659-27b9-4413-a87a-486801ee2033', 'RUB', 9800, 0);
INSERT INTO public.balances (user_id, instrument_ticker, amount, locked) VALUES ('64947659-27b9-4413-a87a-486801ee2033', 'USD', 1010, 0);
INSERT INTO public.balances (user_id, instrument_ticker, amount, locked) VALUES ('d2adff8b-d839-4fda-ba4e-0f5437fa1ae2', 'USD', 990, 8);
INSERT INTO public.balances (user_id, instrument_ticker, amount, locked) VALUES ('d2adff8b-d839-4fda-ba4e-0f5437fa1ae2', 'RUB', 200, 0);


--
-- Data for Name: orders; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.orders (id, user_id, direction, instrument_ticker, qty, price, type, status, "timestamp", filled) VALUES ('3ecdcf47-e251-4982-9c60-b6c59b10437d', 'd2adff8b-d839-4fda-ba4e-0f5437fa1ae2', 'SELL', 'USD', 5, 30, 'LIMIT', 'NEW', '2026-01-07 13:16:26.931453+00', 0);
INSERT INTO public.orders (id, user_id, direction, instrument_ticker, qty, price, type, status, "timestamp", filled) VALUES ('be7f8c5a-0431-4b5e-bef2-8fd416c596b4', 'd2adff8b-d839-4fda-ba4e-0f5437fa1ae2', 'SELL', 'USD', 3, 40, 'LIMIT', 'NEW', '2026-01-07 13:17:01.001368+00', 0);
INSERT INTO public.orders (id, user_id, direction, instrument_ticker, qty, price, type, status, "timestamp", filled) VALUES ('23390686-1f44-4160-a18f-ca74f4d7304d', 'd2adff8b-d839-4fda-ba4e-0f5437fa1ae2', 'SELL', 'USD', 10, 20, 'LIMIT', 'EXECUTED', '2026-01-07 13:16:11.946759+00', 10);
INSERT INTO public.orders (id, user_id, direction, instrument_ticker, qty, price, type, status, "timestamp", filled) VALUES ('6bfe0281-b4c6-4832-962c-e67866aac80c', '64947659-27b9-4413-a87a-486801ee2033', 'BUY', 'USD', 10, 40, 'LIMIT', 'EXECUTED', '2026-01-07 13:18:19.046422+00', 10);


--
-- Data for Name: transactions; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.transactions (id, ticker, qty, price, "timestamp", buy_order_id, sell_order_id) VALUES ('8ef7df4d-0e9f-4410-bc4e-8b08ea1ebfe9', 'USD', 10, 20, '2026-01-07 13:18:19.072301+00', '23390686-1f44-4160-a18f-ca74f4d7304d', '6bfe0281-b4c6-4832-962c-e67866aac80c');


--
-- PostgreSQL database dump complete
--

\unrestrict TmuTrEfboFsbcbddVF6UrCceWYhqDaPtcwLfGZdNpVoqGW06eaaAhK4szZ12aky