PREVIEW / etf_1hour / 2013-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-24.parquet
  size:    220 KB
  rows:    6,942

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
2013-06-24 04:00:00	SPY	ETF	158.24	158.24	157.45	157.62	109770.0
2013-06-24 05:00:00	SPY	ETF	157.65	157.9	157.5	157.68	86032.0
2013-06-24 06:00:00	SPY	ETF	157.63	157.77	157.33	157.43	278929.0
2013-06-24 07:00:00	SPY	ETF	157.43	157.52	156.91	157.26	949735.0
2013-06-24 08:00:00	SPY	ETF	157.26	158.46	156.96	157.86	2196559.0
2013-06-24 09:00:00	SPY	ETF	157.86	157.92	156.34	156.44	32639952.0
2013-06-24 10:00:00	SPY	ETF	156.43	156.91	156.01	156.59	36324764.0
2013-06-24 11:00:00	SPY	ETF	156.58	156.73	155.78	156.25	26354937.0
2013-06-24 12:00:00	SPY	ETF	156.25	156.64	155.73	156.59	25388535.0
2013-06-24 13:00:00	SPY	ETF	156.58	157.36	156.34	157.3	23816895.0
2013-06-24 14:00:00	SPY	ETF	157.295	158.43	157.13	157.91	26606922.0
2013-06-24 15:00:00	SPY	ETF	157.91	158.22	157.02	157.03	34458051.0
2013-06-24 16:00:00	SPY	ETF	157.01	157.56	156.9163	157.11	8017188.0
2013-06-24 17:00:00	SPY	ETF	157.08	157.1	156.99	157.05	208474.0
2013-06-24 18:00:00	SPY	ETF	157.09	157.43	157.09	157.35	284811.0
2013-06-24 19:00:00	SPY	ETF	157.36	157.37	157.08	157.36	200155.0
2013-06-24 04:00:00	QQQ	ETF	70.1	70.12	69.83	69.93	3040.0
2013-06-24 05:00:00	QQQ	ETF	69.98	70.11	69.98	69.98	6100.0
2013-06-24 06:00:00	QQQ	ETF	69.93	69.98	69.86	69.92	4900.0
2013-06-24 07:00:00	QQQ	ETF	69.83	69.9	69.66	69.78	24574.0
2013-06-24 08:00:00	QQQ	ETF	69.82	70.1	69.72	70.07	304478.0
2013-06-24 09:00:00	QQQ	ETF	70.07	70.07	69.34	69.37	6440725.0
2013-06-24 10:00:00	QQQ	ETF	69.36	69.7	69.2	69.54	7172911.0
2013-06-24 11:00:00	QQQ	ETF	69.54	69.6	69.15	69.41	3826556.0
2013-06-24 12:00:00	QQQ	ETF	69.401	69.6	69.2	69.58	3870499.0
2013-06-24 13:00:00	QQQ	ETF	69.581	69.8101	69.47	69.81	3546151.0
2013-06-24 14:00:00	QQQ	ETF	69.8	70.27	69.73	70.08	4647595.0
2013-06-24 15:00:00	QQQ	ETF	70.07	70.22	69.73	69.73	6987737.0
2013-06-24 16:00:00	QQQ	ETF	69.73	70.4555	69.4697	69.87	3397006.0
2013-06-24 17:00:00	QQQ	ETF	69.83	69.83	69.81	69.81	11660.0
2013-06-24 18:00:00	QQQ	ETF	69.87	69.98	69.86	69.98	30321.0
2013-06-24 19:00:00	QQQ	ETF	69.96	69.96	69.83	69.94	42900.0
2013-06-24 04:00:00	IWM	ETF	95.4	95.4	94.97	94.97	850.0
2013-06-24 06:00:00	IWM	ETF	95.37	95.37	94.8	94.8	8833.0
2013-06-24 07:00:00	IWM	ETF	94.76	94.85	94.55	94.75	174792.0
2013-06-24 08:00:00	IWM	ETF	94.77	95.24	94.66	95.22	295856.0
2013-06-24 09:00:00	IWM	ETF	95.23	95.23	94.14	94.31	8846503.0
2013-06-24 10:00:00	IWM	ETF	94.3	94.73	93.99	94.47	11122760.0
2013-06-24 11:00:00	IWM	ETF	94.47	94.58	93.85	94.25	7185415.0
2013-06-24 12:00:00	IWM	ETF	94.25	94.4	93.83	94.31	4930333.0
2013-06-24 13:00:00	IWM	ETF	94.32	94.84	94.18	94.83	5707283.0
2013-06-24 14:00:00	IWM	ETF	94.84	95.515	94.69	95.19	6826764.0
2013-06-24 15:00:00	IWM	ETF	95.19	95.42	94.67	94.73	10360479.0
2013-06-24 16:00:00	IWM	ETF	94.72	94.83	94.65	94.8	1782492.0
2013-06-24 17:00:00	IWM	ETF	94.76	94.76	94.71	94.71	26980.0
2013-06-24 18:00:00	IWM	ETF	94.75	94.9	94.75	94.9	21652.0
2013-06-24 19:00:00	IWM	ETF	94.78	94.78	94.77	94.77	1300.0
2013-06-24 04:00:00	DIA	ETF	146.52	146.52	146.41	146.41	6500.0
2013-06-24 05:00:00	DIA	ETF	146.6	146.65	146.6	146.65	1100.0
2013-06-24 06:00:00	DIA	ETF	146.59	146.59	146.3	146.3	3900.0

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

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