PREVIEW / etf_1hour / 2016-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-22.parquet
  size:    277 KB
  rows:    8,858

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-11-22 04:00:00	SPY	ETF	220.48	220.63	220.48	220.57	13627.0
2016-11-22 05:00:00	SPY	ETF	220.54	220.54	220.4	220.41	7060.0
2016-11-22 06:00:00	SPY	ETF	220.45	220.45	220.35	220.44	114230.0
2016-11-22 07:00:00	SPY	ETF	220.41	220.45	220.34	220.35	110155.0
2016-11-22 08:00:00	SPY	ETF	220.35	220.45	220.19	220.29	170525.0
2016-11-22 09:00:00	SPY	ETF	220.29	220.63	220.28	220.5	8661494.0
2016-11-22 10:00:00	SPY	ETF	220.49	220.65	220.12	220.19	9624557.0
2016-11-22 11:00:00	SPY	ETF	220.19	220.26	219.73	219.8	7373858.0
2016-11-22 12:00:00	SPY	ETF	219.8	220.09	219.73	220.07	7447218.0
2016-11-22 13:00:00	SPY	ETF	220.08	220.25	220.07	220.13	4913107.0
2016-11-22 14:00:00	SPY	ETF	220.14	220.46	220.05	220.34	6879988.0
2016-11-22 15:00:00	SPY	ETF	220.34	220.79	220.325	220.53	14526685.0
2016-11-22 16:00:00	SPY	ETF	220.54	220.7	220.52	220.7	5451455.0
2016-11-22 17:00:00	SPY	ETF	220.66	220.69	220.58	220.65	299038.0
2016-11-22 18:00:00	SPY	ETF	220.64	220.64	220.54	220.54	51777.0
2016-11-22 19:00:00	SPY	ETF	220.54	220.61	220.54	220.6	83128.0
2016-11-22 04:00:00	QQQ	ETF	118.91	119.01	118.9	119.01	2000.0
2016-11-22 05:00:00	QQQ	ETF	118.95	118.98	118.95	118.95	2445.0
2016-11-22 06:00:00	QQQ	ETF	118.95	118.95	118.92	118.92	858.0
2016-11-22 07:00:00	QQQ	ETF	118.95	119.03	118.93	119.0	23138.0
2016-11-22 08:00:00	QQQ	ETF	118.98	119.0	118.83	118.85	55775.0
2016-11-22 09:00:00	QQQ	ETF	118.85	119.19	118.85	118.9401	2834957.0
2016-11-22 10:00:00	QQQ	ETF	118.95	119.19	118.715	118.85	2439565.0
2016-11-22 11:00:00	QQQ	ETF	118.85	118.96	118.61	118.82	2126361.0
2016-11-22 12:00:00	QQQ	ETF	118.82	118.98	118.72	118.89	1056860.0
2016-11-22 13:00:00	QQQ	ETF	118.899	119.02	118.85	118.87	1465133.0
2016-11-22 14:00:00	QQQ	ETF	118.865	118.89	118.69	118.82	1324933.0
2016-11-22 15:00:00	QQQ	ETF	118.82	119.03	118.79	118.9	2700577.0
2016-11-22 16:00:00	QQQ	ETF	118.91	119.03	118.85	119.03	1588286.0
2016-11-22 17:00:00	QQQ	ETF	118.99	119.03	118.99	119.03	2787.0
2016-11-22 18:00:00	QQQ	ETF	119.0	119.0	118.96	118.96	1678.0
2016-11-22 19:00:00	QQQ	ETF	118.96	119.01	118.95	119.01	6864.0
2016-11-22 04:00:00	IWM	ETF	132.09	132.19	132.09	132.19	1000.0
2016-11-22 05:00:00	IWM	ETF	132.11	132.15	132.07	132.07	560.0
2016-11-22 06:00:00	IWM	ETF	132.15	132.16	132.11	132.14	5541.0
2016-11-22 07:00:00	IWM	ETF	132.17	132.17	132.03	132.04	68968.0
2016-11-22 08:00:00	IWM	ETF	132.04	132.09	131.87	132.02	131492.0
2016-11-22 09:00:00	IWM	ETF	132.02	132.32	131.67	132.1911	4415498.0
2016-11-22 10:00:00	IWM	ETF	132.2	132.37	131.9	132.07	6154618.0
2016-11-22 11:00:00	IWM	ETF	132.07	132.2	131.72	131.83	3732034.0
2016-11-22 12:00:00	IWM	ETF	131.82	132.24	131.7	132.21	2255445.0
2016-11-22 13:00:00	IWM	ETF	132.21	132.33	132.14	132.18	1732829.0
2016-11-22 14:00:00	IWM	ETF	132.19	132.5289	132.16	132.4	2428950.0
2016-11-22 15:00:00	IWM	ETF	132.395	132.9	132.37	132.82	5769577.0
2016-11-22 16:00:00	IWM	ETF	132.81	132.99	132.74	132.91	766085.0
2016-11-22 17:00:00	IWM	ETF	132.92	132.96	132.9	132.9	13450.0
2016-11-22 18:00:00	IWM	ETF	132.91	132.95	132.8	132.91	21900.0
2016-11-22 19:00:00	IWM	ETF	132.9	133.0	132.9	133.0	24177.0
2016-11-22 04:00:00	DIA	ETF	189.63	189.77	189.63	189.77	400.0
2016-11-22 07:00:00	DIA	ETF	189.77	189.77	189.77	189.77	100.0

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

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