PREVIEW / etf_1hour / 2014-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-14.parquet
  size:    216 KB
  rows:    6,835

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-04-14 04:00:00	SPY	ETF	181.5	181.65	181.34	181.53	17800.0
2014-04-14 05:00:00	SPY	ETF	181.55	181.55	181.23	181.45	20829.0
2014-04-14 06:00:00	SPY	ETF	181.43	181.8	181.38	181.8	68568.0
2014-04-14 07:00:00	SPY	ETF	181.82	182.18	181.71	182.16	1006380.0
2014-04-14 08:00:00	SPY	ETF	181.77	182.82	181.75	182.61	3152869.0
2014-04-14 09:00:00	SPY	ETF	182.62	183.03	182.19	182.29	16615456.0
2014-04-14 10:00:00	SPY	ETF	182.28	183.29	182.13	183.25	20435906.0
2014-04-14 11:00:00	SPY	ETF	183.241	183.3	182.86	182.94	13175586.0
2014-04-14 12:00:00	SPY	ETF	182.94	183.37	182.84	183.21	6944288.0
2014-04-14 13:00:00	SPY	ETF	183.21	183.23	182.63	182.632	10588713.0
2014-04-14 14:00:00	SPY	ETF	182.64	183.04	182.16	182.23	11784385.0
2014-04-14 15:00:00	SPY	ETF	182.23	183.05	181.44	182.95	38390407.0
2014-04-14 16:00:00	SPY	ETF	182.94	183.08	181.4802	183.05	6374863.0
2014-04-14 17:00:00	SPY	ETF	183.04	183.07	181.4802	183.02	581682.0
2014-04-14 18:00:00	SPY	ETF	183.03	183.15	183.02	183.02	119093.0
2014-04-14 19:00:00	SPY	ETF	183.03	183.11	183.03	183.08	75724.0
2014-04-14 04:00:00	QQQ	ETF	84.09	84.09	83.98	84.01	3800.0
2014-04-14 05:00:00	QQQ	ETF	83.9	83.9	83.88	83.88	1200.0
2014-04-14 06:00:00	QQQ	ETF	83.98	84.2	83.98	84.2	48100.0
2014-04-14 07:00:00	QQQ	ETF	84.2	84.42	84.16	84.42	72443.0
2014-04-14 08:00:00	QQQ	ETF	84.41	84.76	84.17	84.66	555717.0
2014-04-14 09:00:00	QQQ	ETF	84.66	84.9	84.3	84.37	7222619.0
2014-04-14 10:00:00	QQQ	ETF	84.36	85.17	84.27	85.13	8672326.0
2014-04-14 11:00:00	QQQ	ETF	85.13	85.22	84.94	84.96	4374410.0
2014-04-14 12:00:00	QQQ	ETF	84.963	85.18	84.84	85.04	3631588.0
2014-04-14 13:00:00	QQQ	ETF	85.05	85.0599	84.57	84.57	4420747.0
2014-04-14 14:00:00	QQQ	ETF	84.56	84.7099	84.35	84.39	4035450.0
2014-04-14 15:00:00	QQQ	ETF	84.39	84.83	83.99	84.78	11537883.0
2014-04-14 16:00:00	QQQ	ETF	84.78	84.89	84.5989	84.87	931077.0
2014-04-14 17:00:00	QQQ	ETF	84.87	84.89	84.84	84.84	6240.0
2014-04-14 18:00:00	QQQ	ETF	84.87	84.92	84.85	84.86	29418.0
2014-04-14 19:00:00	QQQ	ETF	84.86	84.92	84.85	84.88	21600.0
2014-04-14 06:00:00	IWM	ETF	110.3	110.3	110.3	110.3	100.0
2014-04-14 07:00:00	IWM	ETF	110.49	110.75	110.49	110.72	46900.0
2014-04-14 08:00:00	IWM	ETF	110.81	111.54	110.77	111.36	1405682.0
2014-04-14 09:00:00	IWM	ETF	111.35	111.79	110.63	110.78	11071484.0
2014-04-14 10:00:00	IWM	ETF	110.79	111.97	110.645	111.88	8305802.0
2014-04-14 11:00:00	IWM	ETF	111.88	111.94	111.3	111.33	3990136.0
2014-04-14 12:00:00	IWM	ETF	111.33	111.69	111.25	111.55	2302560.0
2014-04-14 13:00:00	IWM	ETF	111.56	111.56	110.95	110.95	2666934.0
2014-04-14 14:00:00	IWM	ETF	110.95	111.06	110.32	110.33	7036506.0
2014-04-14 15:00:00	IWM	ETF	110.325	110.86	109.65	110.7	14180512.0
2014-04-14 16:00:00	IWM	ETF	110.71	110.76	109.805	110.72	3152034.0
2014-04-14 17:00:00	IWM	ETF	110.74	110.8	110.7	110.8	1210.0
2014-04-14 18:00:00	IWM	ETF	110.8	110.85	110.79	110.85	3350.0
2014-04-14 19:00:00	IWM	ETF	110.85	110.9	110.8	110.8	2059.0
2014-04-14 08:00:00	DIA	ETF	160.6	161.18	160.6	160.92	6918.0
2014-04-14 09:00:00	DIA	ETF	160.86	161.19	160.56	160.61	950579.0
2014-04-14 10:00:00	DIA	ETF	160.64	161.37	160.53	161.34	1102558.0
2014-04-14 11:00:00	DIA	ETF	161.34	161.39	161.05	161.12	683145.0

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

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