PREVIEW / etf_1hour / 2012-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-24.parquet
  size:    181 KB
  rows:    5,639

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-04-24 04:00:00	SPY	ETF	137.25	137.32	137.25	137.32	1000.0
2012-04-24 05:00:00	SPY	ETF	137.32	137.32	137.32	137.32	10200.0
2012-04-24 06:00:00	SPY	ETF	137.22	137.29	137.12	137.26	4500.0
2012-04-24 07:00:00	SPY	ETF	137.22	137.35	137.18	137.25	213515.0
2012-04-24 08:00:00	SPY	ETF	137.24	137.43	136.73	136.75	1373524.0
2012-04-24 09:00:00	SPY	ETF	136.75	137.19	136.64	136.95	20854908.0
2012-04-24 10:00:00	SPY	ETF	136.95	137.59	136.9	137.51	25422329.0
2012-04-24 11:00:00	SPY	ETF	137.5098	137.66	137.31	137.41	18976405.0
2012-04-24 12:00:00	SPY	ETF	137.41	137.49	137.11	137.135	9922860.0
2012-04-24 13:00:00	SPY	ETF	137.13	137.34	137.0	137.01	8235454.0
2012-04-24 14:00:00	SPY	ETF	137.01	137.26	136.85	137.205	15735087.0
2012-04-24 15:00:00	SPY	ETF	137.21	137.36	137.06	137.33	23218451.0
2012-04-24 16:00:00	SPY	ETF	137.33	138.23	137.2399	138.11	6093140.0
2012-04-24 17:00:00	SPY	ETF	138.06	138.15	137.27	138.04	276653.0
2012-04-24 18:00:00	SPY	ETF	138.01	138.13	138.01	138.04	158980.0
2012-04-24 19:00:00	SPY	ETF	138.03	138.13	138.02	138.11	85894.0
2012-04-24 05:00:00	QQQ	ETF	65.48	65.48	65.48	65.48	400.0
2012-04-24 06:00:00	QQQ	ETF	65.42	65.44	65.42	65.44	1200.0
2012-04-24 07:00:00	QQQ	ETF	65.41	65.47	65.29	65.29	489990.0
2012-04-24 08:00:00	QQQ	ETF	65.31	65.41	64.93	64.94	1006101.0
2012-04-24 09:00:00	QQQ	ETF	64.91	65.1	64.79	64.89	8369657.0
2012-04-24 10:00:00	QQQ	ETF	64.88	65.23	64.86	64.9571	8030507.0
2012-04-24 11:00:00	QQQ	ETF	64.95	65.08	64.82	64.86	4754047.0
2012-04-24 12:00:00	QQQ	ETF	64.87	64.91	64.6	64.61	3067474.0
2012-04-24 13:00:00	QQQ	ETF	64.6108	64.71	64.475	64.4881	3232390.0
2012-04-24 14:00:00	QQQ	ETF	64.48	64.73	64.45	64.7	5520467.0
2012-04-24 15:00:00	QQQ	ETF	64.7076	64.79	64.57	64.73	8891880.0
2012-04-24 16:00:00	QQQ	ETF	64.73	65.69	64.4	65.65	4635443.0
2012-04-24 17:00:00	QQQ	ETF	65.66	65.67	65.54	65.6	400768.0
2012-04-24 18:00:00	QQQ	ETF	65.59	65.61	65.5	65.5	60511.0
2012-04-24 19:00:00	QQQ	ETF	65.53	65.64	65.52	65.64	70752.0
2012-04-24 06:00:00	IWM	ETF	79.17	79.18	79.17	79.18	12000.0
2012-04-24 07:00:00	IWM	ETF	79.27	79.34	79.22	79.26	28096.0
2012-04-24 08:00:00	IWM	ETF	79.29	79.34	78.89	78.9	228811.0
2012-04-24 09:00:00	IWM	ETF	78.88	79.28	78.85	79.051	5215748.0
2012-04-24 10:00:00	IWM	ETF	79.05	79.7	79.0	79.58	8898480.0
2012-04-24 11:00:00	IWM	ETF	79.59	79.93	79.51	79.78	5491467.0
2012-04-24 12:00:00	IWM	ETF	79.78	79.88	79.57	79.6	2744179.0
2012-04-24 13:00:00	IWM	ETF	79.6	79.72	79.42	79.43	2530845.0
2012-04-24 14:00:00	IWM	ETF	79.42	79.46	79.11	79.4	4187554.0
2012-04-24 15:00:00	IWM	ETF	79.41	79.6925	79.28	79.68	7785275.0
2012-04-24 16:00:00	IWM	ETF	79.68	80.37	79.5618	80.27	1265365.0
2012-04-24 17:00:00	IWM	ETF	80.29	80.35	80.14	80.15	240993.0
2012-04-24 18:00:00	IWM	ETF	80.3	80.38	80.29	80.38	300.0
2012-04-24 19:00:00	IWM	ETF	80.25	80.35	80.25	80.34	6852.0
2012-04-24 07:00:00	DIA	ETF	129.28	129.48	129.28	129.4	1700.0
2012-04-24 08:00:00	DIA	ETF	129.5	129.56	129.17	129.17	9720.0
2012-04-24 09:00:00	DIA	ETF	129.13	129.75	129.13	129.53	798540.0
2012-04-24 10:00:00	DIA	ETF	129.52	130.17	129.52	130.11	1071003.0
2012-04-24 11:00:00	DIA	ETF	130.1118	130.23	129.92	129.99	652126.0

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

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