PREVIEW / stock_30min / 2024-05-20

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-05-20.parquet
  size:    2.1 MB
  rows:    99,909
  symbols: 969

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-05-20 04:00:00	AAPL	Stock	189.84	190.1	189.72	190.06	5013.0
2024-05-20 04:30:00	AAPL	Stock	190.0	190.0	189.87	189.9	2196.0
2024-05-20 05:00:00	AAPL	Stock	189.79	189.79	189.3	189.32	7216.0
2024-05-20 05:30:00	AAPL	Stock	189.3	189.33	188.53	188.66	24053.0
2024-05-20 06:00:00	AAPL	Stock	188.66	188.66	188.27	188.43	10769.0
2024-05-20 06:30:00	AAPL	Stock	188.5	188.88	188.5	188.72	3110.0
2024-05-20 07:00:00	AAPL	Stock	188.75	189.2	188.75	189.1	24741.0
2024-05-20 07:30:00	AAPL	Stock	189.1	189.14	189.0	189.02	4411.0
2024-05-20 08:00:00	AAPL	Stock	188.98	190.35	188.8	189.36	61079.0
2024-05-20 08:30:00	AAPL	Stock	189.35	189.6	189.26	189.26	63990.0
2024-05-20 09:00:00	AAPL	Stock	189.3	189.42	188.87	189.34	116301.0
2024-05-20 09:30:00	AAPL	Stock	189.325	190.905	189.01	190.9	4714794.0
2024-05-20 10:00:00	AAPL	Stock	190.91	191.77	190.81	191.605	4281293.0
2024-05-20 10:30:00	AAPL	Stock	191.6	191.9199	191.32	191.48	2689727.0
2024-05-20 11:00:00	AAPL	Stock	191.4798	191.67	191.17	191.18	1505345.0
2024-05-20 11:30:00	AAPL	Stock	191.175	191.51	191.08	191.275	1255970.0
2024-05-20 12:00:00	AAPL	Stock	191.27	191.39	191.02	191.165	1048150.0
2024-05-20 12:30:00	AAPL	Stock	191.16	191.68	191.16	191.615	1482691.0
2024-05-20 13:00:00	AAPL	Stock	191.615	191.81	191.41	191.464	1382395.0
2024-05-20 13:30:00	AAPL	Stock	191.47	191.62	191.38	191.51	879548.0
2024-05-20 14:00:00	AAPL	Stock	191.51	191.53	191.16	191.41	1062386.0
2024-05-20 14:30:00	AAPL	Stock	191.41	191.5	191.13	191.1794	1099870.0
2024-05-20 15:00:00	AAPL	Stock	191.185	191.39	191.08	191.314	1328329.0
2024-05-20 15:30:00	AAPL	Stock	191.31	191.35	190.81	191.08	4011653.0
2024-05-20 16:00:00	AAPL	Stock	191.04	191.15	191.04	191.0801	8565452.0
2024-05-20 16:30:00	AAPL	Stock	191.08	191.23	191.04	191.2	49771.0
2024-05-20 17:00:00	AAPL	Stock	191.2	191.25	191.2	191.23	9669.0
2024-05-20 17:30:00	AAPL	Stock	191.23	191.23	191.15	191.17	5482.0
2024-05-20 18:00:00	AAPL	Stock	191.17	191.33	191.04	191.28	14856.0
2024-05-20 18:30:00	AAPL	Stock	191.28	191.28	191.07	191.12	8685.0
2024-05-20 19:00:00	AAPL	Stock	191.25	191.25	191.1	191.13	1105.0
2024-05-20 19:30:00	AAPL	Stock	191.17	191.29	191.12	191.19	9125.0
2024-05-20 04:00:00	MSFT	Stock	420.46	421.61	420.46	421.61	1913.0
2024-05-20 04:30:00	MSFT	Stock	420.6	420.6	420.6	420.6	563.0
2024-05-20 05:30:00	MSFT	Stock	421.4	421.57	421.4	421.57	574.0
2024-05-20 06:00:00	MSFT	Stock	421.53	421.53	421.53	421.53	330.0
2024-05-20 07:00:00	MSFT	Stock	421.57	421.57	421.35	421.35	1389.0
2024-05-20 07:30:00	MSFT	Stock	421.35	421.55	421.35	421.4	746.0
2024-05-20 08:00:00	MSFT	Stock	421.3	421.67	420.56	421.4754	17392.0
2024-05-20 08:30:00	MSFT	Stock	421.26	421.5377	421.0	421.0	12203.0
2024-05-20 09:00:00	MSFT	Stock	421.0	421.3	419.38	420.13	17195.0
2024-05-20 09:30:00	MSFT	Stock	420.36	426.77	419.99	426.32	1757867.0
2024-05-20 10:00:00	MSFT	Stock	426.265	426.32	424.36	424.91	730180.0
2024-05-20 10:30:00	MSFT	Stock	424.95	425.68	423.76	423.85	497567.0
2024-05-20 11:00:00	MSFT	Stock	423.8	424.7	423.72	424.48	375485.0
2024-05-20 11:30:00	MSFT	Stock	424.496	425.12	424.46	424.62	317344.0
2024-05-20 12:00:00	MSFT	Stock	424.64	425.12	424.64	425.08	291190.0
2024-05-20 12:30:00	MSFT	Stock	425.04	425.72	424.94	425.66	273766.0
2024-05-20 13:00:00	MSFT	Stock	425.68	425.84	424.39	424.69	408257.0
2024-05-20 13:30:00	MSFT	Stock	424.69	425.05	424.5	424.98	291181.0

> showing 50 of 99,909 rows — these rows as CSV

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