PREVIEW / stock_30min / 2022-03-18

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-03-18.parquet
  size:    2.2 MB
  rows:    109,466
  symbols: 2,482

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
2022-03-18 04:00:00	AAPL	Stock	159.89	160.05	159.67	160.05	7966.0
2022-03-18 04:30:00	AAPL	Stock	160.07	160.07	159.55	159.61	9308.0
2022-03-18 05:00:00	AAPL	Stock	159.6	159.64	159.36	159.5	4117.0
2022-03-18 05:30:00	AAPL	Stock	159.8	159.85	159.66	159.71	1320.0
2022-03-18 06:00:00	AAPL	Stock	159.78	159.99	159.6	159.71	5860.0
2022-03-18 06:30:00	AAPL	Stock	159.71	159.71	159.35	159.5	5264.0
2022-03-18 07:00:00	AAPL	Stock	159.55	159.62	159.32	159.52	40397.0
2022-03-18 07:30:00	AAPL	Stock	159.54	159.72	159.49	159.49	29987.0
2022-03-18 08:00:00	AAPL	Stock	159.5301	161.021	159.3	159.76	222893.0
2022-03-18 08:30:00	AAPL	Stock	159.72	159.87	159.04	159.53	228232.0
2022-03-18 09:00:00	AAPL	Stock	159.52	161.05	159.41	160.44	1202273.0
2022-03-18 09:30:00	AAPL	Stock	160.46	161.02	159.76	160.985	20475971.0
2022-03-18 10:00:00	AAPL	Stock	160.99	161.92	160.88	161.395	6086516.0
2022-03-18 10:30:00	AAPL	Stock	161.39	161.65	160.82	161.2342	4110094.0
2022-03-18 11:00:00	AAPL	Stock	161.235	162.19	161.16	161.79	4724387.0
2022-03-18 11:30:00	AAPL	Stock	161.78	162.51	161.78	162.34	4564177.0
2022-03-18 12:00:00	AAPL	Stock	162.34	162.61	162.09	162.585	3285212.0
2022-03-18 12:30:00	AAPL	Stock	162.58	162.9	162.42	162.6	3841907.0
2022-03-18 13:00:00	AAPL	Stock	162.595	162.72	162.36	162.63	2953486.0
2022-03-18 13:30:00	AAPL	Stock	162.62	162.73	162.245	162.45	2918518.0
2022-03-18 14:00:00	AAPL	Stock	162.46	163.055	162.42	162.96	3473618.0
2022-03-18 14:30:00	AAPL	Stock	162.96	163.5581	162.83	163.432	4225222.0
2022-03-18 15:00:00	AAPL	Stock	163.43	164.35	163.32	164.125	5596290.0
2022-03-18 15:30:00	AAPL	Stock	164.13	164.48	163.45	163.96	11358367.0
2022-03-18 16:00:00	AAPL	Stock	163.93	164.5	163.7	164.43	26477053.0
2022-03-18 16:30:00	AAPL	Stock	164.41	164.52	163.98	164.37	189095.0
2022-03-18 17:00:00	AAPL	Stock	164.31	164.39	164.15	164.2	30601.0
2022-03-18 17:30:00	AAPL	Stock	164.15	164.22	164.1	164.16	18508.0
2022-03-18 18:00:00	AAPL	Stock	164.16	164.22	164.12	164.15	11530.0
2022-03-18 18:30:00	AAPL	Stock	164.15	164.2	164.08	164.09	9872.0
2022-03-18 19:00:00	AAPL	Stock	164.11	164.15	164.01	164.14	15953.0
2022-03-18 19:30:00	AAPL	Stock	164.12	164.34	164.12	164.34	36190.0
2022-03-18 04:00:00	MSFT	Stock	293.4	294.0	293.4	294.0	1843.0
2022-03-18 04:30:00	MSFT	Stock	293.64	293.64	292.3	292.87	2053.0
2022-03-18 05:00:00	MSFT	Stock	293.0	293.25	292.86	293.0	1646.0
2022-03-18 05:30:00	MSFT	Stock	293.0	293.4	293.0	293.4	2528.0
2022-03-18 06:00:00	MSFT	Stock	293.65	293.65	293.13	293.13	1203.0
2022-03-18 06:30:00	MSFT	Stock	293.24	293.47	292.9	293.07	2019.0
2022-03-18 07:00:00	MSFT	Stock	293.04	293.05	292.5	292.53	9004.0
2022-03-18 07:30:00	MSFT	Stock	292.84	293.4	292.84	293.12	6144.0
2022-03-18 08:00:00	MSFT	Stock	292.7001	294.34	292.5001	293.18	11803.0
2022-03-18 08:30:00	MSFT	Stock	293.35	293.8764	292.57	292.57	4461.0
2022-03-18 09:00:00	MSFT	Stock	293.2	295.24	292.8	294.09	380554.0
2022-03-18 09:30:00	MSFT	Stock	294.38	295.48	292.73	295.075	7721005.0
2022-03-18 10:00:00	MSFT	Stock	295.11	296.82	295.0	296.351	1450785.0
2022-03-18 10:30:00	MSFT	Stock	296.41	297.24	294.63	295.58	1603730.0
2022-03-18 11:00:00	MSFT	Stock	295.58	297.24	295.38	296.7	1239897.0
2022-03-18 11:30:00	MSFT	Stock	296.69	298.09	295.77	296.68	1106580.0
2022-03-18 12:00:00	MSFT	Stock	296.731	296.86	296.1	296.68	861784.0
2022-03-18 12:30:00	MSFT	Stock	296.68	298.14	296.67	297.6731	946227.0

> showing 50 of 109,466 rows — these rows as CSV

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