PREVIEW / etf_1hour / 2019-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-04.parquet
  size:    332 KB
  rows:    10,652

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-04 04:00:00	SPY	ETF	290.25	290.33	289.75	289.82	32031.0
2019-10-04 05:00:00	SPY	ETF	289.8	289.88	289.36	289.4	21902.0
2019-10-04 06:00:00	SPY	ETF	289.4	289.74	289.2	289.44	74930.0
2019-10-04 07:00:00	SPY	ETF	289.36	289.73	289.3	289.53	287657.0
2019-10-04 08:00:00	SPY	ETF	289.4301	291.43	289.1	291.24	2149739.0
2019-10-04 09:00:00	SPY	ETF	291.2	292.3	290.98	292.29	6346227.0
2019-10-04 10:00:00	SPY	ETF	292.28	292.7	291.39	291.85	8985764.0
2019-10-04 11:00:00	SPY	ETF	291.86	293.14	291.65	292.9	7646149.0
2019-10-04 12:00:00	SPY	ETF	292.895	293.12	292.7433	292.91	3141740.0
2019-10-04 13:00:00	SPY	ETF	292.91	293.36	292.75	293.03	2955035.0
2019-10-04 14:00:00	SPY	ETF	293.04	293.72	292.93	293.574	4432239.0
2019-10-04 15:00:00	SPY	ETF	293.58	294.63	293.51	294.37	17595526.0
2019-10-04 16:00:00	SPY	ETF	294.37	294.55	294.19	294.42	10996590.0
2019-10-04 17:00:00	SPY	ETF	294.32	294.45	294.22	294.4	851600.0
2019-10-04 18:00:00	SPY	ETF	294.43	294.46	294.35	294.4	117143.0
2019-10-04 19:00:00	SPY	ETF	294.4	294.65	294.39	294.65	18904.0
2019-10-04 04:00:00	QQQ	ETF	186.13	186.33	185.85	185.93	25490.0
2019-10-04 05:00:00	QQQ	ETF	185.95	185.95	185.53	185.58	57281.0
2019-10-04 06:00:00	QQQ	ETF	185.61	185.81	185.5	185.67	33050.0
2019-10-04 07:00:00	QQQ	ETF	185.71	185.93	185.57	185.82	162177.0
2019-10-04 08:00:00	QQQ	ETF	185.84	187.18	185.56	187.09	1288608.0
2019-10-04 09:00:00	QQQ	ETF	187.0	187.75	186.84	187.73	6190308.0
2019-10-04 10:00:00	QQQ	ETF	187.73	187.96	187.03	187.46	3852076.0
2019-10-04 11:00:00	QQQ	ETF	187.475	188.4	187.3	188.2	3708676.0
2019-10-04 12:00:00	QQQ	ETF	188.2	188.34	188.04	188.13	1620616.0
2019-10-04 13:00:00	QQQ	ETF	188.13	188.49	188.03	188.15	1644995.0
2019-10-04 14:00:00	QQQ	ETF	188.15	188.72	188.055	188.61	1802482.0
2019-10-04 15:00:00	QQQ	ETF	188.61	189.08	188.5	188.89	6506143.0
2019-10-04 16:00:00	QQQ	ETF	188.89	189.01	188.66	189.0	1906511.0
2019-10-04 17:00:00	QQQ	ETF	188.91	188.99	188.83	188.83	31697.0
2019-10-04 18:00:00	QQQ	ETF	188.93	188.95	188.89	188.9	10820.0
2019-10-04 19:00:00	QQQ	ETF	188.9	188.96	188.89	188.96	10720.0
2019-10-04 04:00:00	IWM	ETF	147.36	147.36	147.36	147.36	1600.0
2019-10-04 05:00:00	IWM	ETF	147.36	147.36	147.04	147.05	4600.0
2019-10-04 06:00:00	IWM	ETF	147.26	147.26	147.1	147.25	2700.0
2019-10-04 07:00:00	IWM	ETF	147.14	147.24	147.09	147.24	20508.0
2019-10-04 08:00:00	IWM	ETF	147.13	148.15	146.83	148.13	335276.0
2019-10-04 09:00:00	IWM	ETF	148.05	148.7175	147.91	148.39	2119822.0
2019-10-04 10:00:00	IWM	ETF	148.38	148.54	147.12	147.37	2663795.0
2019-10-04 11:00:00	IWM	ETF	147.36	148.13	147.14	148.015	2428890.0
2019-10-04 12:00:00	IWM	ETF	148.03	148.33	147.91	148.1	793016.0
2019-10-04 13:00:00	IWM	ETF	148.09	148.49	147.91	148.22	1312891.0
2019-10-04 14:00:00	IWM	ETF	148.24	148.66	148.23	148.5	1466226.0
2019-10-04 15:00:00	IWM	ETF	148.51	149.25	148.47	149.15	3941437.0
2019-10-04 16:00:00	IWM	ETF	149.16	149.1842	149.0	149.05	847994.0
2019-10-04 17:00:00	IWM	ETF	149.08	149.14	149.04	149.05	77367.0
2019-10-04 18:00:00	IWM	ETF	149.05	149.13	149.05	149.13	3300.0
2019-10-04 19:00:00	IWM	ETF	149.07	149.14	149.07	149.08	6163.0
2019-10-04 04:00:00	DIA	ETF	261.9	261.9	261.64	261.64	200.0
2019-10-04 06:00:00	DIA	ETF	261.24	261.24	261.06	261.08	412.0

> showing 50 of 10,652 rows — these rows as CSV

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