PREVIEW / etf_1hour / 2016-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-12.parquet
  size:    248 KB
  rows:    7,964

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-08-12 04:00:00	SPY	ETF	218.64	218.79	218.64	218.71	4500.0
2016-08-12 05:00:00	SPY	ETF	218.71	218.77	218.71	218.71	7140.0
2016-08-12 06:00:00	SPY	ETF	218.73	218.79	218.69	218.69	9085.0
2016-08-12 07:00:00	SPY	ETF	218.7	218.7	218.59	218.69	52649.0
2016-08-12 08:00:00	SPY	ETF	218.74	218.74	218.31	218.4	758732.0
2016-08-12 09:00:00	SPY	ETF	218.4	218.46	218.11	218.375	7635458.0
2016-08-12 10:00:00	SPY	ETF	218.38	218.68	218.27	218.61	7166965.0
2016-08-12 11:00:00	SPY	ETF	218.615	218.71	218.41	218.49	5538433.0
2016-08-12 12:00:00	SPY	ETF	218.485	218.53	218.24	218.285	4220667.0
2016-08-12 13:00:00	SPY	ETF	218.28	218.2852	217.99	218.13	4646123.0
2016-08-12 14:00:00	SPY	ETF	218.13	218.39	218.08	218.31	4083920.0
2016-08-12 15:00:00	SPY	ETF	218.3199	218.57	218.27	218.45	12202732.0
2016-08-12 16:00:00	SPY	ETF	218.46	218.54	218.41	218.52	11671415.0
2016-08-12 17:00:00	SPY	ETF	218.52	218.52	218.44	218.44	64523.0
2016-08-12 18:00:00	SPY	ETF	218.45	218.46	218.4	218.41	47823.0
2016-08-12 19:00:00	SPY	ETF	218.44	218.45	218.43	218.45	5018.0
2016-08-12 04:00:00	QQQ	ETF	117.18	117.18	117.15	117.15	200.0
2016-08-12 05:00:00	QQQ	ETF	117.19	117.19	117.19	117.19	100.0
2016-08-12 07:00:00	QQQ	ETF	117.12	117.14	117.11	117.14	30453.0
2016-08-12 08:00:00	QQQ	ETF	117.16	117.18	116.98	117.05	84872.0
2016-08-12 09:00:00	QQQ	ETF	117.06	117.08	116.79	116.9542	2943934.0
2016-08-12 10:00:00	QQQ	ETF	116.96	117.06	116.84	117.04	1931977.0
2016-08-12 11:00:00	QQQ	ETF	117.05	117.15	116.97	117.03	1705195.0
2016-08-12 12:00:00	QQQ	ETF	117.02	117.06	116.93	116.99	1618450.0
2016-08-12 13:00:00	QQQ	ETF	116.9966	117.0	116.83	116.94	1062879.0
2016-08-12 14:00:00	QQQ	ETF	116.93	117.11	116.9	117.08	877267.0
2016-08-12 15:00:00	QQQ	ETF	117.085	117.21	117.07	117.1975	2395120.0
2016-08-12 16:00:00	QQQ	ETF	117.2	117.26	117.1024	117.25	2022662.0
2016-08-12 17:00:00	QQQ	ETF	117.17	117.24	117.12	117.24	3500.0
2016-08-12 18:00:00	QQQ	ETF	117.2	117.2	117.12	117.12	7717.0
2016-08-12 19:00:00	QQQ	ETF	117.12	117.2	117.11	117.2	7888.0
2016-08-12 20:00:00	QQQ	ETF	117.1941	117.1941	117.1941	117.1941	140000.0
2016-08-12 07:00:00	IWM	ETF	122.11	122.15	122.05	122.15	30500.0
2016-08-12 08:00:00	IWM	ETF	122.15	122.15	121.81	121.84	115441.0
2016-08-12 09:00:00	IWM	ETF	121.9	122.22	121.75	122.14	1644812.0
2016-08-12 10:00:00	IWM	ETF	122.15	122.46	122.0	122.37	2134964.0
2016-08-12 11:00:00	IWM	ETF	122.38	122.45	122.0	122.08	1442493.0
2016-08-12 12:00:00	IWM	ETF	122.07	122.13	121.74	121.86	1743503.0
2016-08-12 13:00:00	IWM	ETF	121.85	121.855	121.63	121.79	1067885.0
2016-08-12 14:00:00	IWM	ETF	121.77	122.15	121.75	122.09	775320.0
2016-08-12 15:00:00	IWM	ETF	122.09	122.27	122.08	122.19	1800654.0
2016-08-12 16:00:00	IWM	ETF	122.19	122.21	122.07	122.12	682375.0
2016-08-12 17:00:00	IWM	ETF	122.11	122.11	122.11	122.11	127.0
2016-08-12 20:00:00	IWM	ETF	122.2058	122.2058	122.2058	122.2058	400000.0
2016-08-12 08:00:00	DIA	ETF	186.3	186.3	186.16	186.16	800.0
2016-08-12 09:00:00	DIA	ETF	186.09	186.15	185.87	186.09	962222.0
2016-08-12 10:00:00	DIA	ETF	186.08	186.25	185.99	186.19	223400.0
2016-08-12 11:00:00	DIA	ETF	186.2	186.24	185.89	185.94	149700.0
2016-08-12 12:00:00	DIA	ETF	185.94	185.9593	185.69	185.78	243828.0
2016-08-12 13:00:00	DIA	ETF	185.75	185.77	185.5185	185.64	132774.0

> showing 50 of 7,964 rows — these rows as CSV

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