PREVIEW / stock_30min / 2024-01-18

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-01-18.parquet
  size:    2.0 MB
  rows:    97,761
  symbols: 1,168

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-01-18 04:00:00	AAPL	Stock	182.55	182.83	182.49	182.49	9007.0
2024-01-18 04:30:00	AAPL	Stock	182.37	182.56	182.2	182.2	4634.0
2024-01-18 05:00:00	AAPL	Stock	182.3	182.37	182.11	182.32	1652.0
2024-01-18 05:30:00	AAPL	Stock	182.32	182.55	182.3	182.55	4421.0
2024-01-18 06:00:00	AAPL	Stock	182.55	186.0	182.55	185.8	166625.0
2024-01-18 06:30:00	AAPL	Stock	185.8	186.15	185.6	185.92	47858.0
2024-01-18 07:00:00	AAPL	Stock	185.81	186.1	185.52	185.79	115438.0
2024-01-18 07:30:00	AAPL	Stock	185.83	187.25	185.8	186.9	175589.0
2024-01-18 08:00:00	AAPL	Stock	185.79	187.25	182.04	186.39	216761.0
2024-01-18 08:30:00	AAPL	Stock	186.39	186.9255	185.86	185.86	263487.0
2024-01-18 09:00:00	AAPL	Stock	185.909	186.99	185.909	186.19	424825.0
2024-01-18 09:30:00	AAPL	Stock	186.19	187.65	185.83	187.37	10300263.0
2024-01-18 10:00:00	AAPL	Stock	187.36	187.62	186.595	187.4501	4607333.0
2024-01-18 10:30:00	AAPL	Stock	187.46	188.16	187.27	188.0881	4864040.0
2024-01-18 11:00:00	AAPL	Stock	188.09	188.96	187.56	188.77	4283776.0
2024-01-18 11:30:00	AAPL	Stock	188.765	188.78	188.2602	188.4716	3574866.0
2024-01-18 12:00:00	AAPL	Stock	188.485	188.53	187.68	187.93	3391724.0
2024-01-18 12:30:00	AAPL	Stock	187.93	187.93	187.5	187.85	2081114.0
2024-01-18 13:00:00	AAPL	Stock	187.85	187.86	186.7501	186.925	2861031.0
2024-01-18 13:30:00	AAPL	Stock	186.93	188.2601	186.92	188.1601	2822584.0
2024-01-18 14:00:00	AAPL	Stock	188.17	188.95	188.16	188.9245	2697883.0
2024-01-18 14:30:00	AAPL	Stock	188.925	189.14	188.705	188.975	3343896.0
2024-01-18 15:00:00	AAPL	Stock	188.98	189.13	188.745	188.9599	2676034.0
2024-01-18 15:30:00	AAPL	Stock	188.96	188.99	188.51	188.73	5856430.0
2024-01-18 16:00:00	AAPL	Stock	188.63	188.97	188.53	188.9	9918731.0
2024-01-18 16:30:00	AAPL	Stock	188.9	188.92	188.46	188.5	271908.0
2024-01-18 17:00:00	AAPL	Stock	188.48	188.54	187.8	187.8	92910.0
2024-01-18 17:30:00	AAPL	Stock	187.8508	188.63	187.75	188.2	86200.0
2024-01-18 18:00:00	AAPL	Stock	188.22	188.4	188.15	188.4	41921.0
2024-01-18 18:30:00	AAPL	Stock	188.4	188.6	188.34	188.6	13802.0
2024-01-18 19:00:00	AAPL	Stock	188.6	188.65	188.52	188.65	13409.0
2024-01-18 19:30:00	AAPL	Stock	188.6301	188.69	188.4	188.69	14417.0
2024-01-18 04:00:00	MSFT	Stock	392.63	393.41	392.63	393.29	6231.0
2024-01-18 04:30:00	MSFT	Stock	393.19	393.82	393.19	393.32	4832.0
2024-01-18 05:00:00	MSFT	Stock	393.23	393.3	393.0	393.0	1504.0
2024-01-18 05:30:00	MSFT	Stock	393.2	394.32	393.2	394.32	2706.0
2024-01-18 06:00:00	MSFT	Stock	393.99	393.99	392.99	393.23	8249.0
2024-01-18 06:30:00	MSFT	Stock	393.0	393.87	392.42	393.45	13602.0
2024-01-18 07:00:00	MSFT	Stock	393.51	393.85	392.55	392.95	26648.0
2024-01-18 07:30:00	MSFT	Stock	392.69	392.98	391.01	391.59	11224.0
2024-01-18 08:00:00	MSFT	Stock	393.0	393.8	389.85	392.5	62804.0
2024-01-18 08:30:00	MSFT	Stock	392.28	393.0	390.9	391.2499	36448.0
2024-01-18 09:00:00	MSFT	Stock	391.25	392.5	390.5	391.66	42302.0
2024-01-18 09:30:00	MSFT	Stock	391.71	393.19	390.71	392.18	2568797.0
2024-01-18 10:00:00	MSFT	Stock	392.19	392.6	390.97	392.2	955268.0
2024-01-18 10:30:00	MSFT	Stock	392.22	392.98	391.555	392.4784	1074039.0
2024-01-18 11:00:00	MSFT	Stock	392.48	393.12	391.96	392.67	894455.0
2024-01-18 11:30:00	MSFT	Stock	392.7	393.13	392.46	392.8	656966.0
2024-01-18 12:00:00	MSFT	Stock	392.85	392.9	390.96	392.01	703151.0
2024-01-18 12:30:00	MSFT	Stock	392.04	392.04	391.1	391.17	440658.0

> showing 50 of 97,761 rows — these rows as CSV

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