PREVIEW / stock_30min / 2023-03-06

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-06.parquet
  size:    2.1 MB
  rows:    102,116
  symbols: 1,802

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-03-06 04:00:00	AAPL	Stock	152.05	152.86	152.05	152.28	34939.0
2023-03-06 04:30:00	AAPL	Stock	152.27	152.36	152.17	152.27	15797.0
2023-03-06 05:00:00	AAPL	Stock	152.32	152.57	152.31	152.47	7558.0
2023-03-06 05:30:00	AAPL	Stock	152.45	152.87	152.3	152.81	20381.0
2023-03-06 06:00:00	AAPL	Stock	152.76	152.88	152.55	152.55	21966.0
2023-03-06 06:30:00	AAPL	Stock	152.55	152.75	152.28	152.75	25712.0
2023-03-06 07:00:00	AAPL	Stock	152.68	153.29	152.5	152.92	111831.0
2023-03-06 07:30:00	AAPL	Stock	152.94	153.49	152.88	153.45	92539.0
2023-03-06 08:00:00	AAPL	Stock	152.7	153.8	150.653	153.8	365591.0
2023-03-06 08:30:00	AAPL	Stock	153.8	154.01	153.6	153.72	294872.0
2023-03-06 09:00:00	AAPL	Stock	153.74	153.91	153.47	153.77	360634.0
2023-03-06 09:30:00	AAPL	Stock	153.77	155.03	153.46	154.4299	12976618.0
2023-03-06 10:00:00	AAPL	Stock	154.41	155.25	154.14	155.03	6011170.0
2023-03-06 10:30:00	AAPL	Stock	155.031	155.58	154.76	155.1467	5212832.0
2023-03-06 11:00:00	AAPL	Stock	155.15	156.07	155.15	155.4	5835574.0
2023-03-06 11:30:00	AAPL	Stock	155.395	155.875	155.3135	155.735	3457045.0
2023-03-06 12:00:00	AAPL	Stock	155.735	156.3	155.6771	155.905	4568383.0
2023-03-06 12:30:00	AAPL	Stock	155.9001	155.9001	154.96	155.06	4278474.0
2023-03-06 13:00:00	AAPL	Stock	155.06	155.445	154.8415	155.1099	3720359.0
2023-03-06 13:30:00	AAPL	Stock	155.1	155.18	154.5	154.55	3315715.0
2023-03-06 14:00:00	AAPL	Stock	154.55	154.63	154.01	154.27	3902989.0
2023-03-06 14:30:00	AAPL	Stock	154.26	154.5	153.96	154.1176	3385259.0
2023-03-06 15:00:00	AAPL	Stock	154.12	154.2958	153.8	153.94	3527250.0
2023-03-06 15:30:00	AAPL	Stock	153.95	154.19	153.7	153.87	5587997.0
2023-03-06 16:00:00	AAPL	Stock	153.89	153.89	153.65	153.728	7430887.0
2023-03-06 16:30:00	AAPL	Stock	153.65	153.83	153.6	153.62	40232.0
2023-03-06 17:00:00	AAPL	Stock	153.62	153.67	153.56	153.64	19903.0
2023-03-06 17:30:00	AAPL	Stock	153.6002	153.83	153.6002	153.7	51139.0
2023-03-06 18:00:00	AAPL	Stock	153.71	153.83	153.65	153.77	53683.0
2023-03-06 18:30:00	AAPL	Stock	153.73	153.9	153.65	153.89	28634.0
2023-03-06 19:00:00	AAPL	Stock	153.85	153.8799	153.72	153.81	10999.0
2023-03-06 19:30:00	AAPL	Stock	153.8799	153.98	153.78	153.78	47938.0
2023-03-06 04:00:00	MSFT	Stock	255.98	255.99	254.86	255.15	10542.0
2023-03-06 04:30:00	MSFT	Stock	254.92	254.92	254.75	254.75	1231.0
2023-03-06 05:00:00	MSFT	Stock	255.19	255.3	255.19	255.3	1219.0
2023-03-06 05:30:00	MSFT	Stock	255.37	255.65	255.3	255.65	548.0
2023-03-06 06:00:00	MSFT	Stock	255.65	256.18	255.52	255.62	3380.0
2023-03-06 06:30:00	MSFT	Stock	255.74	255.74	254.91	255.25	4893.0
2023-03-06 07:00:00	MSFT	Stock	255.45	255.73	255.4	255.58	6494.0
2023-03-06 07:30:00	MSFT	Stock	255.6	255.6	255.5	255.51	1768.0
2023-03-06 08:00:00	MSFT	Stock	255.373	256.81	254.652	256.372	17531.0
2023-03-06 08:30:00	MSFT	Stock	256.3	256.83	256.12	256.12	14032.0
2023-03-06 09:00:00	MSFT	Stock	256.29	256.54	256.12	256.37	26046.0
2023-03-06 09:30:00	MSFT	Stock	256.425	257.97	255.98	257.55	2054559.0
2023-03-06 10:00:00	MSFT	Stock	257.5316	258.78	257.14	258.6293	1167354.0
2023-03-06 10:30:00	MSFT	Stock	258.67	259.89	258.66	259.29	1387878.0
2023-03-06 11:00:00	MSFT	Stock	259.29	260.12	259.15	259.48	1079571.0
2023-03-06 11:30:00	MSFT	Stock	259.48	259.83	258.925	259.38	788729.0
2023-03-06 12:00:00	MSFT	Stock	259.4	259.4	258.57	258.57	640296.0
2023-03-06 12:30:00	MSFT	Stock	258.56	258.6921	257.56	258.44	1124462.0

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

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