PREVIEW / stock_30min / 2021-09-17

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-17.parquet
  size:    2.2 MB
  rows:    109,348
  symbols: 2,716

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
2021-09-17 04:00:00	AAPL	Stock	149.0	149.1	148.71	148.86	8692.0
2021-09-17 04:30:00	AAPL	Stock	148.82	148.83	148.75	148.83	2499.0
2021-09-17 05:00:00	AAPL	Stock	148.84	148.84	148.6	148.62	2239.0
2021-09-17 05:30:00	AAPL	Stock	148.6	148.6	148.24	148.29	3675.0
2021-09-17 06:00:00	AAPL	Stock	148.37	148.57	148.37	148.43	2440.0
2021-09-17 06:30:00	AAPL	Stock	148.47	148.47	148.47	148.47	254.0
2021-09-17 07:00:00	AAPL	Stock	148.51	148.6	148.37	148.4	18848.0
2021-09-17 07:30:00	AAPL	Stock	148.39	148.55	148.39	148.52	11145.0
2021-09-17 08:00:00	AAPL	Stock	148.57	149.161	148.37	148.9203	192154.0
2021-09-17 08:30:00	AAPL	Stock	148.96	149.0998	148.85	148.94	110922.0
2021-09-17 09:00:00	AAPL	Stock	148.9	149.3	148.7	148.7	247205.0
2021-09-17 09:30:00	AAPL	Stock	148.78	148.82	146.95	147.24	21068987.0
2021-09-17 10:00:00	AAPL	Stock	147.29	147.355	146.56	147.09	9408481.0
2021-09-17 10:30:00	AAPL	Stock	147.0988	147.155	146.55	146.76	5481970.0
2021-09-17 11:00:00	AAPL	Stock	146.76	146.97	146.505	146.535	4364732.0
2021-09-17 11:30:00	AAPL	Stock	146.53	146.6386	146.18	146.4	4912881.0
2021-09-17 12:00:00	AAPL	Stock	146.4	146.745	146.37	146.57	3337368.0
2021-09-17 12:30:00	AAPL	Stock	146.57	146.96	146.55	146.7701	2752998.0
2021-09-17 13:00:00	AAPL	Stock	146.77	146.7801	146.13	146.3043	3488893.0
2021-09-17 13:30:00	AAPL	Stock	146.3071	146.399	145.875	146.12	4124844.0
2021-09-17 14:00:00	AAPL	Stock	146.12	146.28	145.87	145.92	3150244.0
2021-09-17 14:30:00	AAPL	Stock	145.91	146.25	145.76	146.1499	3568848.0
2021-09-17 15:00:00	AAPL	Stock	146.15	146.29	145.86	145.945	3715316.0
2021-09-17 15:30:00	AAPL	Stock	145.94	146.31	145.9	146.03	9004304.0
2021-09-17 16:00:00	AAPL	Stock	146.06	146.09	145.88	145.97	22848903.0
2021-09-17 16:30:00	AAPL	Stock	145.97	146.06	145.85	145.87	205225.0
2021-09-17 17:00:00	AAPL	Stock	145.86	146.02	145.86	145.99	107276.0
2021-09-17 17:30:00	AAPL	Stock	145.99	146.01	145.95	145.99	20712.0
2021-09-17 18:00:00	AAPL	Stock	146.0	146.0	145.75	145.81	58226.0
2021-09-17 18:30:00	AAPL	Stock	145.81	145.87	145.8	145.85	21215.0
2021-09-17 19:00:00	AAPL	Stock	145.84	145.84	145.81	145.83	15718.0
2021-09-17 19:30:00	AAPL	Stock	145.83	145.85	145.75	145.76	39878.0
2021-09-17 04:00:00	MSFT	Stock	305.25	305.25	305.18	305.23	427.0
2021-09-17 04:30:00	MSFT	Stock	305.45	305.45	305.45	305.45	240.0
2021-09-17 05:00:00	MSFT	Stock	305.4	305.6	305.33	305.6	996.0
2021-09-17 05:30:00	MSFT	Stock	305.3	305.3	304.51	304.55	1676.0
2021-09-17 06:00:00	MSFT	Stock	304.97	304.98	304.8	304.8	400.0
2021-09-17 06:30:00	MSFT	Stock	304.8	304.8	304.8	304.8	144.0
2021-09-17 07:00:00	MSFT	Stock	304.8	304.8	304.67	304.77	1524.0
2021-09-17 07:30:00	MSFT	Stock	304.7	304.9	304.7	304.8	1200.0
2021-09-17 08:00:00	MSFT	Stock	304.8152	305.983	304.65	305.45	19633.0
2021-09-17 08:30:00	MSFT	Stock	305.48	305.83	305.23	305.55	24910.0
2021-09-17 09:00:00	MSFT	Stock	305.24	305.95	304.05	304.1	68732.0
2021-09-17 09:30:00	MSFT	Stock	304.63	304.63	301.819	302.36	6820243.0
2021-09-17 10:00:00	MSFT	Stock	302.33	302.42	301.13	301.7565	1487661.0
2021-09-17 10:30:00	MSFT	Stock	301.74	301.74	300.72	301.1767	1493764.0
2021-09-17 11:00:00	MSFT	Stock	301.17	301.3144	300.46	300.565	983639.0
2021-09-17 11:30:00	MSFT	Stock	300.55	300.62	299.86	300.37	1100510.0
2021-09-17 12:00:00	MSFT	Stock	300.37	300.94	300.27	300.71	808749.0
2021-09-17 12:30:00	MSFT	Stock	300.69	301.3	300.68	300.79	669053.0

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

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