PREVIEW / stock_30min / 2024-08-27

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-08-27.parquet
  size:    2.0 MB
  rows:    96,574
  symbols: 845

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
2024-08-27 04:00:00	AAPL	Stock	226.09	227.34	226.09	226.98	11559.0
2024-08-27 04:30:00	AAPL	Stock	226.85	226.95	226.73	226.73	770.0
2024-08-27 05:00:00	AAPL	Stock	226.66	227.19	226.64	227.0	5933.0
2024-08-27 05:30:00	AAPL	Stock	226.97	226.99	226.83	226.83	1586.0
2024-08-27 06:00:00	AAPL	Stock	226.89	226.89	226.34	226.7	10062.0
2024-08-27 06:30:00	AAPL	Stock	226.58	226.58	226.34	226.38	1100.0
2024-08-27 07:00:00	AAPL	Stock	226.44	226.6	226.32	226.44	12157.0
2024-08-27 07:30:00	AAPL	Stock	226.49	226.7	225.5	226.0	18638.0
2024-08-27 08:00:00	AAPL	Stock	226.54	226.68	225.78	226.22	50405.0
2024-08-27 08:30:00	AAPL	Stock	226.1783	226.1783	225.51	225.7	42092.0
2024-08-27 09:00:00	AAPL	Stock	225.7	226.22	225.55	226.07	59749.0
2024-08-27 09:30:00	AAPL	Stock	225.995	226.84	224.89	226.745	3313793.0
2024-08-27 10:00:00	AAPL	Stock	226.745	228.22	226.745	227.97	3388866.0
2024-08-27 10:30:00	AAPL	Stock	227.96	228.32	227.65	228.3067	1820724.0
2024-08-27 11:00:00	AAPL	Stock	228.32	228.85	228.315	228.6	1617677.0
2024-08-27 11:30:00	AAPL	Stock	228.57	228.66	227.977	228.165	1209757.0
2024-08-27 12:00:00	AAPL	Stock	228.145	228.49	227.87	227.94	1059160.0
2024-08-27 12:30:00	AAPL	Stock	227.93	228.2	227.55	228.09	902176.0
2024-08-27 13:00:00	AAPL	Stock	228.0804	228.53	227.83	228.49	815878.0
2024-08-27 13:30:00	AAPL	Stock	228.5	228.664	228.07	228.525	737900.0
2024-08-27 14:00:00	AAPL	Stock	228.53	228.585	228.26	228.4832	736919.0
2024-08-27 14:30:00	AAPL	Stock	228.49	228.549	228.27	228.43	627708.0
2024-08-27 15:00:00	AAPL	Stock	228.43	228.445	228.09	228.15	789358.0
2024-08-27 15:30:00	AAPL	Stock	228.15	228.27	227.75	228.14	2559362.0
2024-08-27 16:00:00	AAPL	Stock	228.02	228.2	227.91	228.18	6050362.0
2024-08-27 16:30:00	AAPL	Stock	228.15	228.2	228.03	228.05	1801644.0
2024-08-27 17:00:00	AAPL	Stock	228.09	228.09	227.92	227.92	15470.0
2024-08-27 17:30:00	AAPL	Stock	227.9201	227.9755	227.81	227.85	7574.0
2024-08-27 18:00:00	AAPL	Stock	227.8503	227.98	227.45	227.5	9760.0
2024-08-27 18:30:00	AAPL	Stock	227.56	227.73	227.5	227.73	7795.0
2024-08-27 19:00:00	AAPL	Stock	227.62	227.8	227.32	227.32	8588.0
2024-08-27 19:30:00	AAPL	Stock	227.45	227.6495	227.3	227.3	11904.0
2024-08-27 04:00:00	MSFT	Stock	414.15	414.9	414.15	414.67	4873.0
2024-08-27 04:30:00	MSFT	Stock	414.5	414.6	414.5	414.5	2043.0
2024-08-27 05:00:00	MSFT	Stock	414.65	414.65	414.34	414.34	1065.0
2024-08-27 05:30:00	MSFT	Stock	414.4	414.41	414.4	414.41	200.0
2024-08-27 06:00:00	MSFT	Stock	414.32	414.32	413.27	413.27	609.0
2024-08-27 07:00:00	MSFT	Stock	412.8	413.5	412.8	413.5	1620.0
2024-08-27 07:30:00	MSFT	Stock	413.48	413.95	413.48	413.85	2863.0
2024-08-27 08:00:00	MSFT	Stock	413.3	414.523	412.86	413.3568	11328.0
2024-08-27 08:30:00	MSFT	Stock	413.08	413.08	412.22	412.3481	11321.0
2024-08-27 09:00:00	MSFT	Stock	412.71	412.75	412.0	412.74	9324.0
2024-08-27 09:30:00	MSFT	Stock	412.86	413.12	410.25	412.0	1225142.0
2024-08-27 10:00:00	MSFT	Stock	412.05	414.09	411.69	414.08	522403.0
2024-08-27 10:30:00	MSFT	Stock	414.06	414.36	412.55	412.9	363456.0
2024-08-27 11:00:00	MSFT	Stock	412.9	413.48	411.42	411.42	352700.0
2024-08-27 11:30:00	MSFT	Stock	411.41	411.67	410.47	411.09	410893.0
2024-08-27 12:00:00	MSFT	Stock	411.04	412.2	410.91	412.13	363346.0
2024-08-27 12:30:00	MSFT	Stock	412.12	412.27	411.19	411.785	236333.0
2024-08-27 13:00:00	MSFT	Stock	411.82	412.75	411.58	412.7107	211319.0

> showing 50 of 96,574 rows — these rows as CSV

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