PREVIEW / etf_1hour / 2014-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-29.parquet
  size:    225 KB
  rows:    7,187

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-29 04:00:00	SPY	ETF	197.36	197.4	197.18	197.28	24466.0
2014-09-29 05:00:00	SPY	ETF	197.29	197.38	197.15	197.28	16347.0
2014-09-29 06:00:00	SPY	ETF	197.26	197.38	196.82	196.97	217998.0
2014-09-29 07:00:00	SPY	ETF	197.0	197.03	196.67	197.01	663220.0
2014-09-29 08:00:00	SPY	ETF	197.01	197.215	196.13	196.22	1473968.0
2014-09-29 09:00:00	SPY	ETF	196.22	196.66	196.05	196.59	15957096.0
2014-09-29 10:00:00	SPY	ETF	196.59	197.42	196.42	197.19	16415258.0
2014-09-29 11:00:00	SPY	ETF	197.19	197.75	197.06	197.68	11500605.0
2014-09-29 12:00:00	SPY	ETF	197.679	197.679	196.91	197.21	8013759.0
2014-09-29 13:00:00	SPY	ETF	197.21	197.59	197.02	197.34	6691640.0
2014-09-29 14:00:00	SPY	ETF	197.3351	197.51	196.76	197.29	7403109.0
2014-09-29 15:00:00	SPY	ETF	197.285	197.89	197.23	197.52	18816917.0
2014-09-29 16:00:00	SPY	ETF	197.52	198.0199	197.3	197.37	5316934.0
2014-09-29 17:00:00	SPY	ETF	197.34	197.42	197.32	197.4	63438.0
2014-09-29 18:00:00	SPY	ETF	197.38	197.4	197.34	197.37	26883.0
2014-09-29 19:00:00	SPY	ETF	197.36	197.44	197.34	197.44	13541.0
2014-09-29 04:00:00	QQQ	ETF	98.41	98.44	98.33	98.44	1345.0
2014-09-29 05:00:00	QQQ	ETF	98.37	98.47	98.35	98.47	2300.0
2014-09-29 06:00:00	QQQ	ETF	98.46	98.47	98.19	98.19	16200.0
2014-09-29 07:00:00	QQQ	ETF	98.24	98.29	98.09	98.28	35260.0
2014-09-29 08:00:00	QQQ	ETF	98.3	98.3	97.74	97.79	252156.0
2014-09-29 09:00:00	QQQ	ETF	97.77	98.2	97.69	98.11	5562466.0
2014-09-29 10:00:00	QQQ	ETF	98.1	98.75	98.0	98.625	6271137.0
2014-09-29 11:00:00	QQQ	ETF	98.63	98.92	98.55	98.78	4130091.0
2014-09-29 12:00:00	QQQ	ETF	98.78	98.78	98.32	98.55	2691902.0
2014-09-29 13:00:00	QQQ	ETF	98.54	98.71	98.435	98.591	2236498.0
2014-09-29 14:00:00	QQQ	ETF	98.58	98.69	98.27	98.58	2988783.0
2014-09-29 15:00:00	QQQ	ETF	98.58	98.9	98.55	98.68	6539213.0
2014-09-29 16:00:00	QQQ	ETF	98.68	98.6976	98.5	98.56	2120020.0
2014-09-29 17:00:00	QQQ	ETF	98.57	98.63	98.54	98.57	7595.0
2014-09-29 18:00:00	QQQ	ETF	98.58	98.58	98.55	98.55	10918.0
2014-09-29 19:00:00	QQQ	ETF	98.58	98.61	98.57	98.6	3524.0
2014-09-29 04:00:00	IWM	ETF	110.5	110.5	110.5	110.5	200.0
2014-09-29 05:00:00	IWM	ETF	110.4	110.4	110.4	110.4	100.0
2014-09-29 06:00:00	IWM	ETF	110.31	110.31	110.2	110.2	4230.0
2014-09-29 07:00:00	IWM	ETF	110.21	110.32	110.13	110.32	24300.0
2014-09-29 08:00:00	IWM	ETF	110.35	110.35	109.87	109.94	152170.0
2014-09-29 09:00:00	IWM	ETF	109.85	110.42	109.7	110.339	4320279.0
2014-09-29 10:00:00	IWM	ETF	110.33	110.9	110.18	110.76	3929003.0
2014-09-29 11:00:00	IWM	ETF	110.76	111.34	110.7	111.33	3757164.0
2014-09-29 12:00:00	IWM	ETF	111.33	111.35	110.52	110.7	3493842.0
2014-09-29 13:00:00	IWM	ETF	110.7	110.78	110.43	110.52	2723812.0
2014-09-29 14:00:00	IWM	ETF	110.53	110.74	110.37	110.68	2156043.0
2014-09-29 15:00:00	IWM	ETF	110.68	111.03	110.59	111.02	6152141.0
2014-09-29 16:00:00	IWM	ETF	111.03	111.07	110.8	110.9	679060.0
2014-09-29 17:00:00	IWM	ETF	110.92	111.03	110.92	110.92	175682.0
2014-09-29 19:00:00	IWM	ETF	110.96	110.97	110.96	110.97	400.0
2014-09-29 07:00:00	DIA	ETF	169.85	169.85	169.79	169.8	1000.0
2014-09-29 08:00:00	DIA	ETF	170.06	170.06	169.2	169.2	2810.0
2014-09-29 09:00:00	DIA	ETF	169.2	169.5	168.94	169.46	1099799.0

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

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