PREVIEW / etf_1hour / 2020-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-10.parquet
  size:    384 KB
  rows:    13,403

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
2020-12-10 04:00:00	SPY	ETF	367.1	368.09	367.1	367.72	26249.0
2020-12-10 05:00:00	SPY	ETF	367.66	367.93	367.64	367.71	18473.0
2020-12-10 06:00:00	SPY	ETF	367.73	367.78	367.35	367.52	63783.0
2020-12-10 07:00:00	SPY	ETF	367.56	367.58	366.18	366.49	383998.0
2020-12-10 08:00:00	SPY	ETF	366.44	367.87	365.2	365.26	684664.0
2020-12-10 09:00:00	SPY	ETF	365.28	367.38	364.43	367.18	6491960.0
2020-12-10 10:00:00	SPY	ETF	367.18	367.71	366.56	367.445	5311485.0
2020-12-10 11:00:00	SPY	ETF	367.45	367.86	366.205	366.37	5225553.0
2020-12-10 12:00:00	SPY	ETF	366.34	367.25	366.22	366.48	5502058.0
2020-12-10 13:00:00	SPY	ETF	366.49	367.38	366.36	366.58	3776095.0
2020-12-10 14:00:00	SPY	ETF	366.6	367.2041	365.75	366.015	10286221.0
2020-12-10 15:00:00	SPY	ETF	366.02	367.48	365.95	366.72	11616866.0
2020-12-10 16:00:00	SPY	ETF	366.7	366.85	366.18	366.6	4365093.0
2020-12-10 17:00:00	SPY	ETF	366.55	367.15	366.53	367.13	1751438.0
2020-12-10 18:00:00	SPY	ETF	367.1	367.38	366.57	367.22	97280.0
2020-12-10 19:00:00	SPY	ETF	367.2	367.45	366.83	367.09	65454.0
2020-12-10 04:00:00	QQQ	ETF	301.26	301.69	301.1	301.49	34337.0
2020-12-10 05:00:00	QQQ	ETF	301.58	301.94	301.51	301.51	23296.0
2020-12-10 06:00:00	QQQ	ETF	301.55	301.69	301.14	301.22	24943.0
2020-12-10 07:00:00	QQQ	ETF	301.26	301.43	299.65	299.98	303903.0
2020-12-10 08:00:00	QQQ	ETF	301.23	301.37	298.95	299.059	549886.0
2020-12-10 09:00:00	QQQ	ETF	299.04	302.12	298.09	301.9	5677972.0
2020-12-10 10:00:00	QQQ	ETF	301.89	303.38	301.32	303.2	4241123.0
2020-12-10 11:00:00	QQQ	ETF	303.185	303.68	301.85	302.03	2812738.0
2020-12-10 12:00:00	QQQ	ETF	302.03	302.79	301.32	301.54	2096772.0
2020-12-10 13:00:00	QQQ	ETF	301.58	302.8599	301.48	302.3	1598327.0
2020-12-10 14:00:00	QQQ	ETF	302.311	302.5	301.44	301.5999	1886562.0
2020-12-10 15:00:00	QQQ	ETF	301.59	303.22	301.5419	302.43	2879821.0
2020-12-10 16:00:00	QQQ	ETF	302.44	303.5553	302.1	302.25	630026.0
2020-12-10 17:00:00	QQQ	ETF	302.21	302.45	302.21	302.25	16388.0
2020-12-10 18:00:00	QQQ	ETF	302.25	302.75	301.92	302.63	78803.0
2020-12-10 19:00:00	QQQ	ETF	302.62	302.85	302.24	302.39	32248.0
2020-12-10 04:00:00	IWM	ETF	189.79	190.29	189.76	190.0	11517.0
2020-12-10 05:00:00	IWM	ETF	190.06	190.16	189.94	190.06	5483.0
2020-12-10 06:00:00	IWM	ETF	190.09	190.1	189.75	189.94	3531.0
2020-12-10 07:00:00	IWM	ETF	189.96	189.98	189.06	189.51	78161.0
2020-12-10 08:00:00	IWM	ETF	189.2101	189.8	187.53	187.61	183167.0
2020-12-10 09:00:00	IWM	ETF	187.64	189.67	187.305	189.45	2400259.0
2020-12-10 10:00:00	IWM	ETF	189.48	190.5	189.23	190.39	2414515.0
2020-12-10 11:00:00	IWM	ETF	190.38	190.42	189.46	189.535	1686771.0
2020-12-10 12:00:00	IWM	ETF	189.53	190.79	189.47	190.53	1459399.0
2020-12-10 13:00:00	IWM	ETF	190.55	191.15	190.39	190.605	2001994.0
2020-12-10 14:00:00	IWM	ETF	190.64	190.74	189.955	190.355	1720047.0
2020-12-10 15:00:00	IWM	ETF	190.37	191.65	190.345	191.24	3595288.0
2020-12-10 16:00:00	IWM	ETF	191.24	191.5	191.08	191.3	1360978.0
2020-12-10 17:00:00	IWM	ETF	191.11	191.86	191.11	191.86	51002.0
2020-12-10 18:00:00	IWM	ETF	191.8	191.95	191.24	191.85	25090.0
2020-12-10 19:00:00	IWM	ETF	191.89	192.04	191.7	191.85	11467.0
2020-12-10 04:00:00	DIA	ETF	301.52	301.8	301.52	301.59	1700.0
2020-12-10 05:00:00	DIA	ETF	301.83	301.83	301.74	301.74	1750.0

> showing 50 of 13,403 rows — these rows as CSV

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