PREVIEW / etf_1hour / 2021-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-02.parquet
  size:    431 KB
  rows:    15,228

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.07	459.58	459.6	14247.0
2021-11-02 05:00:00	SPY	ETF	459.57	459.95	459.38	459.78	92367.0
2021-11-02 06:00:00	SPY	ETF	459.84	459.97	459.54	459.96	56007.0
2021-11-02 07:00:00	SPY	ETF	460.13	460.36	459.9	460.16	90075.0
2021-11-02 08:00:00	SPY	ETF	460.15	460.5	459.6304	460.32	133413.0
2021-11-02 09:00:00	SPY	ETF	460.33	461.28	460.08	461.16	4330784.0
2021-11-02 10:00:00	SPY	ETF	461.17	461.73	460.73	461.59	4833087.0
2021-11-02 11:00:00	SPY	ETF	461.595	462.2221	461.26	461.413	4289630.0
2021-11-02 12:00:00	SPY	ETF	461.42	462.1	461.07	461.94	2955039.0
2021-11-02 13:00:00	SPY	ETF	461.95	462.06	461.305	461.66	2426075.0
2021-11-02 14:00:00	SPY	ETF	461.65	461.93	461.2201	461.91	3606819.0
2021-11-02 15:00:00	SPY	ETF	461.9	462.04	461.37	461.87	8755547.0
2021-11-02 16:00:00	SPY	ETF	461.86	461.9	461.5	461.66	3073478.0
2021-11-02 17:00:00	SPY	ETF	461.66	461.9	461.57	461.61	178706.0
2021-11-02 18:00:00	SPY	ETF	461.65	461.9	461.43	461.49	69875.0
2021-11-02 19:00:00	SPY	ETF	461.5	461.55	461.42	461.42	29326.0
2021-11-02 04:00:00	QQQ	ETF	387.19	387.19	386.68	386.68	52711.0
2021-11-02 05:00:00	QQQ	ETF	386.68	386.84	386.44	386.71	66716.0
2021-11-02 06:00:00	QQQ	ETF	386.71	386.88	386.64	386.78	68277.0
2021-11-02 07:00:00	QQQ	ETF	386.83	387.02	386.6	386.72	284620.0
2021-11-02 08:00:00	QQQ	ETF	386.8001	387.72	386.62	386.8	441458.0
2021-11-02 09:00:00	QQQ	ETF	386.82	389.25	386.75	388.955	3696575.0
2021-11-02 10:00:00	QQQ	ETF	388.955	389.11	387.48	388.83	3453643.0
2021-11-02 11:00:00	QQQ	ETF	388.86	389.54	388.43	388.55	2081800.0
2021-11-02 12:00:00	QQQ	ETF	388.51	388.99	387.9	388.89	1501519.0
2021-11-02 13:00:00	QQQ	ETF	388.91	389.0321	388.1622	388.5	1336794.0
2021-11-02 14:00:00	QQQ	ETF	388.51	388.85	387.75	388.81	2227826.0
2021-11-02 15:00:00	QQQ	ETF	388.8	389.49	388.6016	389.11	3649041.0
2021-11-02 16:00:00	QQQ	ETF	389.11	389.165	388.88	389.02	860271.0
2021-11-02 17:00:00	QQQ	ETF	389.01	389.05	388.8	388.9	373852.0
2021-11-02 18:00:00	QQQ	ETF	388.93	388.93	388.6	388.68	43965.0
2021-11-02 19:00:00	QQQ	ETF	388.73	388.75	388.61	388.61	31691.0
2021-11-02 04:00:00	IWM	ETF	234.45	234.73	234.26	234.28	16303.0
2021-11-02 05:00:00	IWM	ETF	234.19	234.58	234.1	234.23	10572.0
2021-11-02 06:00:00	IWM	ETF	234.31	234.4	234.0	234.39	7093.0
2021-11-02 07:00:00	IWM	ETF	234.44	234.61	234.25	234.55	45732.0
2021-11-02 08:00:00	IWM	ETF	234.46	234.94	233.96	234.54	64936.0
2021-11-02 09:00:00	IWM	ETF	234.54	234.6	232.65	233.6851	3224968.0
2021-11-02 10:00:00	IWM	ETF	233.67	234.85	233.31	234.31	4373095.0
2021-11-02 11:00:00	IWM	ETF	234.32	234.68	233.3	233.38	2673375.0
2021-11-02 12:00:00	IWM	ETF	233.38	234.185	233.295	233.79	1738378.0
2021-11-02 13:00:00	IWM	ETF	233.8	233.86	233.13	233.68	1556421.0
2021-11-02 14:00:00	IWM	ETF	233.7	234.34	233.41	234.22	1614970.0
2021-11-02 15:00:00	IWM	ETF	234.22	234.5	233.9	234.48	2537454.0
2021-11-02 16:00:00	IWM	ETF	234.45	234.57	234.21	234.49	929157.0
2021-11-02 17:00:00	IWM	ETF	234.56	234.59	234.36	234.54	393865.0
2021-11-02 18:00:00	IWM	ETF	234.54	234.67	234.45	234.52	27093.0
2021-11-02 19:00:00	IWM	ETF	234.47	234.62	234.43	234.52	19195.0
2021-11-02 04:00:00	DIA	ETF	359.0	359.0	359.0	359.0	224.0
2021-11-02 06:00:00	DIA	ETF	359.14	359.14	359.14	359.14	400.0

> showing 50 of 15,228 rows — these rows as CSV

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