PREVIEW / stock_30min / 2023-05-03

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-03.parquet
  size:    2.1 MB
  rows:    103,889
  symbols: 1,635

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2023-05-03 04:00:00	AAPL	Stock	168.75	168.79	168.6	168.69	5302.0
2023-05-03 04:30:00	AAPL	Stock	168.69	168.93	168.69	168.87	10910.0
2023-05-03 05:00:00	AAPL	Stock	168.87	168.9	168.87	168.9	1065.0
2023-05-03 05:30:00	AAPL	Stock	168.85	168.96	168.84	168.95	4565.0
2023-05-03 06:00:00	AAPL	Stock	168.94	169.3	168.94	169.15	15094.0
2023-05-03 06:30:00	AAPL	Stock	169.14	169.3	169.03	169.03	8850.0
2023-05-03 07:00:00	AAPL	Stock	169.05	169.23	169.05	169.2	9802.0
2023-05-03 07:30:00	AAPL	Stock	169.23	169.37	169.1	169.1	29260.0
2023-05-03 08:00:00	AAPL	Stock	169.0563	169.3502	167.04	169.17	88662.0
2023-05-03 08:30:00	AAPL	Stock	169.1427	169.25	168.91	169.0001	53686.0
2023-05-03 09:00:00	AAPL	Stock	169.0	169.51	168.99	169.49	81176.0
2023-05-03 09:30:00	AAPL	Stock	169.51	170.89	169.49	170.7519	6770650.0
2023-05-03 10:00:00	AAPL	Stock	170.75	170.92	170.01	170.0801	3907801.0
2023-05-03 10:30:00	AAPL	Stock	170.08	170.28	169.57	169.625	2707222.0
2023-05-03 11:00:00	AAPL	Stock	169.62	169.69	169.18	169.31	1862989.0
2023-05-03 11:30:00	AAPL	Stock	169.31	169.9299	169.23	169.9214	1876175.0
2023-05-03 12:00:00	AAPL	Stock	169.9287	169.95	169.52	169.7	1341865.0
2023-05-03 12:30:00	AAPL	Stock	169.71	170.17	169.57	169.995	1753378.0
2023-05-03 13:00:00	AAPL	Stock	169.995	170.29	169.895	170.1599	1662684.0
2023-05-03 13:30:00	AAPL	Stock	170.155	170.25	169.7804	169.89	1431179.0
2023-05-03 14:00:00	AAPL	Stock	169.88	170.6	169.37	170.245	3608191.0
2023-05-03 14:30:00	AAPL	Stock	170.25	170.76	169.05	170.05	5078803.0
2023-05-03 15:00:00	AAPL	Stock	170.0401	170.47	168.12	168.15	4302670.0
2023-05-03 15:30:00	AAPL	Stock	168.14	168.2199	167.16	167.465	5886010.0
2023-05-03 16:00:00	AAPL	Stock	167.48	167.6	167.0	167.28	5694603.0
2023-05-03 16:30:00	AAPL	Stock	167.3	167.45	165.32	165.66	449254.0
2023-05-03 17:00:00	AAPL	Stock	165.66	167.45	162.75	163.64	728188.0
2023-05-03 17:30:00	AAPL	Stock	163.64	164.4	163.0	164.25	372461.0
2023-05-03 18:00:00	AAPL	Stock	164.24	164.64	163.52	164.55	301297.0
2023-05-03 18:30:00	AAPL	Stock	164.58	165.3893	164.55	165.2	165426.0
2023-05-03 19:00:00	AAPL	Stock	165.16	165.69	165.0	165.41	72311.0
2023-05-03 19:30:00	AAPL	Stock	165.48	165.72	165.35	165.6	105816.0
2023-05-03 04:00:00	MSFT	Stock	305.99	306.08	304.0	305.9	9145.0
2023-05-03 04:30:00	MSFT	Stock	306.19	306.58	306.19	306.4	950.0
2023-05-03 05:00:00	MSFT	Stock	306.53	306.62	306.4	306.4	1159.0
2023-05-03 05:30:00	MSFT	Stock	306.58	306.7	306.58	306.7	400.0
2023-05-03 06:00:00	MSFT	Stock	307.0	307.13	306.92	307.0	2322.0
2023-05-03 06:30:00	MSFT	Stock	306.95	307.4	306.84	307.15	10782.0
2023-05-03 07:00:00	MSFT	Stock	307.01	307.37	307.01	307.37	4723.0
2023-05-03 07:30:00	MSFT	Stock	307.3	307.55	307.16	307.4	5529.0
2023-05-03 08:00:00	MSFT	Stock	307.16	307.52	304.87	307.25	32709.0
2023-05-03 08:30:00	MSFT	Stock	307.25	307.4	306.69	306.802	17677.0
2023-05-03 09:00:00	MSFT	Stock	306.89	307.2	306.22	306.49	16924.0
2023-05-03 09:30:00	MSFT	Stock	306.67	306.9	304.61	305.65	1892971.0
2023-05-03 10:00:00	MSFT	Stock	305.45	305.66	304.26	304.32	1122351.0
2023-05-03 10:30:00	MSFT	Stock	304.36	306.37	304.36	305.69	946856.0
2023-05-03 11:00:00	MSFT	Stock	305.645	306.4661	304.94	306.36	758481.0
2023-05-03 11:30:00	MSFT	Stock	306.34	306.9734	305.95	306.87	707418.0
2023-05-03 12:00:00	MSFT	Stock	306.9	306.92	305.33	306.1899	651866.0
2023-05-03 12:30:00	MSFT	Stock	306.195	306.92	305.97	306.91	443389.0

> showing 50 of 103,889 rows — these rows as CSV

> unlock the full archive -- $79 one-time