PREVIEW / etf_1hour / 2020-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-08.parquet
  size:    395 KB
  rows:    13,459

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-08 04:00:00	SPY	ETF	368.28	368.74	367.59	367.83	26087.0
2020-12-08 05:00:00	SPY	ETF	367.82	367.95	367.54	367.76	25963.0
2020-12-08 06:00:00	SPY	ETF	367.6	367.61	366.41	366.46	67248.0
2020-12-08 07:00:00	SPY	ETF	366.69	367.43	366.69	367.32	199840.0
2020-12-08 08:00:00	SPY	ETF	367.35	368.0	366.7101	367.64	417264.0
2020-12-08 09:00:00	SPY	ETF	367.67	368.55	367.35	368.4801	4953101.0
2020-12-08 10:00:00	SPY	ETF	368.48	369.04	367.73	369.025	5703527.0
2020-12-08 11:00:00	SPY	ETF	369.03	369.79	369.0138	369.64	3394642.0
2020-12-08 12:00:00	SPY	ETF	369.635	370.31	369.52	370.02	2967710.0
2020-12-08 13:00:00	SPY	ETF	370.025	370.36	369.94	370.0616	2263706.0
2020-12-08 14:00:00	SPY	ETF	370.07	370.78	369.9	370.24	3883348.0
2020-12-08 15:00:00	SPY	ETF	370.265	370.39	369.92	370.1599	9429536.0
2020-12-08 16:00:00	SPY	ETF	370.15	370.38	370.0	370.22	5738465.0
2020-12-08 17:00:00	SPY	ETF	370.25	370.51	370.25	370.5	126650.0
2020-12-08 18:00:00	SPY	ETF	370.54	371.41	370.17	370.61	264554.0
2020-12-08 19:00:00	SPY	ETF	370.61	371.26	370.61	371.0	142841.0
2020-12-08 04:00:00	QQQ	ETF	307.06	307.32	306.79	307.03	34892.0
2020-12-08 05:00:00	QQQ	ETF	306.99	307.24	306.95	307.11	5248.0
2020-12-08 06:00:00	QQQ	ETF	307.0	307.04	305.65	305.68	70105.0
2020-12-08 07:00:00	QQQ	ETF	305.76	306.24	305.74	306.24	97722.0
2020-12-08 08:00:00	QQQ	ETF	305.8	307.25	305.73	306.53	98324.0
2020-12-08 09:00:00	QQQ	ETF	306.58	307.03	305.52	306.11	2084095.0
2020-12-08 10:00:00	QQQ	ETF	306.1694	306.58	304.95	306.31	3132796.0
2020-12-08 11:00:00	QQQ	ETF	306.31	307.02	305.9921	306.98	1912809.0
2020-12-08 12:00:00	QQQ	ETF	306.97	307.37	306.82	307.35	1501368.0
2020-12-08 13:00:00	QQQ	ETF	307.37	308.21	307.27	308.06	1617062.0
2020-12-08 14:00:00	QQQ	ETF	308.0509	308.6	307.92	308.34	1544412.0
2020-12-08 15:00:00	QQQ	ETF	308.37	308.53	308.09	308.21	2728040.0
2020-12-08 16:00:00	QQQ	ETF	308.22	308.54	308.19	308.46	551949.0
2020-12-08 17:00:00	QQQ	ETF	308.56	308.58	308.29	308.5	107203.0
2020-12-08 18:00:00	QQQ	ETF	308.59	309.18	308.34	308.51	108098.0
2020-12-08 19:00:00	QQQ	ETF	308.5	308.9	308.44	308.7	54624.0
2020-12-08 04:00:00	IWM	ETF	187.78	188.19	187.35	187.54	9840.0
2020-12-08 05:00:00	IWM	ETF	187.48	187.6	187.3	187.54	7700.0
2020-12-08 06:00:00	IWM	ETF	187.48	187.48	186.74	186.79	21729.0
2020-12-08 07:00:00	IWM	ETF	186.93	187.58	186.84	187.34	73259.0
2020-12-08 08:00:00	IWM	ETF	186.9	188.03	186.9	187.55	130717.0
2020-12-08 09:00:00	IWM	ETF	187.59	189.02	187.08	188.81	2163864.0
2020-12-08 10:00:00	IWM	ETF	188.85	189.08	188.21	189.0	1962911.0
2020-12-08 11:00:00	IWM	ETF	188.9903	189.88	188.989	189.74	1564355.0
2020-12-08 12:00:00	IWM	ETF	189.73	190.395	189.52	190.285	2427635.0
2020-12-08 13:00:00	IWM	ETF	190.29	190.705	190.06	190.54	2111078.0
2020-12-08 14:00:00	IWM	ETF	190.545	190.915	190.33	190.38	1450678.0
2020-12-08 15:00:00	IWM	ETF	190.39	190.98	190.175	190.77	3127186.0
2020-12-08 16:00:00	IWM	ETF	190.8	191.03	190.69	190.92	1096075.0
2020-12-08 17:00:00	IWM	ETF	190.76	191.15	190.76	191.0	19648.0
2020-12-08 18:00:00	IWM	ETF	191.12	191.55	191.12	191.27	30609.0
2020-12-08 19:00:00	IWM	ETF	191.34	191.8	191.34	191.59	53913.0
2020-12-08 04:00:00	DIA	ETF	300.66	300.78	300.19	300.28	600.0
2020-12-08 05:00:00	DIA	ETF	300.12	300.2	300.11	300.2	1100.0

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

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