PREVIEW / stock_30min / 2023-03-08

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-08.parquet
  size:    2.0 MB
  rows:    99,461
  symbols: 1,840

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-03-08 04:00:00	AAPL	Stock	151.5	151.94	151.5	151.56	5034.0
2023-03-08 04:30:00	AAPL	Stock	151.6	151.66	151.6	151.6	1737.0
2023-03-08 05:00:00	AAPL	Stock	151.7	151.7	151.62	151.62	1403.0
2023-03-08 05:30:00	AAPL	Stock	151.63	151.89	151.63	151.79	3142.0
2023-03-08 06:00:00	AAPL	Stock	151.87	152.2	151.84	152.11	23398.0
2023-03-08 06:30:00	AAPL	Stock	152.12	152.17	151.95	152.0	13523.0
2023-03-08 07:00:00	AAPL	Stock	151.92	152.1	151.78	151.88	24945.0
2023-03-08 07:30:00	AAPL	Stock	151.9	152.0	151.63	151.94	15027.0
2023-03-08 08:00:00	AAPL	Stock	152.0212	152.22	151.06	152.105	122841.0
2023-03-08 08:30:00	AAPL	Stock	152.18	152.34	152.0	152.25	97176.0
2023-03-08 09:00:00	AAPL	Stock	152.19	152.84	152.08	152.77	139340.0
2023-03-08 09:30:00	AAPL	Stock	152.77	153.1	152.3	152.65	5891456.0
2023-03-08 10:00:00	AAPL	Stock	152.66	153.04	151.83	152.6392	4658471.0
2023-03-08 10:30:00	AAPL	Stock	152.64	153.21	152.33	152.61	3040370.0
2023-03-08 11:00:00	AAPL	Stock	152.6	153.02	152.5	152.59	2179899.0
2023-03-08 11:30:00	AAPL	Stock	152.6	153.47	152.35	153.34	2756582.0
2023-03-08 12:00:00	AAPL	Stock	153.35	153.41	152.68	152.75	2076596.0
2023-03-08 12:30:00	AAPL	Stock	152.73	153.055	152.35	152.83	2132872.0
2023-03-08 13:00:00	AAPL	Stock	152.84	152.9401	152.25	152.335	1904031.0
2023-03-08 13:30:00	AAPL	Stock	152.34	152.41	152.05	152.29	1763390.0
2023-03-08 14:00:00	AAPL	Stock	152.28	152.81	152.23	152.7906	1722166.0
2023-03-08 14:30:00	AAPL	Stock	152.79	152.9896	152.49	152.5	1800434.0
2023-03-08 15:00:00	AAPL	Stock	152.51	152.61	152.07	152.24	2381778.0
2023-03-08 15:30:00	AAPL	Stock	152.25	153.26	152.21	152.89	4855524.0
2023-03-08 16:00:00	AAPL	Stock	152.9	152.98	152.79	152.87	4026230.0
2023-03-08 16:30:00	AAPL	Stock	152.85	152.9397	152.81	152.93	24773.0
2023-03-08 17:00:00	AAPL	Stock	152.9499	152.9499	152.9	152.94	6392.0
2023-03-08 17:30:00	AAPL	Stock	152.9	153.04	152.87	153.02	40971.0
2023-03-08 18:00:00	AAPL	Stock	153.0	153.0	152.87	152.92	30616.0
2023-03-08 18:30:00	AAPL	Stock	153.0	153.0599	152.94	153.0	8215.0
2023-03-08 19:00:00	AAPL	Stock	152.95	152.99	152.9	152.96	10419.0
2023-03-08 19:30:00	AAPL	Stock	152.96	152.96	152.25	152.65	26144.0
2023-03-08 04:00:00	MSFT	Stock	254.5	254.5	254.15	254.2	1712.0
2023-03-08 04:30:00	MSFT	Stock	254.41	254.41	254.41	254.41	100.0
2023-03-08 05:00:00	MSFT	Stock	254.6	254.82	254.6	254.77	1500.0
2023-03-08 05:30:00	MSFT	Stock	254.99	255.01	254.95	254.95	474.0
2023-03-08 06:00:00	MSFT	Stock	255.16	255.49	255.16	255.24	1624.0
2023-03-08 06:30:00	MSFT	Stock	254.95	255.09	254.82	255.09	500.0
2023-03-08 07:00:00	MSFT	Stock	254.81	255.1	254.01	254.01	6140.0
2023-03-08 07:30:00	MSFT	Stock	254.17	254.45	253.49	253.66	1774.0
2023-03-08 08:00:00	MSFT	Stock	254.9972	255.3	252.81	253.9578	23854.0
2023-03-08 08:30:00	MSFT	Stock	253.6416	254.15	253.2	253.31	10704.0
2023-03-08 09:00:00	MSFT	Stock	253.456	254.07	252.82	254.07	14815.0
2023-03-08 09:30:00	MSFT	Stock	254.15	254.5417	252.2	252.28	1854725.0
2023-03-08 10:00:00	MSFT	Stock	252.25	252.4	250.81	252.02	1547934.0
2023-03-08 10:30:00	MSFT	Stock	252.04	253.03	251.7	252.35	802648.0
2023-03-08 11:00:00	MSFT	Stock	252.36	253.34	252.11	252.38	719649.0
2023-03-08 11:30:00	MSFT	Stock	252.395	253.84	251.56	253.72	801142.0
2023-03-08 12:00:00	MSFT	Stock	253.73	253.8999	252.33	252.43	576915.0
2023-03-08 12:30:00	MSFT	Stock	252.42	253.0	251.79	252.6	528130.0

> showing 50 of 99,461 rows — these rows as CSV

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