PREVIEW / stock_30min / 2023-08-15

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-15.parquet
  size:    2.1 MB
  rows:    100,260
  symbols: 1,494

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-08-15 04:00:00	AAPL	Stock	179.4	179.4	178.63	178.82	10220.0
2023-08-15 04:30:00	AAPL	Stock	178.8	178.97	178.75	178.97	2733.0
2023-08-15 05:00:00	AAPL	Stock	178.91	178.99	178.85	178.89	2877.0
2023-08-15 05:30:00	AAPL	Stock	178.98	178.98	178.86	178.86	750.0
2023-08-15 06:00:00	AAPL	Stock	178.91	178.92	178.1	178.4	19516.0
2023-08-15 06:30:00	AAPL	Stock	178.33	178.4	178.14	178.4	15031.0
2023-08-15 07:00:00	AAPL	Stock	178.39	178.65	178.3	178.58	32690.0
2023-08-15 07:30:00	AAPL	Stock	178.56	178.8	178.38	178.47	17200.0
2023-08-15 08:00:00	AAPL	Stock	178.58	180.17	178.295	178.75	119534.0
2023-08-15 08:30:00	AAPL	Stock	178.77	178.84	178.25	178.79	88238.0
2023-08-15 09:00:00	AAPL	Stock	178.77	179.23	178.7	178.88	90626.0
2023-08-15 09:30:00	AAPL	Stock	178.93	179.48	178.42	178.44	4067331.0
2023-08-15 10:00:00	AAPL	Stock	178.43	178.495	177.53	177.8119	3664732.0
2023-08-15 10:30:00	AAPL	Stock	177.815	177.87	177.38	177.695	2688787.0
2023-08-15 11:00:00	AAPL	Stock	177.7	178.23	177.695	178.1499	1927209.0
2023-08-15 11:30:00	AAPL	Stock	178.145	178.395	177.99	178.31	1357623.0
2023-08-15 12:00:00	AAPL	Stock	178.31	178.44	177.85	178.17	1421937.0
2023-08-15 12:30:00	AAPL	Stock	178.17	178.22	177.781	177.95	1030553.0
2023-08-15 13:00:00	AAPL	Stock	177.96	178.24	177.82	178.1299	1057328.0
2023-08-15 13:30:00	AAPL	Stock	178.13	178.16	177.62	177.83	1235371.0
2023-08-15 14:00:00	AAPL	Stock	177.8391	177.985	177.74	177.89	943528.0
2023-08-15 14:30:00	AAPL	Stock	177.9	178.235	177.87	178.0	1038605.0
2023-08-15 15:00:00	AAPL	Stock	177.99	178.075	177.27	177.285	1987240.0
2023-08-15 15:30:00	AAPL	Stock	177.28	177.72	177.05	177.48	4596176.0
2023-08-15 16:00:00	AAPL	Stock	177.485	177.58	177.36	177.56	4803031.0
2023-08-15 16:30:00	AAPL	Stock	177.54	177.55	177.35	177.4	129041.0
2023-08-15 17:00:00	AAPL	Stock	177.41	177.45	177.36	177.3991	15247.0
2023-08-15 17:30:00	AAPL	Stock	177.39	177.44	177.39	177.41	8204.0
2023-08-15 18:00:00	AAPL	Stock	177.45	177.55	177.4	177.55	19908.0
2023-08-15 18:30:00	AAPL	Stock	177.53	177.55	177.46	177.46	9622.0
2023-08-15 19:00:00	AAPL	Stock	177.53	177.6	177.45	177.6	16820.0
2023-08-15 19:30:00	AAPL	Stock	177.6	177.79	177.6	177.7	12866.0
2023-08-15 04:00:00	MSFT	Stock	324.68	324.68	322.55	323.4	3969.0
2023-08-15 04:30:00	MSFT	Stock	323.01	323.1	323.01	323.09	862.0
2023-08-15 05:00:00	MSFT	Stock	322.92	322.92	322.43	322.8	1361.0
2023-08-15 05:30:00	MSFT	Stock	322.9	322.9	322.5	322.5	967.0
2023-08-15 06:00:00	MSFT	Stock	322.54	322.54	321.5	321.5	11083.0
2023-08-15 06:30:00	MSFT	Stock	321.5	321.64	321.3	321.64	762.0
2023-08-15 07:00:00	MSFT	Stock	321.9	322.29	321.44	322.2	7405.0
2023-08-15 07:30:00	MSFT	Stock	322.2	322.2	321.4	321.45	6006.0
2023-08-15 08:00:00	MSFT	Stock	321.86	324.0	321.3999	322.01	22613.0
2023-08-15 08:30:00	MSFT	Stock	321.85	322.2	321.2	322.2	12119.0
2023-08-15 09:00:00	MSFT	Stock	321.81	323.04	321.81	322.95	12549.0
2023-08-15 09:30:00	MSFT	Stock	322.86	324.9	322.86	323.66	1423256.0
2023-08-15 10:00:00	MSFT	Stock	323.61	323.67	321.1	322.06	1281126.0
2023-08-15 10:30:00	MSFT	Stock	321.98	322.771	321.293	322.19	614250.0
2023-08-15 11:00:00	MSFT	Stock	322.195	324.3244	322.19	324.0	774950.0
2023-08-15 11:30:00	MSFT	Stock	323.95	324.937	323.635	324.85	851460.0
2023-08-15 12:00:00	MSFT	Stock	324.855	325.09	323.92	324.27	686832.0
2023-08-15 12:30:00	MSFT	Stock	324.31	324.44	323.7262	324.138	435900.0

> showing 50 of 100,260 rows — these rows as CSV

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