PREVIEW / etf_1hour / 2017-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-04.parquet
  size:    278 KB
  rows:    9,033

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
2017-05-04 04:00:00	SPY	ETF	238.6	238.91	238.6	238.9	29956.0
2017-05-04 05:00:00	SPY	ETF	238.89	239.15	238.89	239.11	26881.0
2017-05-04 06:00:00	SPY	ETF	239.11	239.15	239.05	239.08	60521.0
2017-05-04 07:00:00	SPY	ETF	239.12	239.25	239.08	239.12	186083.0
2017-05-04 08:00:00	SPY	ETF	239.16	239.21	238.79	238.88	675406.0
2017-05-04 09:00:00	SPY	ETF	238.86	238.96	238.27	238.41	5685249.0
2017-05-04 10:00:00	SPY	ETF	238.42	238.84	238.37	238.58	8512604.0
2017-05-04 11:00:00	SPY	ETF	238.575	238.84	238.445	238.49	9094031.0
2017-05-04 12:00:00	SPY	ETF	238.5	238.56	237.78	238.5	10563392.0
2017-05-04 13:00:00	SPY	ETF	238.5	238.66	238.3	238.52	5505748.0
2017-05-04 14:00:00	SPY	ETF	238.5289	238.77	238.21	238.5	7533779.0
2017-05-04 15:00:00	SPY	ETF	238.5	238.795	238.4	238.75	9233420.0
2017-05-04 16:00:00	SPY	ETF	238.74	238.82	238.52	238.79	3390672.0
2017-05-04 17:00:00	SPY	ETF	238.79	238.83	238.73	238.74	274357.0
2017-05-04 18:00:00	SPY	ETF	238.74	238.74	238.66	238.7	69226.0
2017-05-04 19:00:00	SPY	ETF	238.72	238.8	238.7	238.76	15023.0
2017-05-04 04:00:00	QQQ	ETF	137.04	137.07	137.04	137.07	10797.0
2017-05-04 05:00:00	QQQ	ETF	137.1	137.21	137.09	137.2	2700.0
2017-05-04 06:00:00	QQQ	ETF	137.17	137.24	137.17	137.18	9796.0
2017-05-04 07:00:00	QQQ	ETF	137.22	137.29	137.22	137.28	36189.0
2017-05-04 08:00:00	QQQ	ETF	137.2	137.28	137.04	137.04	100354.0
2017-05-04 09:00:00	QQQ	ETF	137.03	137.12	136.56	136.66	2011830.0
2017-05-04 10:00:00	QQQ	ETF	136.66	137.08	136.64	136.91	2048205.0
2017-05-04 11:00:00	QQQ	ETF	136.91	137.43	136.87	136.98	1475013.0
2017-05-04 12:00:00	QQQ	ETF	136.99	137.06	136.629	137.03	2158980.0
2017-05-04 13:00:00	QQQ	ETF	137.03	137.12	136.9	137.01	1283053.0
2017-05-04 14:00:00	QQQ	ETF	137.0	137.12	136.81	136.9899	1769905.0
2017-05-04 15:00:00	QQQ	ETF	136.98	137.1	136.92	137.04	2814428.0
2017-05-04 16:00:00	QQQ	ETF	137.04	137.14	136.98	137.14	517524.0
2017-05-04 17:00:00	QQQ	ETF	137.16	137.16	137.06	137.06	6312.0
2017-05-04 18:00:00	QQQ	ETF	137.11	137.11	137.0	137.03	18224.0
2017-05-04 19:00:00	QQQ	ETF	137.05	137.06	137.04	137.06	4607.0
2017-05-04 04:00:00	IWM	ETF	138.29	138.66	138.29	138.66	3600.0
2017-05-04 05:00:00	IWM	ETF	138.83	138.9	138.8	138.86	13100.0
2017-05-04 06:00:00	IWM	ETF	138.87	138.89	138.83	138.83	4631.0
2017-05-04 07:00:00	IWM	ETF	138.81	138.93	138.81	138.89	31435.0
2017-05-04 08:00:00	IWM	ETF	138.91	138.94	138.65	138.67	187719.0
2017-05-04 09:00:00	IWM	ETF	138.65	138.73	138.14	138.285	1794013.0
2017-05-04 10:00:00	IWM	ETF	138.28	138.39	137.73	137.85	3280400.0
2017-05-04 11:00:00	IWM	ETF	137.84	138.06	137.69	137.73	1921502.0
2017-05-04 12:00:00	IWM	ETF	137.72	137.78	137.11	137.7	3810346.0
2017-05-04 13:00:00	IWM	ETF	137.71	137.83	137.44	137.705	1472028.0
2017-05-04 14:00:00	IWM	ETF	137.7	138.2	137.63	137.97	2830777.0
2017-05-04 15:00:00	IWM	ETF	137.96	138.16	137.79	138.09	3378139.0
2017-05-04 16:00:00	IWM	ETF	138.1	138.28	137.97	138.27	3131494.0
2017-05-04 17:00:00	IWM	ETF	138.25	138.29	138.2	138.2	5672.0
2017-05-04 18:00:00	IWM	ETF	138.15	138.15	138.15	138.15	150.0
2017-05-04 19:00:00	IWM	ETF	138.17	138.2	138.17	138.17	900.0
2017-05-04 05:00:00	DIA	ETF	209.53	209.69	209.53	209.68	1000.0
2017-05-04 07:00:00	DIA	ETF	209.75	209.79	209.75	209.75	3350.0

> showing 50 of 9,033 rows — these rows as CSV

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