PREVIEW / etf_1hour / 2019-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-08.parquet
  size:    340 KB
  rows:    11,230

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-08 04:00:00	SPY	ETF	292.65	293.08	292.65	292.86	29001.0
2019-10-08 05:00:00	SPY	ETF	292.84	292.95	292.1	292.3	114516.0
2019-10-08 06:00:00	SPY	ETF	292.3	292.3	291.25	291.54	256473.0
2019-10-08 07:00:00	SPY	ETF	291.58	291.7	290.49	291.3	871145.0
2019-10-08 08:00:00	SPY	ETF	291.26	293.99	290.89	291.23	688261.0
2019-10-08 09:00:00	SPY	ETF	291.25	291.54	289.66	289.66	10799879.0
2019-10-08 10:00:00	SPY	ETF	289.66	290.23	289.07	290.16	12492878.0
2019-10-08 11:00:00	SPY	ETF	290.15	290.38	288.88	289.55	7830122.0
2019-10-08 12:00:00	SPY	ETF	289.54	291.11	289.2984	290.34	8572183.0
2019-10-08 13:00:00	SPY	ETF	290.33	291.045	290.08	290.62	4967212.0
2019-10-08 14:00:00	SPY	ETF	290.63	291.85	289.69	290.47	13787298.0
2019-10-08 15:00:00	SPY	ETF	290.46	291.12	288.49	288.55	24921063.0
2019-10-08 16:00:00	SPY	ETF	288.55	293.1257	288.47	288.72	10322253.0
2019-10-08 17:00:00	SPY	ETF	288.73	290.9	288.56	288.72	1712009.0
2019-10-08 18:00:00	SPY	ETF	288.73	288.93	288.27	288.42	130627.0
2019-10-08 19:00:00	SPY	ETF	288.33	288.68	288.23	288.53	75644.0
2019-10-08 04:00:00	QQQ	ETF	188.24	188.37	188.09	188.23	124721.0
2019-10-08 05:00:00	QQQ	ETF	188.23	188.3	187.74	187.91	110835.0
2019-10-08 06:00:00	QQQ	ETF	187.85	187.85	187.1	187.27	174835.0
2019-10-08 07:00:00	QQQ	ETF	187.31	187.49	186.57	187.19	222236.0
2019-10-08 08:00:00	QQQ	ETF	187.15	188.17	186.76	187.09	470656.0
2019-10-08 09:00:00	QQQ	ETF	187.11	188.24	185.94	186.01	4737852.0
2019-10-08 10:00:00	QQQ	ETF	186.02	186.54	185.54	186.51	4579161.0
2019-10-08 11:00:00	QQQ	ETF	186.48	186.73	185.74	186.21	2760173.0
2019-10-08 12:00:00	QQQ	ETF	186.21	187.34	186.01	186.76	2038483.0
2019-10-08 13:00:00	QQQ	ETF	186.75	187.25	186.54	186.89	1619513.0
2019-10-08 14:00:00	QQQ	ETF	186.9	187.8562	186.06	186.7	4861296.0
2019-10-08 15:00:00	QQQ	ETF	186.68	187.21	185.27	185.3	7035769.0
2019-10-08 16:00:00	QQQ	ETF	185.32	185.6	185.25	185.46	860556.0
2019-10-08 17:00:00	QQQ	ETF	185.5	185.5	185.28	185.44	21163.0
2019-10-08 18:00:00	QQQ	ETF	185.45	185.64	185.2	185.2	38644.0
2019-10-08 19:00:00	QQQ	ETF	185.1	185.36	185.06	185.33	25337.0
2019-10-08 04:00:00	IWM	ETF	148.62	148.62	148.62	148.62	200.0
2019-10-08 05:00:00	IWM	ETF	148.73	148.79	148.42	148.42	2590.0
2019-10-08 06:00:00	IWM	ETF	148.0	148.12	147.84	147.92	17590.0
2019-10-08 07:00:00	IWM	ETF	147.88	147.88	147.38	147.59	29334.0
2019-10-08 08:00:00	IWM	ETF	147.54	149.37	147.28	147.5	52601.0
2019-10-08 09:00:00	IWM	ETF	147.49	147.67	146.6	146.65	1993838.0
2019-10-08 10:00:00	IWM	ETF	146.655	147.11	146.11	147.045	2959508.0
2019-10-08 11:00:00	IWM	ETF	147.045	147.22	146.19	146.71	1789488.0
2019-10-08 12:00:00	IWM	ETF	146.72	147.31	146.43	146.72	1264788.0
2019-10-08 13:00:00	IWM	ETF	146.7	147.21	146.56	146.98	728386.0
2019-10-08 14:00:00	IWM	ETF	146.99	147.93	146.75	147.14	2471733.0
2019-10-08 15:00:00	IWM	ETF	147.12	147.52	146.39	146.46	3681573.0
2019-10-08 16:00:00	IWM	ETF	146.47	146.62	146.36	146.46	1022117.0
2019-10-08 17:00:00	IWM	ETF	146.49	146.49	146.44	146.44	400.0
2019-10-08 18:00:00	IWM	ETF	146.49	146.61	146.37	146.37	17570.0
2019-10-08 19:00:00	IWM	ETF	146.35	146.45	146.32	146.45	3600.0
2019-10-08 05:00:00	DIA	ETF	263.86	263.86	263.86	263.86	100.0
2019-10-08 06:00:00	DIA	ETF	263.18	263.18	263.18	263.18	100.0

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

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