PREVIEW / stock_30min / 2023-08-03

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-03.parquet
  size:    2.1 MB
  rows:    101,679
  symbols: 1,523

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-03 04:00:00	AAPL	Stock	191.9	191.9	190.74	191.71	36287.0
2023-08-03 04:30:00	AAPL	Stock	191.65	191.68	191.23	191.48	6727.0
2023-08-03 05:00:00	AAPL	Stock	191.48	192.1	191.48	191.84	8546.0
2023-08-03 05:30:00	AAPL	Stock	191.84	192.0	191.7	191.83	5824.0
2023-08-03 06:00:00	AAPL	Stock	191.91	192.07	191.76	191.76	3708.0
2023-08-03 06:30:00	AAPL	Stock	191.74	191.85	191.7	191.7	7798.0
2023-08-03 07:00:00	AAPL	Stock	191.75	192.25	191.65	191.8	41233.0
2023-08-03 07:30:00	AAPL	Stock	191.79	192.0	191.65	191.79	15778.0
2023-08-03 08:00:00	AAPL	Stock	191.8	193.0	191.465	191.59	117144.0
2023-08-03 08:30:00	AAPL	Stock	191.65	192.18	191.45	191.73	99032.0
2023-08-03 09:00:00	AAPL	Stock	191.77	191.9	191.2	191.52	169119.0
2023-08-03 09:30:00	AAPL	Stock	191.56	192.28	190.69	191.69	4979374.0
2023-08-03 10:00:00	AAPL	Stock	191.68	192.03	190.84	190.89	3362131.0
2023-08-03 10:30:00	AAPL	Stock	190.895	191.9	190.85	191.72	2823663.0
2023-08-03 11:00:00	AAPL	Stock	191.72	192.37	191.623	192.1	2461467.0
2023-08-03 11:30:00	AAPL	Stock	192.11	192.2	191.73	191.74	1801145.0
2023-08-03 12:00:00	AAPL	Stock	191.74	192.0	191.61	191.8264	1734753.0
2023-08-03 12:30:00	AAPL	Stock	191.8348	192.36	191.72	192.215	1468743.0
2023-08-03 13:00:00	AAPL	Stock	192.22	192.3	191.85	191.88	1502712.0
2023-08-03 13:30:00	AAPL	Stock	191.89	191.96	191.24	191.3702	1978657.0
2023-08-03 14:00:00	AAPL	Stock	191.37	191.83	191.2	191.735	2014466.0
2023-08-03 14:30:00	AAPL	Stock	191.74	191.95	191.475	191.84	2130811.0
2023-08-03 15:00:00	AAPL	Stock	191.85	191.95	191.07	191.16	2763205.0
2023-08-03 15:30:00	AAPL	Stock	191.1586	191.73	190.99	191.0099	6298137.0
2023-08-03 16:00:00	AAPL	Stock	191.005	194.0	190.69	193.65	5763647.0
2023-08-03 16:30:00	AAPL	Stock	193.7	196.11	187.21	189.01	3806985.0
2023-08-03 17:00:00	AAPL	Stock	189.01	189.48	185.3	187.019	1403439.0
2023-08-03 17:30:00	AAPL	Stock	187.04	187.51	185.0	187.0	1457816.0
2023-08-03 18:00:00	AAPL	Stock	187.0	187.3295	185.85	186.55	445662.0
2023-08-03 18:30:00	AAPL	Stock	186.6	187.45	186.35	187.45	263151.0
2023-08-03 19:00:00	AAPL	Stock	187.45	187.8	186.68	187.42	148004.0
2023-08-03 19:30:00	AAPL	Stock	187.42	187.44	186.8	187.3	190146.0
2023-08-03 04:00:00	MSFT	Stock	326.5	326.5	325.01	326.11	13199.0
2023-08-03 04:30:00	MSFT	Stock	326.12	326.29	325.37	326.0	3664.0
2023-08-03 05:00:00	MSFT	Stock	326.71	326.76	326.5	326.76	2670.0
2023-08-03 05:30:00	MSFT	Stock	326.68	327.0	326.32	327.0	5383.0
2023-08-03 06:00:00	MSFT	Stock	326.8	327.15	326.8	327.15	2302.0
2023-08-03 06:30:00	MSFT	Stock	327.0	327.0	326.8	326.8	566.0
2023-08-03 07:00:00	MSFT	Stock	326.92	327.3	326.02	326.25	10552.0
2023-08-03 07:30:00	MSFT	Stock	326.37	326.75	326.2	326.45	3695.0
2023-08-03 08:00:00	MSFT	Stock	326.92	327.7	325.62	325.65	28912.0
2023-08-03 08:30:00	MSFT	Stock	325.8	326.46	325.05	325.3212	29749.0
2023-08-03 09:00:00	MSFT	Stock	325.46	326.17	325.15	326.1	55618.0
2023-08-03 09:30:00	MSFT	Stock	326.1	328.68	325.95	328.48	2208183.0
2023-08-03 10:00:00	MSFT	Stock	328.43	329.15	326.56	326.65	1353616.0
2023-08-03 10:30:00	MSFT	Stock	326.63	328.8	326.61	328.49	984220.0
2023-08-03 11:00:00	MSFT	Stock	328.4529	329.88	328.01	328.84	967985.0
2023-08-03 11:30:00	MSFT	Stock	328.84	329.3199	328.07	328.14	542240.0
2023-08-03 12:00:00	MSFT	Stock	328.11	329.04	327.93	328.63	490739.0
2023-08-03 12:30:00	MSFT	Stock	328.645	329.38	328.34	329.1601	452057.0

> showing 50 of 101,679 rows — these rows as CSV

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