PREVIEW / etf_1hour / 2012-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-20.parquet
  size:    181 KB
  rows:    5,611

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
2012-07-20 04:00:00	SPY	ETF	137.51	137.58	137.45	137.58	6400.0
2012-07-20 05:00:00	SPY	ETF	137.59	137.61	137.45	137.45	1650.0
2012-07-20 06:00:00	SPY	ETF	137.31	137.4	137.18	137.25	59084.0
2012-07-20 07:00:00	SPY	ETF	137.25	137.32	136.85	136.93	519332.0
2012-07-20 08:00:00	SPY	ETF	136.97	137.26	136.78	136.96	1284201.0
2012-07-20 09:00:00	SPY	ETF	136.96	137.1442	136.74	136.93	24641543.0
2012-07-20 10:00:00	SPY	ETF	136.94	137.16	136.67	136.96	20381998.0
2012-07-20 11:00:00	SPY	ETF	136.97	137.13	136.66	136.83	16695463.0
2012-07-20 12:00:00	SPY	ETF	136.83	136.84	136.37	136.65	14311888.0
2012-07-20 13:00:00	SPY	ETF	136.6501	136.71	136.33	136.55	13175425.0
2012-07-20 14:00:00	SPY	ETF	136.54	136.69	136.37	136.43	10256820.0
2012-07-20 15:00:00	SPY	ETF	136.43	136.6	136.32	136.46	27308999.0
2012-07-20 16:00:00	SPY	ETF	136.47	137.0059	136.32	136.37	11586726.0
2012-07-20 17:00:00	SPY	ETF	136.4	136.42	136.34	136.37	37311.0
2012-07-20 18:00:00	SPY	ETF	136.4	136.4	136.28	136.3	48957.0
2012-07-20 19:00:00	SPY	ETF	136.3	136.4	136.27	136.35	36161.0
2012-07-20 04:00:00	QQQ	ETF	65.19	65.25	65.19	65.25	600.0
2012-07-20 05:00:00	QQQ	ETF	65.27	65.27	65.27	65.27	800.0
2012-07-20 06:00:00	QQQ	ETF	65.13	65.13	65.11	65.11	1200.0
2012-07-20 07:00:00	QQQ	ETF	65.12	65.12	64.97	65.02	75493.0
2012-07-20 08:00:00	QQQ	ETF	65.01	65.03	64.91	64.97	158390.0
2012-07-20 09:00:00	QQQ	ETF	65.0	65.1	64.71	64.845	6334876.0
2012-07-20 10:00:00	QQQ	ETF	64.84	65.02	64.6	64.79	6166532.0
2012-07-20 11:00:00	QQQ	ETF	64.8	64.9	64.51	64.59	6215702.0
2012-07-20 12:00:00	QQQ	ETF	64.58	64.585	64.34	64.52	3820202.0
2012-07-20 13:00:00	QQQ	ETF	64.52	64.56	64.35	64.451	2637275.0
2012-07-20 14:00:00	QQQ	ETF	64.46	64.53	64.37	64.39	2026494.0
2012-07-20 15:00:00	QQQ	ETF	64.39	64.48	64.21	64.25	6811807.0
2012-07-20 16:00:00	QQQ	ETF	64.28	65.1289	64.1828	64.32	3682948.0
2012-07-20 17:00:00	QQQ	ETF	64.32	64.32	64.27	64.29	26769.0
2012-07-20 18:00:00	QQQ	ETF	64.27	64.27	64.25	64.25	5149.0
2012-07-20 19:00:00	QQQ	ETF	64.26	64.26	64.24	64.24	8450.0
2012-07-20 06:00:00	IWM	ETF	79.55	79.55	79.55	79.55	10100.0
2012-07-20 07:00:00	IWM	ETF	79.47	79.52	79.29	79.29	80248.0
2012-07-20 08:00:00	IWM	ETF	79.32	79.36	79.2	79.36	308812.0
2012-07-20 09:00:00	IWM	ETF	79.36	79.41	78.91	79.08	7497211.0
2012-07-20 10:00:00	IWM	ETF	79.08	79.3	79.0	79.21	6050467.0
2012-07-20 11:00:00	IWM	ETF	79.21	79.46	79.05	79.18	7783674.0
2012-07-20 12:00:00	IWM	ETF	79.18	79.215	78.8099	79.0	4026008.0
2012-07-20 13:00:00	IWM	ETF	79.0	79.06	78.86	79.02	1833901.0
2012-07-20 14:00:00	IWM	ETF	79.01	79.11	78.94	79.0	1684015.0
2012-07-20 15:00:00	IWM	ETF	79.0	79.06	78.88	78.99	7520270.0
2012-07-20 16:00:00	IWM	ETF	79.0	79.06	78.86	78.99	4107858.0
2012-07-20 17:00:00	IWM	ETF	78.95	78.95	78.93	78.94	61100.0
2012-07-20 18:00:00	IWM	ETF	78.94	78.97	78.92	78.97	1572.0
2012-07-20 19:00:00	IWM	ETF	78.91	78.92	78.89	78.92	632.0
2012-07-20 07:00:00	DIA	ETF	128.4	128.4	128.4	128.4	100.0
2012-07-20 08:00:00	DIA	ETF	128.6	128.6	128.29	128.41	11260.0
2012-07-20 09:00:00	DIA	ETF	128.46	128.5	128.1701	128.41	2433009.0
2012-07-20 10:00:00	DIA	ETF	128.42	128.66	128.05	128.3584	1089116.0

> showing 50 of 5,611 rows — these rows as CSV

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