PREVIEW / etf_30min / 2021-11-02

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-02.parquet
  size:    630 KB
  rows:    24,415

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-11-02 04:00:00	SPY	ETF	459.84	460.02	459.81	459.93	6550.0
2021-11-02 04:30:00	SPY	ETF	459.97	460.07	459.58	459.6	7697.0
2021-11-02 05:00:00	SPY	ETF	459.57	459.95	459.38	459.8	58250.0
2021-11-02 05:30:00	SPY	ETF	459.87	459.87	459.62	459.78	34117.0
2021-11-02 06:00:00	SPY	ETF	459.84	459.84	459.54	459.81	40621.0
2021-11-02 06:30:00	SPY	ETF	459.9	459.97	459.8	459.96	15386.0
2021-11-02 07:00:00	SPY	ETF	460.13	460.13	459.9	460.03	62652.0
2021-11-02 07:30:00	SPY	ETF	460.0	460.36	460.0	460.16	27423.0
2021-11-02 08:00:00	SPY	ETF	460.15	460.42	459.6304	460.33	68042.0
2021-11-02 08:30:00	SPY	ETF	460.31	460.5	460.31	460.32	65371.0
2021-11-02 09:00:00	SPY	ETF	460.33	460.43	460.13	460.21	97986.0
2021-11-02 09:30:00	SPY	ETF	460.21	461.28	460.08	461.16	4232798.0
2021-11-02 10:00:00	SPY	ETF	461.17	461.43	460.73	461.22	2568718.0
2021-11-02 10:30:00	SPY	ETF	461.22	461.73	461.08	461.59	2264369.0
2021-11-02 11:00:00	SPY	ETF	461.595	461.82	461.26	461.79	1913267.0
2021-11-02 11:30:00	SPY	ETF	461.79	462.2221	461.37	461.413	2376363.0
2021-11-02 12:00:00	SPY	ETF	461.42	461.77	461.07	461.69	1637540.0
2021-11-02 12:30:00	SPY	ETF	461.7	462.1	461.57	461.94	1317499.0
2021-11-02 13:00:00	SPY	ETF	461.95	462.06	461.55	461.55	1288330.0
2021-11-02 13:30:00	SPY	ETF	461.56	461.785	461.305	461.66	1137745.0
2021-11-02 14:00:00	SPY	ETF	461.65	461.725	461.2201	461.455	1797070.0
2021-11-02 14:30:00	SPY	ETF	461.45	461.93	461.32	461.91	1809749.0
2021-11-02 15:00:00	SPY	ETF	461.9	462.0	461.52	461.805	1943734.0
2021-11-02 15:30:00	SPY	ETF	461.8	462.04	461.37	461.87	6811813.0
2021-11-02 16:00:00	SPY	ETF	461.86	461.9	461.5	461.67	2988090.0
2021-11-02 16:30:00	SPY	ETF	461.66	461.78	461.63	461.66	85388.0
2021-11-02 17:00:00	SPY	ETF	461.66	461.77	461.65	461.7	30027.0
2021-11-02 17:30:00	SPY	ETF	461.7	461.9	461.57	461.61	148679.0
2021-11-02 18:00:00	SPY	ETF	461.65	461.65	461.43	461.51	61048.0
2021-11-02 18:30:00	SPY	ETF	461.9	461.9	461.4501	461.49	8827.0
2021-11-02 19:00:00	SPY	ETF	461.5	461.55	461.42	461.52	18185.0
2021-11-02 19:30:00	SPY	ETF	461.5	461.54	461.42	461.42	11141.0
2021-11-02 04:00:00	QQQ	ETF	387.19	387.19	386.81	386.95	37377.0
2021-11-02 04:30:00	QQQ	ETF	386.9	387.06	386.68	386.68	15334.0
2021-11-02 05:00:00	QQQ	ETF	386.68	386.84	386.5	386.79	25769.0
2021-11-02 05:30:00	QQQ	ETF	386.76	386.82	386.44	386.71	40947.0
2021-11-02 06:00:00	QQQ	ETF	386.71	386.79	386.64	386.68	6071.0
2021-11-02 06:30:00	QQQ	ETF	386.73	386.88	386.66	386.78	62206.0
2021-11-02 07:00:00	QQQ	ETF	386.83	386.84	386.6	386.77	225748.0
2021-11-02 07:30:00	QQQ	ETF	386.78	387.02	386.72	386.72	58872.0
2021-11-02 08:00:00	QQQ	ETF	386.8001	387.72	386.62	386.85	60589.0
2021-11-02 08:30:00	QQQ	ETF	386.84	387.22	386.8	386.8	380869.0
2021-11-02 09:00:00	QQQ	ETF	386.82	387.03	386.8	386.8	223139.0
2021-11-02 09:30:00	QQQ	ETF	386.8	389.25	386.75	388.955	3473436.0
2021-11-02 10:00:00	QQQ	ETF	388.955	389.09	387.48	388.76	2309816.0
2021-11-02 10:30:00	QQQ	ETF	388.79	389.11	388.43	388.83	1143827.0
2021-11-02 11:00:00	QQQ	ETF	388.86	389.2301	388.43	388.95	1035772.0
2021-11-02 11:30:00	QQQ	ETF	388.95	389.54	388.4969	388.55	1046028.0
2021-11-02 12:00:00	QQQ	ETF	388.51	388.64	387.9	388.56	952943.0
2021-11-02 12:30:00	QQQ	ETF	388.56	388.99	388.18	388.89	548576.0

> showing 50 of 24,415 rows — these rows as CSV

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