PREVIEW / stock_30min / 2023-07-17

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-17.parquet
  size:    2.1 MB
  rows:    101,542
  symbols: 1,541

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-07-17 04:00:00	AAPL	Stock	190.67	191.0	190.65	191.0	10010.0
2023-07-17 04:30:00	AAPL	Stock	190.98	191.0	190.85	190.9	6825.0
2023-07-17 05:00:00	AAPL	Stock	190.83	191.0	190.71	190.96	7010.0
2023-07-17 05:30:00	AAPL	Stock	190.99	191.0	190.77	190.78	6222.0
2023-07-17 06:00:00	AAPL	Stock	190.96	190.97	190.78	190.85	1835.0
2023-07-17 06:30:00	AAPL	Stock	190.84	191.0	190.76	190.86	8917.0
2023-07-17 07:00:00	AAPL	Stock	190.86	191.05	190.86	191.03	43905.0
2023-07-17 07:30:00	AAPL	Stock	191.0	191.25	190.95	191.2	35468.0
2023-07-17 08:00:00	AAPL	Stock	190.8996	191.61	190.22	191.36	180455.0
2023-07-17 08:30:00	AAPL	Stock	191.29	191.44	191.15	191.44	43009.0
2023-07-17 09:00:00	AAPL	Stock	191.45	191.94	191.35	191.94	250556.0
2023-07-17 09:30:00	AAPL	Stock	191.9	193.45	191.81	192.52	7842063.0
2023-07-17 10:00:00	AAPL	Stock	192.53	193.13	192.53	192.765	3159329.0
2023-07-17 10:30:00	AAPL	Stock	192.765	193.125	192.705	192.95	2048437.0
2023-07-17 11:00:00	AAPL	Stock	192.96	193.14	192.74	193.005	1935261.0
2023-07-17 11:30:00	AAPL	Stock	193.0	193.29	192.85	193.2313	1920253.0
2023-07-17 12:00:00	AAPL	Stock	193.24	193.25	192.715	192.75	1412763.0
2023-07-17 12:30:00	AAPL	Stock	192.74	192.925	192.4	192.9	1415829.0
2023-07-17 13:00:00	AAPL	Stock	192.9	193.0801	192.8	193.08	1289392.0
2023-07-17 13:30:00	AAPL	Stock	193.08	193.49	192.9529	193.31	1356471.0
2023-07-17 14:00:00	AAPL	Stock	193.3	193.76	193.17	193.665	1821264.0
2023-07-17 14:30:00	AAPL	Stock	193.665	193.8	193.58	193.6788	1341131.0
2023-07-17 15:00:00	AAPL	Stock	193.68	194.32	193.67	194.15	3183156.0
2023-07-17 15:30:00	AAPL	Stock	194.14	194.25	193.7	193.98	5646069.0
2023-07-17 16:00:00	AAPL	Stock	193.98	194.0	193.04	193.93	6218526.0
2023-07-17 16:30:00	AAPL	Stock	193.93	193.99	193.8637	193.88	68210.0
2023-07-17 17:00:00	AAPL	Stock	193.92	194.0	193.92	194.0	15174.0
2023-07-17 17:30:00	AAPL	Stock	194.05	194.0897	193.98	193.9805	12939.0
2023-07-17 18:00:00	AAPL	Stock	193.98	193.99	193.87	193.9	8139.0
2023-07-17 18:30:00	AAPL	Stock	193.89	193.93	193.85	193.89	6930.0
2023-07-17 19:00:00	AAPL	Stock	193.85	194.0299	193.85	194.0	10617.0
2023-07-17 19:30:00	AAPL	Stock	194.03	194.08	193.96	193.97	45119.0
2023-07-17 04:00:00	MSFT	Stock	348.51	348.51	346.8	347.88	13887.0
2023-07-17 04:30:00	MSFT	Stock	347.78	347.78	347.13	347.13	621.0
2023-07-17 05:00:00	MSFT	Stock	347.21	347.24	346.12	346.12	1692.0
2023-07-17 05:30:00	MSFT	Stock	346.15	346.15	345.8	345.98	2653.0
2023-07-17 06:00:00	MSFT	Stock	346.03	346.48	345.82	345.82	547.0
2023-07-17 06:30:00	MSFT	Stock	345.75	345.96	345.54	345.54	2708.0
2023-07-17 07:00:00	MSFT	Stock	346.07	346.59	346.01	346.01	6872.0
2023-07-17 07:30:00	MSFT	Stock	346.11	346.21	345.51	345.51	5966.0
2023-07-17 08:00:00	MSFT	Stock	346.0	348.33	344.79	345.6639	20250.0
2023-07-17 08:30:00	MSFT	Stock	345.4	345.66	344.85	345.2399	8469.0
2023-07-17 09:00:00	MSFT	Stock	345.2	346.45	345.0	345.95	27895.0
2023-07-17 09:30:00	MSFT	Stock	345.71	346.99	342.2	343.35	2239472.0
2023-07-17 10:00:00	MSFT	Stock	343.41	345.12	343.01	343.8699	1008322.0
2023-07-17 10:30:00	MSFT	Stock	343.85	345.09	343.58	344.92	775155.0
2023-07-17 11:00:00	MSFT	Stock	344.96	345.51	344.63	345.3054	758900.0
2023-07-17 11:30:00	MSFT	Stock	345.32	345.99	345.0267	345.9	591732.0
2023-07-17 12:00:00	MSFT	Stock	345.94	346.49	345.252	345.48	509732.0
2023-07-17 12:30:00	MSFT	Stock	345.45	346.0699	345.16	345.91	360177.0

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

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