PREVIEW / etf_1hour / 2014-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-08.parquet
  size:    221 KB
  rows:    6,974

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
2014-09-08 04:00:00	SPY	ETF	201.0	201.0	200.81	200.86	40515.0
2014-09-08 05:00:00	SPY	ETF	200.94	200.94	200.8	200.86	47070.0
2014-09-08 06:00:00	SPY	ETF	200.83	200.92	200.8	200.86	96521.0
2014-09-08 07:00:00	SPY	ETF	200.85	200.94	200.77	200.9	125835.0
2014-09-08 08:00:00	SPY	ETF	200.93	200.99	200.77	200.8	477607.0
2014-09-08 09:00:00	SPY	ETF	200.81	201.18	200.81	201.04	6332509.0
2014-09-08 10:00:00	SPY	ETF	201.04	201.21	200.53	200.87	9336588.0
2014-09-08 11:00:00	SPY	ETF	200.88	201.05	200.63	200.685	6382078.0
2014-09-08 12:00:00	SPY	ETF	200.68	200.84	200.5899	200.75	4370539.0
2014-09-08 13:00:00	SPY	ETF	200.745	200.81	200.0	200.15	13302832.0
2014-09-08 14:00:00	SPY	ETF	200.14	200.43	200.11	200.36	5824402.0
2014-09-08 15:00:00	SPY	ETF	200.355	201.01	200.355	200.6	12419458.0
2014-09-08 16:00:00	SPY	ETF	200.61	200.72	200.57	200.71	3629462.0
2014-09-08 17:00:00	SPY	ETF	200.71	200.73	200.62	200.62	32961.0
2014-09-08 18:00:00	SPY	ETF	200.62	200.67	200.55	200.57	16900.0
2014-09-08 19:00:00	SPY	ETF	200.59	200.62	200.55	200.6	23816.0
2014-09-08 04:00:00	QQQ	ETF	99.75	99.78	99.6	99.6	27593.0
2014-09-08 06:00:00	QQQ	ETF	99.76	99.81	99.74	99.77	80500.0
2014-09-08 07:00:00	QQQ	ETF	99.76	99.83	99.74	99.8	17730.0
2014-09-08 08:00:00	QQQ	ETF	99.84	99.86	99.77	99.77	115561.0
2014-09-08 09:00:00	QQQ	ETF	99.78	100.3	99.78	100.26	3632239.0
2014-09-08 10:00:00	QQQ	ETF	100.26	100.33	100.02	100.25	3856219.0
2014-09-08 11:00:00	QQQ	ETF	100.25	100.28	99.97	99.979	2130948.0
2014-09-08 12:00:00	QQQ	ETF	99.97	100.13	99.94	100.068	1160865.0
2014-09-08 13:00:00	QQQ	ETF	100.06	100.12	99.62	99.7368	3136714.0
2014-09-08 14:00:00	QQQ	ETF	99.73	99.91	99.72	99.86	1577267.0
2014-09-08 15:00:00	QQQ	ETF	99.87	100.12	99.86	100.08	4266820.0
2014-09-08 16:00:00	QQQ	ETF	100.08	100.09	99.9581	100.09	2117533.0
2014-09-08 17:00:00	QQQ	ETF	100.11	100.11	100.06	100.08	2564.0
2014-09-08 18:00:00	QQQ	ETF	100.05	100.05	100.02	100.02	7764.0
2014-09-08 19:00:00	QQQ	ETF	100.02	100.04	100.01	100.04	6000.0
2014-09-08 04:00:00	IWM	ETF	116.15	116.15	116.15	116.15	500.0
2014-09-08 05:00:00	IWM	ETF	116.18	116.25	116.18	116.25	1000.0
2014-09-08 07:00:00	IWM	ETF	116.16	116.31	116.15	116.29	4750.0
2014-09-08 08:00:00	IWM	ETF	116.29	116.34	116.14	116.14	115793.0
2014-09-08 09:00:00	IWM	ETF	116.2	116.8	116.17	116.69	2486482.0
2014-09-08 10:00:00	IWM	ETF	116.7	116.78	115.99	116.54	4090465.0
2014-09-08 11:00:00	IWM	ETF	116.54	116.69	116.13	116.14	2438315.0
2014-09-08 12:00:00	IWM	ETF	116.13	116.39	116.03	116.3	1372320.0
2014-09-08 13:00:00	IWM	ETF	116.305	116.36	115.83	116.0	2641718.0
2014-09-08 14:00:00	IWM	ETF	116.0	116.255	115.98	116.21	2083031.0
2014-09-08 15:00:00	IWM	ETF	116.22	116.55	116.19	116.55	3224502.0
2014-09-08 16:00:00	IWM	ETF	116.56	116.67	116.54	116.65	1099081.0
2014-09-08 17:00:00	IWM	ETF	116.66	116.66	116.24	116.64	2070.0
2014-09-08 19:00:00	IWM	ETF	116.47	116.47	116.47	116.47	100.0
2014-09-08 05:00:00	DIA	ETF	170.96	170.96	170.95	170.95	2000.0
2014-09-08 06:00:00	DIA	ETF	170.95	170.95	170.95	170.95	300.0
2014-09-08 07:00:00	DIA	ETF	170.91	170.91	170.88	170.88	900.0
2014-09-08 08:00:00	DIA	ETF	170.9	170.9	170.89	170.89	3300.0
2014-09-08 09:00:00	DIA	ETF	170.94	171.26	170.85	171.16	692809.0

> showing 50 of 6,974 rows — these rows as CSV

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