PREVIEW / stock_30min / 2023-12-27

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-12-27.parquet
  size:    2.1 MB
  rows:    102,964
  symbols: 1,232

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-12-27 04:00:00	AAPL	Stock	193.0	193.0	192.8	192.81	9010.0
2023-12-27 04:30:00	AAPL	Stock	192.8	192.81	192.74	192.8	2291.0
2023-12-27 05:00:00	AAPL	Stock	192.8	192.83	192.8	192.81	806.0
2023-12-27 05:30:00	AAPL	Stock	192.86	192.86	192.86	192.86	200.0
2023-12-27 06:00:00	AAPL	Stock	192.81	192.83	192.81	192.82	1715.0
2023-12-27 06:30:00	AAPL	Stock	192.8	192.82	192.8	192.82	1178.0
2023-12-27 07:00:00	AAPL	Stock	192.85	192.91	192.82	192.91	4067.0
2023-12-27 07:30:00	AAPL	Stock	192.98	192.98	192.9	192.91	5285.0
2023-12-27 08:00:00	AAPL	Stock	192.8214	193.05	192.8	193.03	30424.0
2023-12-27 08:30:00	AAPL	Stock	193.03	193.03	192.9072	192.9133	27123.0
2023-12-27 09:00:00	AAPL	Stock	192.94	192.99	192.0	192.43	130761.0
2023-12-27 09:30:00	AAPL	Stock	192.49	192.8972	192.36	192.45	3487473.0
2023-12-27 10:00:00	AAPL	Stock	192.455	192.54	191.445	191.6385	3341925.0
2023-12-27 10:30:00	AAPL	Stock	191.635	191.775	191.1	191.67	2665998.0
2023-12-27 11:00:00	AAPL	Stock	191.6788	191.728	191.09	191.6804	2239605.0
2023-12-27 11:30:00	AAPL	Stock	191.68	192.18	191.55	192.1442	3088966.0
2023-12-27 12:00:00	AAPL	Stock	192.15	192.53	192.1111	192.48	1987041.0
2023-12-27 12:30:00	AAPL	Stock	192.475	192.75	192.46	192.64	1818794.0
2023-12-27 13:00:00	AAPL	Stock	192.64	193.15	192.64	192.976	2235345.0
2023-12-27 13:30:00	AAPL	Stock	192.979	193.5	192.97	193.3818	1717794.0
2023-12-27 14:00:00	AAPL	Stock	193.38	193.38	192.78	193.15	2109571.0
2023-12-27 14:30:00	AAPL	Stock	193.17	193.24	192.76	192.92	1414041.0
2023-12-27 15:00:00	AAPL	Stock	192.92	193.04	192.81	192.93	1280995.0
2023-12-27 15:30:00	AAPL	Stock	192.93	193.22	192.73	193.19	3529911.0
2023-12-27 16:00:00	AAPL	Stock	193.15	193.23	193.08	193.11	6237232.0
2023-12-27 16:30:00	AAPL	Stock	193.1	193.1699	193.1	193.13	21920.0
2023-12-27 17:00:00	AAPL	Stock	193.11	193.23	193.0501	193.2	20847.0
2023-12-27 17:30:00	AAPL	Stock	193.23	193.23	193.1	193.1494	4380.0
2023-12-27 18:00:00	AAPL	Stock	193.15	193.1954	193.12	193.15	5258.0
2023-12-27 18:30:00	AAPL	Stock	193.16	193.19	193.1	193.16	6628.0
2023-12-27 19:00:00	AAPL	Stock	193.16	193.18	193.1	193.16	4783.0
2023-12-27 19:30:00	AAPL	Stock	193.16	193.22	193.1599	193.1794	9041.0
2023-12-27 04:00:00	MSFT	Stock	374.66	374.66	374.66	374.66	100.0
2023-12-27 04:30:00	MSFT	Stock	374.89	374.89	374.89	374.89	250.0
2023-12-27 05:00:00	MSFT	Stock	374.89	374.89	374.89	374.89	205.0
2023-12-27 05:30:00	MSFT	Stock	375.0	375.0	375.0	375.0	100.0
2023-12-27 06:00:00	MSFT	Stock	374.81	374.81	374.75	374.75	460.0
2023-12-27 06:30:00	MSFT	Stock	374.7	374.7	374.7	374.7	200.0
2023-12-27 07:00:00	MSFT	Stock	374.58	374.58	374.47	374.47	625.0
2023-12-27 07:30:00	MSFT	Stock	374.5	374.74	374.45	374.74	1575.0
2023-12-27 08:00:00	MSFT	Stock	374.7	375.0	374.4	374.88	9540.0
2023-12-27 08:30:00	MSFT	Stock	374.89	374.89	374.04	374.2	16237.0
2023-12-27 09:00:00	MSFT	Stock	374.21	374.32	372.72	373.64	35918.0
2023-12-27 09:30:00	MSFT	Stock	373.7	375.06	373.69	373.78	1144275.0
2023-12-27 10:00:00	MSFT	Stock	373.815	374.28	372.93	373.24	637253.0
2023-12-27 10:30:00	MSFT	Stock	373.23	373.61	372.8116	373.57	585378.0
2023-12-27 11:00:00	MSFT	Stock	373.58	373.77	373.2	373.5299	341856.0
2023-12-27 11:30:00	MSFT	Stock	373.52	374.13	373.45	373.91	363026.0
2023-12-27 12:00:00	MSFT	Stock	373.917	374.02	373.7203	373.8101	350992.0
2023-12-27 12:30:00	MSFT	Stock	373.8197	374.005	373.38	373.43	356792.0

> showing 50 of 102,964 rows — these rows as CSV

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