PREVIEW / etf_1hour / 2014-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-04.parquet
  size:    226 KB
  rows:    7,118

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-04 04:00:00	SPY	ETF	200.45	200.55	200.4	200.4	3400.0
2014-09-04 05:00:00	SPY	ETF	200.3	200.66	200.3	200.66	5285.0
2014-09-04 06:00:00	SPY	ETF	200.67	201.04	200.65	201.0	92467.0
2014-09-04 07:00:00	SPY	ETF	200.98	201.4	200.9	200.95	858905.0
2014-09-04 08:00:00	SPY	ETF	200.63	201.36	200.05	200.94	6359411.0
2014-09-04 09:00:00	SPY	ETF	200.91	201.38	200.7	201.28	10371345.0
2014-09-04 10:00:00	SPY	ETF	201.29	201.56	201.18	201.44	10088956.0
2014-09-04 11:00:00	SPY	ETF	201.44	201.58	201.02	201.11	8347474.0
2014-09-04 12:00:00	SPY	ETF	201.11	201.22	200.88	200.99	5790754.0
2014-09-04 13:00:00	SPY	ETF	200.98	201.08	200.82	200.83	3334539.0
2014-09-04 14:00:00	SPY	ETF	200.84	200.98	200.11	200.2	8708436.0
2014-09-04 15:00:00	SPY	ETF	200.195	200.24	199.66	200.22	22823013.0
2014-09-04 16:00:00	SPY	ETF	200.21	201.5	200.13	200.54	4231723.0
2014-09-04 17:00:00	SPY	ETF	200.54	200.56	200.45	200.47	3379842.0
2014-09-04 18:00:00	SPY	ETF	200.47	200.49	200.4	200.48	149606.0
2014-09-04 19:00:00	SPY	ETF	200.48	200.51	200.44	200.47	81100.0
2014-09-04 04:00:00	QQQ	ETF	99.3	99.3	99.24	99.24	10900.0
2014-09-04 05:00:00	QQQ	ETF	99.37	99.51	99.37	99.51	1200.0
2014-09-04 06:00:00	QQQ	ETF	99.54	99.71	99.54	99.69	19550.0
2014-09-04 07:00:00	QQQ	ETF	99.76	99.82	99.66	99.66	71450.0
2014-09-04 08:00:00	QQQ	ETF	99.78	99.88	99.67	99.72	217178.0
2014-09-04 09:00:00	QQQ	ETF	99.74	100.15	99.6	100.08	4210736.0
2014-09-04 10:00:00	QQQ	ETF	100.09	100.22	100.0167	100.12	3546115.0
2014-09-04 11:00:00	QQQ	ETF	100.12	100.2	99.88	99.92	2591079.0
2014-09-04 12:00:00	QQQ	ETF	99.92	100.0	99.76	99.8238	1675993.0
2014-09-04 13:00:00	QQQ	ETF	99.82	99.94	99.79	99.84	1090782.0
2014-09-04 14:00:00	QQQ	ETF	99.84	99.95	99.425	99.48	2636206.0
2014-09-04 15:00:00	QQQ	ETF	99.48	99.5	99.14	99.38	5675944.0
2014-09-04 16:00:00	QQQ	ETF	99.38	100.0272	99.37	99.52	2118236.0
2014-09-04 17:00:00	QQQ	ETF	99.51	99.52	99.51	99.52	6752.0
2014-09-04 18:00:00	QQQ	ETF	99.52	99.7199	99.49	99.51	110721.0
2014-09-04 19:00:00	QQQ	ETF	99.5	99.51	99.47	99.47	7200.0
2014-09-04 06:00:00	IWM	ETF	116.66	116.75	116.66	116.74	42450.0
2014-09-04 07:00:00	IWM	ETF	116.74	116.95	116.46	116.7	119875.0
2014-09-04 08:00:00	IWM	ETF	116.74	117.16	116.66	116.81	619454.0
2014-09-04 09:00:00	IWM	ETF	116.88	117.22	116.67	117.06	3868457.0
2014-09-04 10:00:00	IWM	ETF	117.08	117.49	117.01	117.24	3745710.0
2014-09-04 11:00:00	IWM	ETF	117.24	117.43	116.95	117.035	2643619.0
2014-09-04 12:00:00	IWM	ETF	117.03	117.12	116.68	116.81	1848713.0
2014-09-04 13:00:00	IWM	ETF	116.8	116.84	116.56	116.606	1194171.0
2014-09-04 14:00:00	IWM	ETF	116.6	116.73	116.19	116.245	2284567.0
2014-09-04 15:00:00	IWM	ETF	116.24	116.27	115.7202	116.0	7718913.0
2014-09-04 16:00:00	IWM	ETF	116.0	117.3691	115.99	116.17	751018.0
2014-09-04 17:00:00	IWM	ETF	116.15	116.17	116.1	116.1	13447.0
2014-09-04 18:00:00	IWM	ETF	116.12	116.12	116.1	116.1	1200.0
2014-09-04 19:00:00	IWM	ETF	116.1	116.11	116.1	116.11	600.0
2014-09-04 07:00:00	DIA	ETF	171.2	171.32	170.9	170.9	6032.0
2014-09-04 08:00:00	DIA	ETF	171.2	171.2	170.98	171.01	10182.0
2014-09-04 09:00:00	DIA	ETF	170.96	171.48	170.86	171.33	839963.0
2014-09-04 10:00:00	DIA	ETF	171.35	171.56	171.21	171.36	551172.0

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

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