PREVIEW / etf_1hour / 2019-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-07.parquet
  size:    337 KB
  rows:    11,002

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
2019-10-07 04:00:00	SPY	ETF	293.35	293.35	292.88	292.93	51000.0
2019-10-07 05:00:00	SPY	ETF	293.0	293.12	292.9	293.0	20880.0
2019-10-07 06:00:00	SPY	ETF	293.03	294.01	292.96	293.97	75939.0
2019-10-07 07:00:00	SPY	ETF	293.99	294.0	293.64	293.68	198073.0
2019-10-07 08:00:00	SPY	ETF	293.74	294.0	292.97	293.59	305781.0
2019-10-07 09:00:00	SPY	ETF	293.6	293.743	292.77	293.16	5527835.0
2019-10-07 10:00:00	SPY	ETF	293.16	294.16	292.9995	294.07	5515778.0
2019-10-07 11:00:00	SPY	ETF	294.08	294.84	294.021	294.83	7179926.0
2019-10-07 12:00:00	SPY	ETF	294.82	294.83	294.15	294.34	3071919.0
2019-10-07 13:00:00	SPY	ETF	294.33	295.26	293.77	295.15	7116874.0
2019-10-07 14:00:00	SPY	ETF	295.15	295.21	293.23	293.74	8972715.0
2019-10-07 15:00:00	SPY	ETF	293.75	294.16	293.01	293.11	14032492.0
2019-10-07 16:00:00	SPY	ETF	293.12	293.16	292.85	292.95	7113546.0
2019-10-07 17:00:00	SPY	ETF	292.95	293.01	292.88	292.88	74084.0
2019-10-07 18:00:00	SPY	ETF	292.88	293.1	292.74	293.07	76553.0
2019-10-07 19:00:00	SPY	ETF	293.0	293.12	292.94	293.04	28904.0
2019-10-07 04:00:00	QQQ	ETF	188.17	188.17	187.99	188.02	24029.0
2019-10-07 05:00:00	QQQ	ETF	187.97	188.05	187.91	188.02	10530.0
2019-10-07 06:00:00	QQQ	ETF	188.02	188.72	187.98	188.72	32675.0
2019-10-07 07:00:00	QQQ	ETF	188.72	188.72	188.4	188.41	79718.0
2019-10-07 08:00:00	QQQ	ETF	188.67	188.72	188.02	188.31	103380.0
2019-10-07 09:00:00	QQQ	ETF	188.3	188.69	187.91	188.27	2450565.0
2019-10-07 10:00:00	QQQ	ETF	188.28	189.09	188.06	189.025	1678233.0
2019-10-07 11:00:00	QQQ	ETF	189.04	189.44	189.0	189.4338	1805245.0
2019-10-07 12:00:00	QQQ	ETF	189.43	189.44	188.889	189.0	862453.0
2019-10-07 13:00:00	QQQ	ETF	188.9919	189.74	188.56	189.5603	3025939.0
2019-10-07 14:00:00	QQQ	ETF	189.57	189.6	188.25	188.63	2426797.0
2019-10-07 15:00:00	QQQ	ETF	188.65	188.91	188.15	188.21	4823138.0
2019-10-07 16:00:00	QQQ	ETF	188.21	188.4	188.09	188.3	1325069.0
2019-10-07 17:00:00	QQQ	ETF	188.27	188.36	188.25	188.25	11250.0
2019-10-07 18:00:00	QQQ	ETF	188.25	188.41	188.12	188.37	29981.0
2019-10-07 19:00:00	QQQ	ETF	188.37	188.49	188.3	188.39	13998.0
2019-10-07 04:00:00	IWM	ETF	148.3	148.3	148.11	148.29	5900.0
2019-10-07 05:00:00	IWM	ETF	148.25	148.29	148.25	148.29	1500.0
2019-10-07 06:00:00	IWM	ETF	148.29	148.87	148.29	148.87	13613.0
2019-10-07 07:00:00	IWM	ETF	148.9	148.91	148.68	148.72	5600.0
2019-10-07 08:00:00	IWM	ETF	148.8298	148.83	148.3	148.7	27824.0
2019-10-07 09:00:00	IWM	ETF	148.69	149.02	148.12	148.8	1920894.0
2019-10-07 10:00:00	IWM	ETF	148.79	149.455	148.62	149.34	2120068.0
2019-10-07 11:00:00	IWM	ETF	149.34	149.79	149.16	149.44	1820651.0
2019-10-07 12:00:00	IWM	ETF	149.46	149.6216	149.27	149.6	538554.0
2019-10-07 13:00:00	IWM	ETF	149.59	150.07	149.0	149.9	2050796.0
2019-10-07 14:00:00	IWM	ETF	149.91	149.92	148.68	149.13	1270550.0
2019-10-07 15:00:00	IWM	ETF	149.13	149.31	148.82	148.9	2423669.0
2019-10-07 16:00:00	IWM	ETF	148.88	148.97	148.73	148.84	1741660.0
2019-10-07 17:00:00	IWM	ETF	148.86	148.86	148.7	148.76	23035.0
2019-10-07 18:00:00	IWM	ETF	148.72	148.93	148.69	148.93	13699.0
2019-10-07 19:00:00	IWM	ETF	148.89	148.93	148.89	148.93	2820.0
2019-10-07 04:00:00	DIA	ETF	264.47	264.55	264.3	264.3	1042.0
2019-10-07 05:00:00	DIA	ETF	264.39	264.39	264.39	264.39	1000.0

> showing 50 of 11,002 rows — these rows as CSV

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