PREVIEW / stock_30min / 2023-03-07

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-07.parquet
  size:    2.1 MB
  rows:    99,864
  symbols: 1,803

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-07 04:00:00	AAPL	Stock	154.0	154.72	153.98	154.29	11518.0
2023-03-07 04:30:00	AAPL	Stock	154.29	154.36	154.15	154.15	6409.0
2023-03-07 05:00:00	AAPL	Stock	154.16	154.29	154.16	154.29	1256.0
2023-03-07 05:30:00	AAPL	Stock	154.19	154.33	154.19	154.2	2414.0
2023-03-07 06:00:00	AAPL	Stock	154.26	154.33	154.15	154.15	3121.0
2023-03-07 06:30:00	AAPL	Stock	154.16	154.28	154.15	154.18	9396.0
2023-03-07 07:00:00	AAPL	Stock	154.3	154.38	154.14	154.14	27604.0
2023-03-07 07:30:00	AAPL	Stock	154.12	154.2	154.06	154.13	8990.0
2023-03-07 08:00:00	AAPL	Stock	154.19	154.7	153.446	153.99	98829.0
2023-03-07 08:30:00	AAPL	Stock	154.0	154.19	153.95	153.95	68376.0
2023-03-07 09:00:00	AAPL	Stock	153.97	153.97	153.49	153.64	128951.0
2023-03-07 09:30:00	AAPL	Stock	153.64	154.0299	153.15	153.855	5220308.0
2023-03-07 10:00:00	AAPL	Stock	153.86	153.86	151.78	152.451	6170085.0
2023-03-07 10:30:00	AAPL	Stock	152.45	153.63	152.08	152.1914	4397942.0
2023-03-07 11:00:00	AAPL	Stock	152.21	152.67	152.08	152.255	2691551.0
2023-03-07 11:30:00	AAPL	Stock	152.25	152.77	151.97	152.0656	2757442.0
2023-03-07 12:00:00	AAPL	Stock	152.06	153.0899	151.8	152.6499	2738927.0
2023-03-07 12:30:00	AAPL	Stock	152.6491	152.73	152.34	152.4288	1929790.0
2023-03-07 13:00:00	AAPL	Stock	152.42	152.54	152.1	152.4917	1905641.0
2023-03-07 13:30:00	AAPL	Stock	152.4817	152.69	151.74	151.83	2446477.0
2023-03-07 14:00:00	AAPL	Stock	151.82	152.04	151.4622	151.4989	2279189.0
2023-03-07 14:30:00	AAPL	Stock	151.49	151.665	151.14	151.1795	2162863.0
2023-03-07 15:00:00	AAPL	Stock	151.18	151.44	151.13	151.185	2218143.0
2023-03-07 15:30:00	AAPL	Stock	151.19	151.77	151.16	151.58	4723012.0
2023-03-07 16:00:00	AAPL	Stock	151.57	151.65	151.45	151.58	5263761.0
2023-03-07 16:30:00	AAPL	Stock	151.59	151.72	151.54	151.5966	42607.0
2023-03-07 17:00:00	AAPL	Stock	151.57	151.64	151.53	151.58	8015.0
2023-03-07 17:30:00	AAPL	Stock	151.5514	151.58	151.53	151.53	4897.0
2023-03-07 18:00:00	AAPL	Stock	151.57	151.7	151.57	151.58	11247.0
2023-03-07 18:30:00	AAPL	Stock	151.65	151.75	151.58	151.64	11367.0
2023-03-07 19:00:00	AAPL	Stock	151.69	151.75	151.4	151.48	14057.0
2023-03-07 19:30:00	AAPL	Stock	151.49	151.55	151.37	151.43	11911.0
2023-03-07 04:00:00	MSFT	Stock	257.64	257.64	257.5	257.5	1093.0
2023-03-07 04:30:00	MSFT	Stock	257.62	257.62	257.14	257.14	486.0
2023-03-07 05:00:00	MSFT	Stock	257.25	257.4	257.25	257.4	797.0
2023-03-07 05:30:00	MSFT	Stock	257.4	257.43	257.4	257.43	500.0
2023-03-07 06:00:00	MSFT	Stock	257.45	257.45	257.23	257.23	1208.0
2023-03-07 06:30:00	MSFT	Stock	257.22	257.23	256.99	256.99	1565.0
2023-03-07 07:00:00	MSFT	Stock	257.08	257.21	256.85	256.85	3316.0
2023-03-07 07:30:00	MSFT	Stock	256.85	257.25	256.85	257.15	2520.0
2023-03-07 08:00:00	MSFT	Stock	257.2481	258.4	257.0	258.01	12645.0
2023-03-07 08:30:00	MSFT	Stock	258.02	258.3	257.56	257.68	7583.0
2023-03-07 09:00:00	MSFT	Stock	257.61	257.61	256.0	256.3	29861.0
2023-03-07 09:30:00	MSFT	Stock	256.35	257.69	256.05	256.92	1477942.0
2023-03-07 10:00:00	MSFT	Stock	256.87	256.87	254.04	254.8098	1575064.0
2023-03-07 10:30:00	MSFT	Stock	254.8497	256.425	254.5801	254.705	1236275.0
2023-03-07 11:00:00	MSFT	Stock	254.74	255.72	254.55	254.6	778945.0
2023-03-07 11:30:00	MSFT	Stock	254.6	255.69	254.51	254.72	727391.0
2023-03-07 12:00:00	MSFT	Stock	254.69	256.34	254.61	255.72	642149.0
2023-03-07 12:30:00	MSFT	Stock	255.7	256.08	255.14	255.47	692777.0

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

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