PREVIEW / stock_30min / 2023-01-25

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-25.parquet
  size:    2.1 MB
  rows:    102,826
  symbols: 1,912

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-01-25 04:00:00	AAPL	Stock	141.93	141.93	141.66	141.78	12610.0
2023-01-25 04:30:00	AAPL	Stock	141.78	141.86	141.55	141.55	8527.0
2023-01-25 05:00:00	AAPL	Stock	141.42	141.5	140.94	141.01	22503.0
2023-01-25 05:30:00	AAPL	Stock	141.06	141.32	141.01	141.3	7924.0
2023-01-25 06:00:00	AAPL	Stock	141.16	141.45	141.16	141.45	6774.0
2023-01-25 06:30:00	AAPL	Stock	141.45	141.45	140.93	141.04	12315.0
2023-01-25 07:00:00	AAPL	Stock	141.05	141.36	140.91	141.25	22658.0
2023-01-25 07:30:00	AAPL	Stock	141.27	141.49	141.18	141.33	18846.0
2023-01-25 08:00:00	AAPL	Stock	141.29	142.89	140.91	141.52	176669.0
2023-01-25 08:30:00	AAPL	Stock	141.51	141.51	140.75	140.85	212499.0
2023-01-25 09:00:00	AAPL	Stock	140.92	141.2	140.56	140.95	165710.0
2023-01-25 09:30:00	AAPL	Stock	140.89	141.09	139.48	139.7145	8218831.0
2023-01-25 10:00:00	AAPL	Stock	139.72	140.46	139.46	139.82	4433744.0
2023-01-25 10:30:00	AAPL	Stock	139.83	140.0	138.81	139.315	4712940.0
2023-01-25 11:00:00	AAPL	Stock	139.315	140.43	139.15	140.1	4591055.0
2023-01-25 11:30:00	AAPL	Stock	140.1	140.84	139.9	140.4807	3665527.0
2023-01-25 12:00:00	AAPL	Stock	140.4811	140.7099	140.12	140.22	2466163.0
2023-01-25 12:30:00	AAPL	Stock	140.23	140.63	140.15	140.44	1478397.0
2023-01-25 13:00:00	AAPL	Stock	140.44	141.12	140.4088	141.0799	2438406.0
2023-01-25 13:30:00	AAPL	Stock	141.08	141.328	140.85	141.08	2722500.0
2023-01-25 14:00:00	AAPL	Stock	141.08	141.97	140.9609	141.6	2803450.0
2023-01-25 14:30:00	AAPL	Stock	141.6	141.97	141.37	141.79	2635085.0
2023-01-25 15:00:00	AAPL	Stock	141.8	142.43	141.53	141.83	4358406.0
2023-01-25 15:30:00	AAPL	Stock	141.8354	141.95	141.275	141.8501	5009020.0
2023-01-25 16:00:00	AAPL	Stock	141.85	141.98	141.16	141.58	5451134.0
2023-01-25 16:30:00	AAPL	Stock	141.56	141.86	141.35	141.61	40633.0
2023-01-25 17:00:00	AAPL	Stock	141.57	141.68	141.36	141.4388	15955.0
2023-01-25 17:30:00	AAPL	Stock	141.49	141.57	141.42	141.47	10885.0
2023-01-25 18:00:00	AAPL	Stock	141.5	141.95	141.5	141.94	25853.0
2023-01-25 18:30:00	AAPL	Stock	141.84	142.08	141.84	142.0	33072.0
2023-01-25 19:00:00	AAPL	Stock	142.04	142.14	142.0	142.04	24815.0
2023-01-25 19:30:00	AAPL	Stock	142.09	142.15	142.01	142.06	37914.0
2023-01-25 04:00:00	MSFT	Stock	238.9	241.5	237.6	238.4	44686.0
2023-01-25 04:30:00	MSFT	Stock	238.39	238.39	237.2	237.37	17087.0
2023-01-25 05:00:00	MSFT	Stock	237.32	237.48	236.5	237.0	16521.0
2023-01-25 05:30:00	MSFT	Stock	237.0	237.0	235.51	235.94	13846.0
2023-01-25 06:00:00	MSFT	Stock	235.91	237.0	235.6	236.11	39831.0
2023-01-25 06:30:00	MSFT	Stock	236.22	236.37	235.34	235.93	27854.0
2023-01-25 07:00:00	MSFT	Stock	235.93	236.5	235.03	236.16	108304.0
2023-01-25 07:30:00	MSFT	Stock	236.18	236.49	235.6	235.8	124186.0
2023-01-25 08:00:00	MSFT	Stock	235.8	240.09	235.05	235.67	255101.0
2023-01-25 08:30:00	MSFT	Stock	235.6	236.1	234.3	234.4	250079.0
2023-01-25 09:00:00	MSFT	Stock	234.4586	234.6	233.37	234.5	294204.0
2023-01-25 09:30:00	MSFT	Stock	234.5	235.0	230.9	231.495	9508645.0
2023-01-25 10:00:00	MSFT	Stock	231.41	234.46	231.15	234.29	5231883.0
2023-01-25 10:30:00	MSFT	Stock	234.3	235.37	233.37	234.59	3260613.0
2023-01-25 11:00:00	MSFT	Stock	234.59	237.62	234.27	236.975	3844841.0
2023-01-25 11:30:00	MSFT	Stock	236.98	240.95	236.9	240.48	5871313.0
2023-01-25 12:00:00	MSFT	Stock	240.49	240.67	238.21	238.4399	3813618.0
2023-01-25 12:30:00	MSFT	Stock	238.44	239.5499	237.91	239.21	2090091.0

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

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