PREVIEW / etf_1hour / 2016-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-25.parquet
  size:    252 KB
  rows:    8,125

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
2016-10-25 04:00:00	SPY	ETF	215.16	215.35	215.16	215.35	12390.0
2016-10-25 05:00:00	SPY	ETF	215.31	215.31	215.11	215.11	11202.0
2016-10-25 06:00:00	SPY	ETF	215.11	215.2	214.95	214.97	13078.0
2016-10-25 07:00:00	SPY	ETF	214.89	215.07	214.84	215.0	96026.0
2016-10-25 08:00:00	SPY	ETF	215.0	215.14	214.97	215.05	274375.0
2016-10-25 09:00:00	SPY	ETF	215.05	215.07	214.44	214.8	6370235.0
2016-10-25 10:00:00	SPY	ETF	214.79	214.98	214.065	214.27	12280409.0
2016-10-25 11:00:00	SPY	ETF	214.27	214.51	214.16	214.27	7003499.0
2016-10-25 12:00:00	SPY	ETF	214.2601	214.36	213.98	214.29	6574860.0
2016-10-25 13:00:00	SPY	ETF	214.28	214.51	214.16	214.42	7348757.0
2016-10-25 14:00:00	SPY	ETF	214.42	214.5	214.08	214.125	4472966.0
2016-10-25 15:00:00	SPY	ETF	214.12	214.25	214.03	214.18	14138503.0
2016-10-25 16:00:00	SPY	ETF	214.17	214.3595	213.94	214.07	6416669.0
2016-10-25 17:00:00	SPY	ETF	214.08	214.17	213.9	213.95	280775.0
2016-10-25 18:00:00	SPY	ETF	213.96	213.96	213.72	213.89	98857.0
2016-10-25 19:00:00	SPY	ETF	213.85	213.92	213.85	213.87	30145.0
2016-10-25 04:00:00	QQQ	ETF	119.86	119.91	119.86	119.91	2100.0
2016-10-25 05:00:00	QQQ	ETF	119.92	119.92	119.88	119.88	840.0
2016-10-25 06:00:00	QQQ	ETF	119.85	119.86	119.8	119.82	26096.0
2016-10-25 07:00:00	QQQ	ETF	119.67	119.72	119.65	119.7	11395.0
2016-10-25 08:00:00	QQQ	ETF	119.7	119.8	119.68	119.78	22814.0
2016-10-25 09:00:00	QQQ	ETF	119.74	119.75	119.4	119.58	2202664.0
2016-10-25 10:00:00	QQQ	ETF	119.58	119.66	119.199	119.335	2551711.0
2016-10-25 11:00:00	QQQ	ETF	119.33	119.4184	119.21	119.21	2045155.0
2016-10-25 12:00:00	QQQ	ETF	119.21	119.25	119.05	119.205	1483056.0
2016-10-25 13:00:00	QQQ	ETF	119.2	119.33	119.12	119.28	993924.0
2016-10-25 14:00:00	QQQ	ETF	119.29	119.33	119.04	119.07	801523.0
2016-10-25 15:00:00	QQQ	ETF	119.07	119.16	119.01	119.16	4125694.0
2016-10-25 16:00:00	QQQ	ETF	119.16	119.56	118.84	118.93	2053456.0
2016-10-25 17:00:00	QQQ	ETF	119.0	119.16	118.75	118.82	363997.0
2016-10-25 18:00:00	QQQ	ETF	118.82	118.84	118.77	118.83	23185.0
2016-10-25 19:00:00	QQQ	ETF	118.82	118.88	118.81	118.81	25570.0
2016-10-25 05:00:00	IWM	ETF	122.12	122.12	121.98	121.98	6006.0
2016-10-25 06:00:00	IWM	ETF	121.98	122.0	121.98	121.98	4194.0
2016-10-25 07:00:00	IWM	ETF	121.87	121.96	121.87	121.92	1162.0
2016-10-25 08:00:00	IWM	ETF	122.05	122.07	121.98	121.98	1962.0
2016-10-25 09:00:00	IWM	ETF	122.0	122.0	121.59	121.69	1904443.0
2016-10-25 10:00:00	IWM	ETF	121.69	121.79	120.73	120.95	2949448.0
2016-10-25 11:00:00	IWM	ETF	120.94	121.03	120.77	120.86	2027370.0
2016-10-25 12:00:00	IWM	ETF	120.88	120.99	120.6	120.79	1361879.0
2016-10-25 13:00:00	IWM	ETF	120.78	121.08	120.71	121.02	1118865.0
2016-10-25 14:00:00	IWM	ETF	121.03	121.07	120.79	120.83	639113.0
2016-10-25 15:00:00	IWM	ETF	120.82	120.93	120.72	120.91	3103317.0
2016-10-25 16:00:00	IWM	ETF	120.89	121.01	120.78	120.9	994887.0
2016-10-25 17:00:00	IWM	ETF	120.92	120.92	120.84	120.85	1814.0
2016-10-25 18:00:00	IWM	ETF	120.8	120.8	120.8	120.8	4200.0
2016-10-25 19:00:00	IWM	ETF	120.8	120.8	120.8	120.8	290.0
2016-10-25 04:00:00	DIA	ETF	182.17	182.17	182.17	182.17	100.0
2016-10-25 07:00:00	DIA	ETF	182.01	182.01	182.01	182.01	100.0
2016-10-25 08:00:00	DIA	ETF	182.11	182.11	182.07	182.07	235.0

> showing 50 of 8,125 rows — these rows as CSV

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