PREVIEW / etf_1hour / 2014-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-17.parquet
  size:    241 KB
  rows:    7,591

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-12-17 04:00:00	SPY	ETF	198.5	199.03	198.5	198.91	201191.0
2014-12-17 05:00:00	SPY	ETF	198.84	199.13	198.78	198.84	188251.0
2014-12-17 06:00:00	SPY	ETF	198.84	199.03	198.52	199.02	122107.0
2014-12-17 07:00:00	SPY	ETF	199.05	199.42	198.6	198.77	691840.0
2014-12-17 08:00:00	SPY	ETF	199.01	199.39	198.54	198.6	1885204.0
2014-12-17 09:00:00	SPY	ETF	198.57	199.53	198.12	199.4	26434499.0
2014-12-17 10:00:00	SPY	ETF	199.39	199.44	198.51	199.07	23674007.0
2014-12-17 11:00:00	SPY	ETF	199.07	200.7	199.0135	200.57	27156833.0
2014-12-17 12:00:00	SPY	ETF	200.57	200.61	199.56	199.97	19399804.0
2014-12-17 13:00:00	SPY	ETF	199.97	200.43	199.76	200.4	14200839.0
2014-12-17 14:00:00	SPY	ETF	200.4	201.99	200.17	200.44	66696029.0
2014-12-17 15:00:00	SPY	ETF	200.445	202.34	199.78	201.9	52955211.0
2014-12-17 16:00:00	SPY	ETF	201.91	202.15	201.48	202.0	12690953.0
2014-12-17 17:00:00	SPY	ETF	202.0	202.13	202.0	202.06	405753.0
2014-12-17 18:00:00	SPY	ETF	202.06	202.15	201.9	201.97	1227367.0
2014-12-17 19:00:00	SPY	ETF	201.98	202.13	201.94	202.03	140229.0
2014-12-17 05:00:00	QQQ	ETF	100.45	100.51	100.4	100.51	1300.0
2014-12-17 06:00:00	QQQ	ETF	100.37	100.53	100.27	100.53	19500.0
2014-12-17 07:00:00	QQQ	ETF	100.56	100.69	100.35	100.44	152597.0
2014-12-17 08:00:00	QQQ	ETF	100.41	100.59	100.21	100.21	799936.0
2014-12-17 09:00:00	QQQ	ETF	100.23	100.55	99.92	100.52	12118042.0
2014-12-17 10:00:00	QQQ	ETF	100.52	100.62	100.09	100.163	11762199.0
2014-12-17 11:00:00	QQQ	ETF	100.17	101.09	100.16	101.05	7594777.0
2014-12-17 12:00:00	QQQ	ETF	101.04	101.06	100.44	100.63	4468253.0
2014-12-17 13:00:00	QQQ	ETF	100.64	100.93	100.51	100.914	3769725.0
2014-12-17 14:00:00	QQQ	ETF	100.946	101.81	100.4676	101.17	14627451.0
2014-12-17 15:00:00	QQQ	ETF	101.17	102.09	100.805	101.79	11866862.0
2014-12-17 16:00:00	QQQ	ETF	101.79	101.88	99.9791	101.78	3060232.0
2014-12-17 17:00:00	QQQ	ETF	101.78	101.88	101.72	101.78	69565.0
2014-12-17 18:00:00	QQQ	ETF	101.8	101.92	101.8	101.8	17978.0
2014-12-17 19:00:00	QQQ	ETF	101.75	101.81	101.75	101.78	3650.0
2014-12-17 05:00:00	IWM	ETF	113.85	113.85	113.85	113.85	200.0
2014-12-17 06:00:00	IWM	ETF	113.78	113.78	113.78	113.78	1100.0
2014-12-17 07:00:00	IWM	ETF	114.08	114.08	113.69	113.76	123116.0
2014-12-17 08:00:00	IWM	ETF	113.79	113.83	113.54	113.54	340340.0
2014-12-17 09:00:00	IWM	ETF	113.55	114.52	113.33	114.3775	6312800.0
2014-12-17 10:00:00	IWM	ETF	114.39	114.46	113.63	114.235	6054543.0
2014-12-17 11:00:00	IWM	ETF	114.24	115.59	114.14	115.544	8011064.0
2014-12-17 12:00:00	IWM	ETF	115.57	115.6	114.83	114.925	2626922.0
2014-12-17 13:00:00	IWM	ETF	114.92	115.32	114.76	115.11	2131555.0
2014-12-17 14:00:00	IWM	ETF	115.1	116.53	115.03	116.04	14237035.0
2014-12-17 15:00:00	IWM	ETF	116.04	116.99	115.75	116.95	13299214.0
2014-12-17 16:00:00	IWM	ETF	116.95	117.05	113.4307	116.95	3198054.0
2014-12-17 17:00:00	IWM	ETF	116.98	116.99	116.78	116.9	9444.0
2014-12-17 18:00:00	IWM	ETF	116.91	117.0	116.91	116.98	10370.0
2014-12-17 19:00:00	IWM	ETF	116.94	116.97	116.93	116.95	3180.0
2014-12-17 06:00:00	DIA	ETF	171.6	171.6	171.6	171.6	100.0
2014-12-17 08:00:00	DIA	ETF	171.45	171.6	171.39	171.4	1700.0
2014-12-17 09:00:00	DIA	ETF	171.13	172.02	171.08	171.77	1205021.0
2014-12-17 10:00:00	DIA	ETF	171.77	171.8	171.13	171.59	1451439.0

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

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