PREVIEW / etf_1hour / 2014-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-05.parquet
  size:    211 KB
  rows:    6,732

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-05 04:00:00	SPY	ETF	187.75	187.75	187.61	187.62	4134.0
2014-03-05 05:00:00	SPY	ETF	187.61	187.65	187.56	187.65	4943.0
2014-03-05 06:00:00	SPY	ETF	187.55	187.72	187.51	187.67	13181.0
2014-03-05 07:00:00	SPY	ETF	187.62	187.97	187.58	187.92	507895.0
2014-03-05 08:00:00	SPY	ETF	187.86	188.17	187.63	187.7	1128291.0
2014-03-05 09:00:00	SPY	ETF	187.71	187.9	187.45	187.606	13116758.0
2014-03-05 10:00:00	SPY	ETF	187.6	188.0	187.45	187.79	14113637.0
2014-03-05 11:00:00	SPY	ETF	187.8	188.07	187.59	187.79	12804710.0
2014-03-05 12:00:00	SPY	ETF	187.79	187.8501	187.58	187.78	5182234.0
2014-03-05 13:00:00	SPY	ETF	187.78	188.0	187.58	187.681	7039790.0
2014-03-05 14:00:00	SPY	ETF	187.69	187.87	187.599	187.65	8583178.0
2014-03-05 15:00:00	SPY	ETF	187.65	187.82	187.49	187.73	12822744.0
2014-03-05 16:00:00	SPY	ETF	187.73	187.86	187.61	187.8	10323866.0
2014-03-05 17:00:00	SPY	ETF	187.8	187.89	187.78	187.88	91062.0
2014-03-05 18:00:00	SPY	ETF	187.87	187.87	187.67	187.77	73596.0
2014-03-05 19:00:00	SPY	ETF	187.79	187.79	187.71	187.77	28990.0
2014-03-05 06:00:00	QQQ	ETF	90.81	90.82	90.8	90.82	3287.0
2014-03-05 07:00:00	QQQ	ETF	90.85	91.01	90.85	90.97	92823.0
2014-03-05 08:00:00	QQQ	ETF	90.95	90.99	90.89	90.92	134030.0
2014-03-05 09:00:00	QQQ	ETF	90.9	91.03	90.83	90.88	4188375.0
2014-03-05 10:00:00	QQQ	ETF	90.88	91.12	90.77	91.03	3286610.0
2014-03-05 11:00:00	QQQ	ETF	91.03	91.16	90.95	91.05	1992415.0
2014-03-05 12:00:00	QQQ	ETF	91.05	91.16	90.96	91.12	1424121.0
2014-03-05 13:00:00	QQQ	ETF	91.13	91.22	91.01	91.05	2013081.0
2014-03-05 14:00:00	QQQ	ETF	91.05	91.14	90.98	91.03	2293277.0
2014-03-05 15:00:00	QQQ	ETF	91.03	91.11	90.95	91.09	3353071.0
2014-03-05 16:00:00	QQQ	ETF	91.08	91.16	90.8964	91.15	4370700.0
2014-03-05 17:00:00	QQQ	ETF	91.15	91.22	91.15	91.2	15799.0
2014-03-05 18:00:00	QQQ	ETF	91.18	91.18	91.09	91.14	10445.0
2014-03-05 19:00:00	QQQ	ETF	91.14	91.16	91.11	91.16	5800.0
2014-03-05 06:00:00	IWM	ETF	119.95	119.96	119.95	119.96	600.0
2014-03-05 07:00:00	IWM	ETF	119.96	120.12	119.96	120.07	182860.0
2014-03-05 08:00:00	IWM	ETF	120.06	120.11	119.78	119.8	696184.0
2014-03-05 09:00:00	IWM	ETF	119.79	119.96	119.53	119.65	6857595.0
2014-03-05 10:00:00	IWM	ETF	119.65	119.955	119.51	119.73	4158383.0
2014-03-05 11:00:00	IWM	ETF	119.74	119.91	119.54	119.73	3085188.0
2014-03-05 12:00:00	IWM	ETF	119.73	119.9	119.62	119.81	2520210.0
2014-03-05 13:00:00	IWM	ETF	119.805	119.95	119.5	119.59	3129927.0
2014-03-05 14:00:00	IWM	ETF	119.595	119.745	119.53	119.6	3268381.0
2014-03-05 15:00:00	IWM	ETF	119.608	119.875	119.47	119.82	5399885.0
2014-03-05 16:00:00	IWM	ETF	119.82	119.88	119.74	119.86	930402.0
2014-03-05 17:00:00	IWM	ETF	119.89	119.9	119.89	119.9	828.0
2014-03-05 18:00:00	IWM	ETF	119.98	119.98	119.82	119.82	850.0
2014-03-05 07:00:00	DIA	ETF	163.84	163.84	163.84	163.84	100.0
2014-03-05 08:00:00	DIA	ETF	163.81	163.81	163.72	163.72	1900.0
2014-03-05 09:00:00	DIA	ETF	163.7	163.84	163.41	163.55	1230475.0
2014-03-05 10:00:00	DIA	ETF	163.55	163.71	163.32	163.47	863329.0
2014-03-05 11:00:00	DIA	ETF	163.49	163.69	163.3	163.42	635207.0
2014-03-05 12:00:00	DIA	ETF	163.42	163.45	163.27	163.37	405336.0
2014-03-05 13:00:00	DIA	ETF	163.37	163.53	163.21	163.33	408861.0

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

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