PREVIEW / etf_1hour / 2014-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-11.parquet
  size:    219 KB
  rows:    7,007

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-11 04:00:00	SPY	ETF	199.85	199.88	199.44	199.56	43744.0
2014-09-11 05:00:00	SPY	ETF	199.56	199.64	199.53	199.64	12589.0
2014-09-11 06:00:00	SPY	ETF	199.63	199.73	199.5	199.52	56634.0
2014-09-11 07:00:00	SPY	ETF	199.52	199.62	199.31	199.34	325820.0
2014-09-11 08:00:00	SPY	ETF	199.34	199.87	199.11	199.19	1232526.0
2014-09-11 09:00:00	SPY	ETF	199.16	199.89	199.16	199.87	9405607.0
2014-09-11 10:00:00	SPY	ETF	199.87	199.95	199.12	199.46	11290198.0
2014-09-11 11:00:00	SPY	ETF	199.46	199.97	199.46	199.84	8889713.0
2014-09-11 12:00:00	SPY	ETF	199.84	200.13	199.69	199.86	7419577.0
2014-09-11 13:00:00	SPY	ETF	199.87	199.96	199.5	199.675	5316582.0
2014-09-11 14:00:00	SPY	ETF	199.675	200.19	199.64	200.04	5981588.0
2014-09-11 15:00:00	SPY	ETF	200.04	200.33	199.9	200.28	11697733.0
2014-09-11 16:00:00	SPY	ETF	200.29	200.5	199.8313	200.5	4243135.0
2014-09-11 17:00:00	SPY	ETF	200.49	200.52	200.45	200.49	102591.0
2014-09-11 18:00:00	SPY	ETF	200.5	200.5	200.32	200.32	53080.0
2014-09-11 19:00:00	SPY	ETF	200.35	200.35	200.32	200.33	26825.0
2014-09-11 04:00:00	QQQ	ETF	99.84	99.84	99.77	99.77	16000.0
2014-09-11 05:00:00	QQQ	ETF	99.8	99.82	99.76	99.82	1700.0
2014-09-11 06:00:00	QQQ	ETF	99.88	99.91	99.8	99.8	9052.0
2014-09-11 07:00:00	QQQ	ETF	99.8	99.88	99.73	99.74	124798.0
2014-09-11 08:00:00	QQQ	ETF	99.75	100.07	99.58	99.6	359010.0
2014-09-11 09:00:00	QQQ	ETF	99.6	99.93	99.55	99.91	3757023.0
2014-09-11 10:00:00	QQQ	ETF	99.911	99.94	99.38	99.535	4464308.0
2014-09-11 11:00:00	QQQ	ETF	99.54	99.81	99.51	99.6801	2855080.0
2014-09-11 12:00:00	QQQ	ETF	99.69	99.83	99.53	99.61	2051255.0
2014-09-11 13:00:00	QQQ	ETF	99.615	99.65	99.24	99.36	3318704.0
2014-09-11 14:00:00	QQQ	ETF	99.36	99.77	99.34	99.7	3121704.0
2014-09-11 15:00:00	QQQ	ETF	99.7	100.04	99.661	100.01	5110424.0
2014-09-11 16:00:00	QQQ	ETF	100.01	100.1	99.6193	100.1	1891290.0
2014-09-11 17:00:00	QQQ	ETF	100.1	100.12	100.05	100.09	25969.0
2014-09-11 18:00:00	QQQ	ETF	100.1	100.1	100.02	100.03	22180.0
2014-09-11 19:00:00	QQQ	ETF	100.03	100.04	100.02	100.03	14898.0
2014-09-11 06:00:00	IWM	ETF	115.6	115.6	115.53	115.53	588.0
2014-09-11 07:00:00	IWM	ETF	115.53	115.61	115.31	115.33	20100.0
2014-09-11 08:00:00	IWM	ETF	115.35	115.42	115.04	115.09	327658.0
2014-09-11 09:00:00	IWM	ETF	115.08	115.78	115.08	115.74	3092676.0
2014-09-11 10:00:00	IWM	ETF	115.74	115.87	115.23	115.65	4127139.0
2014-09-11 11:00:00	IWM	ETF	115.65	116.07	115.65	115.95	2401238.0
2014-09-11 12:00:00	IWM	ETF	115.95	116.25	115.95	116.06	2610070.0
2014-09-11 13:00:00	IWM	ETF	116.06	116.12	115.73	115.91	1692912.0
2014-09-11 14:00:00	IWM	ETF	115.91	116.73	115.88	116.6	3857809.0
2014-09-11 15:00:00	IWM	ETF	116.6	116.65	116.4	116.6	4794421.0
2014-09-11 16:00:00	IWM	ETF	116.61	116.83	116.5759	116.81	1053799.0
2014-09-11 17:00:00	IWM	ETF	116.8	116.8	116.76	116.79	64889.0
2014-09-11 18:00:00	IWM	ETF	116.72	116.72	116.72	116.72	400.0
2014-09-11 19:00:00	IWM	ETF	116.7	116.7	116.7	116.7	2560.0
2014-09-11 04:00:00	DIA	ETF	171.5	171.5	170.08	170.08	2200.0
2014-09-11 05:00:00	DIA	ETF	170.3	170.3	170.3	170.3	1000.0
2014-09-11 07:00:00	DIA	ETF	170.25	170.25	170.06	170.06	4150.0
2014-09-11 08:00:00	DIA	ETF	170.24	170.24	169.9	169.9	8000.0

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

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