PREVIEW / etf_1hour / 2014-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-04.parquet
  size:    223 KB
  rows:    7,039

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-03-04 04:00:00	SPY	ETF	185.98	186.12	185.97	186.05	53588.0
2014-03-04 05:00:00	SPY	ETF	186.11	186.87	186.05	186.74	75427.0
2014-03-04 06:00:00	SPY	ETF	186.74	186.99	186.62	186.69	351140.0
2014-03-04 07:00:00	SPY	ETF	186.71	187.07	186.69	186.77	921216.0
2014-03-04 08:00:00	SPY	ETF	186.77	187.07	185.1	186.66	2089570.0
2014-03-04 09:00:00	SPY	ETF	186.68	187.3	186.56	187.21	25109283.0
2014-03-04 10:00:00	SPY	ETF	187.22	187.52	186.98	187.41	26831367.0
2014-03-04 11:00:00	SPY	ETF	187.4	187.51	187.22	187.38	15208596.0
2014-03-04 12:00:00	SPY	ETF	187.38	187.7	187.34	187.55	13148059.0
2014-03-04 13:00:00	SPY	ETF	187.55	187.72	187.21	187.38	19640164.0
2014-03-04 14:00:00	SPY	ETF	187.375	187.74	187.15	187.64	15345944.0
2014-03-04 15:00:00	SPY	ETF	187.65	187.98	187.615	187.69	36225576.0
2014-03-04 16:00:00	SPY	ETF	187.68	187.79	184.9097	187.62	5895036.0
2014-03-04 17:00:00	SPY	ETF	187.62	187.78	187.61	187.63	205795.0
2014-03-04 18:00:00	SPY	ETF	187.61	187.62	187.46	187.47	233557.0
2014-03-04 19:00:00	SPY	ETF	187.5	187.51	187.36	187.5	115717.0
2014-03-04 04:00:00	QQQ	ETF	90.0	90.27	90.0	90.27	3797.0
2014-03-04 05:00:00	QQQ	ETF	90.27	90.67	90.27	90.65	14860.0
2014-03-04 06:00:00	QQQ	ETF	90.65	90.77	90.58	90.6	29509.0
2014-03-04 07:00:00	QQQ	ETF	90.61	90.73	90.61	90.63	98590.0
2014-03-04 08:00:00	QQQ	ETF	90.62	90.7	90.5	90.57	361348.0
2014-03-04 09:00:00	QQQ	ETF	90.58	90.83	90.54	90.79	4309301.0
2014-03-04 10:00:00	QQQ	ETF	90.8	90.91	90.68	90.89	5853210.0
2014-03-04 11:00:00	QQQ	ETF	90.88	90.91	90.75	90.84	2480124.0
2014-03-04 12:00:00	QQQ	ETF	90.83	90.98	90.82	90.87	1891720.0
2014-03-04 13:00:00	QQQ	ETF	90.875	90.92	90.71	90.72	2804133.0
2014-03-04 14:00:00	QQQ	ETF	90.72	90.88	90.6	90.83	2180279.0
2014-03-04 15:00:00	QQQ	ETF	90.83	90.98	90.81	90.86	6699661.0
2014-03-04 16:00:00	QQQ	ETF	90.85	90.93	90.78	90.87	1453539.0
2014-03-04 17:00:00	QQQ	ETF	90.89	90.92	90.88	90.92	4566.0
2014-03-04 18:00:00	QQQ	ETF	90.82	90.84	90.78	90.84	9620.0
2014-03-04 19:00:00	QQQ	ETF	90.84	90.84	90.77	90.83	14455.0
2014-03-04 04:00:00	IWM	ETF	117.44	117.48	117.44	117.48	200.0
2014-03-04 05:00:00	IWM	ETF	117.82	118.21	117.82	118.21	1550.0
2014-03-04 06:00:00	IWM	ETF	118.36	118.36	118.2	118.2	10675.0
2014-03-04 07:00:00	IWM	ETF	118.2	118.39	118.2	118.27	209489.0
2014-03-04 08:00:00	IWM	ETF	118.25	118.27	118.06	118.07	137181.0
2014-03-04 09:00:00	IWM	ETF	118.05	119.74	116.89	119.73	13606382.0
2014-03-04 10:00:00	IWM	ETF	119.73	120.23	119.41	120.2	14683618.0
2014-03-04 11:00:00	IWM	ETF	120.19	120.24	119.96	120.19	7361883.0
2014-03-04 12:00:00	IWM	ETF	120.19	120.53	120.12	120.44	7144654.0
2014-03-04 13:00:00	IWM	ETF	120.44	120.58	120.0	120.07	7501611.0
2014-03-04 14:00:00	IWM	ETF	120.06	120.3	119.73	120.2	11631014.0
2014-03-04 15:00:00	IWM	ETF	120.2	120.51	119.86	119.88	18069831.0
2014-03-04 16:00:00	IWM	ETF	119.87	120.3377	119.77	119.96	5280727.0
2014-03-04 17:00:00	IWM	ETF	119.93	119.95	119.82	119.82	19047.0
2014-03-04 18:00:00	IWM	ETF	119.91	119.91	119.86	119.86	12998.0
2014-03-04 19:00:00	IWM	ETF	119.85	119.87	119.77	119.87	5275.0
2014-03-04 05:00:00	DIA	ETF	162.81	163.1	162.81	163.1	12700.0
2014-03-04 06:00:00	DIA	ETF	163.11	163.17	163.11	163.17	4000.0

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

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