PREVIEW / etf_1hour / 2014-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-09.parquet
  size:    210 KB
  rows:    6,700

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-05-09 04:00:00	SPY	ETF	187.65	187.67	187.52	187.52	8701.0
2014-05-09 05:00:00	SPY	ETF	187.51	187.51	187.4	187.5	6613.0
2014-05-09 06:00:00	SPY	ETF	187.52	187.59	187.4	187.59	8541.0
2014-05-09 07:00:00	SPY	ETF	187.6	187.6	187.22	187.35	407959.0
2014-05-09 08:00:00	SPY	ETF	187.41	187.76	187.22	187.7	684622.0
2014-05-09 09:00:00	SPY	ETF	187.69	187.75	186.85	187.09	13248496.0
2014-05-09 10:00:00	SPY	ETF	187.09	187.56	186.85	187.03	15411011.0
2014-05-09 11:00:00	SPY	ETF	187.025	187.48	186.83	187.33	10348553.0
2014-05-09 12:00:00	SPY	ETF	187.33	188.04	187.17	187.96	8955864.0
2014-05-09 13:00:00	SPY	ETF	187.96	188.02	187.54	187.57	8916958.0
2014-05-09 14:00:00	SPY	ETF	187.56	187.7	187.265	187.64	5750125.0
2014-05-09 15:00:00	SPY	ETF	187.64	188.03	187.61	188.02	13211335.0
2014-05-09 16:00:00	SPY	ETF	188.02	188.04	187.5282	188.0	6058077.0
2014-05-09 17:00:00	SPY	ETF	188.0	188.07	187.96	188.05	45038.0
2014-05-09 18:00:00	SPY	ETF	188.05	188.06	187.99	188.01	14725.0
2014-05-09 19:00:00	SPY	ETF	188.01	188.09	188.0	188.07	15089.0
2014-05-09 04:00:00	QQQ	ETF	86.37	86.37	86.37	86.37	200.0
2014-05-09 05:00:00	QQQ	ETF	86.27	86.27	86.22	86.22	2400.0
2014-05-09 06:00:00	QQQ	ETF	86.28	86.3	86.22	86.3	9760.0
2014-05-09 07:00:00	QQQ	ETF	86.27	86.27	86.08	86.17	77350.0
2014-05-09 08:00:00	QQQ	ETF	86.19	86.48	86.1267	86.43	175891.0
2014-05-09 09:00:00	QQQ	ETF	86.41	86.45	85.85	86.26	7014047.0
2014-05-09 10:00:00	QQQ	ETF	86.25	86.61	86.01	86.03	6857834.0
2014-05-09 11:00:00	QQQ	ETF	86.02	86.4	85.88	86.31	3223933.0
2014-05-09 12:00:00	QQQ	ETF	86.32	86.74	86.22	86.66	3914295.0
2014-05-09 13:00:00	QQQ	ETF	86.66	86.72	86.41	86.43	2110983.0
2014-05-09 14:00:00	QQQ	ETF	86.435	86.6499	86.26	86.5941	2982017.0
2014-05-09 15:00:00	QQQ	ETF	86.59	86.86	86.59	86.8	5755032.0
2014-05-09 16:00:00	QQQ	ETF	86.81	86.8586	86.3572	86.8	1452113.0
2014-05-09 17:00:00	QQQ	ETF	86.8	86.87	86.8	86.85	85691.0
2014-05-09 18:00:00	QQQ	ETF	86.8	86.86	86.8	86.86	1620.0
2014-05-09 19:00:00	QQQ	ETF	86.86	86.86	86.8	86.8	4897.0
2014-05-09 05:00:00	IWM	ETF	108.8	108.8	108.8	108.8	100.0
2014-05-09 07:00:00	IWM	ETF	108.84	108.84	108.39	108.46	110988.0
2014-05-09 08:00:00	IWM	ETF	108.72	108.84	108.4	108.8	223086.0
2014-05-09 09:00:00	IWM	ETF	108.76	109.05	108.28	108.71	7824412.0
2014-05-09 10:00:00	IWM	ETF	108.7	109.35	108.6	108.8	9350896.0
2014-05-09 11:00:00	IWM	ETF	108.8	109.32	108.38	109.15	6011048.0
2014-05-09 12:00:00	IWM	ETF	109.15	109.925	108.99	109.69	5171765.0
2014-05-09 13:00:00	IWM	ETF	109.69	109.8	109.35	109.42	2888158.0
2014-05-09 14:00:00	IWM	ETF	109.4	109.65	109.17	109.63	3352508.0
2014-05-09 15:00:00	IWM	ETF	109.63	110.06	109.5	110.02	7341472.0
2014-05-09 16:00:00	IWM	ETF	110.04	110.1295	108.6819	110.07	1960321.0
2014-05-09 17:00:00	IWM	ETF	110.06	110.08	110.05	110.05	26520.0
2014-05-09 18:00:00	IWM	ETF	110.13	110.13	110.13	110.13	701.0
2014-05-09 19:00:00	IWM	ETF	110.07	110.07	110.07	110.07	261.0
2014-05-09 07:00:00	DIA	ETF	165.41	165.41	165.41	165.41	159.0
2014-05-09 08:00:00	DIA	ETF	165.25	165.25	165.16	165.16	400.0
2014-05-09 09:00:00	DIA	ETF	165.36	165.55	164.89	165.06	654059.0
2014-05-09 10:00:00	DIA	ETF	165.02	165.42	164.87	165.07	868426.0

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

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