PREVIEW / etf_1hour / 2012-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-09.parquet
  size:    195 KB
  rows:    6,052

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-11-09 04:00:00	SPY	ETF	138.26	138.43	138.12	138.43	19950.0
2012-11-09 05:00:00	SPY	ETF	138.44	138.44	137.82	137.85	57436.0
2012-11-09 06:00:00	SPY	ETF	137.8	138.05	137.72	137.86	111125.0
2012-11-09 07:00:00	SPY	ETF	137.8	137.89	137.35	137.38	697519.0
2012-11-09 08:00:00	SPY	ETF	137.41	138.7	137.01	137.52	4061998.0
2012-11-09 09:00:00	SPY	ETF	137.52	138.17	137.51	138.01	26621454.0
2012-11-09 10:00:00	SPY	ETF	138.01	138.8	137.95	138.67	29467311.0
2012-11-09 11:00:00	SPY	ETF	138.665	139.0	138.54	138.94	20561375.0
2012-11-09 12:00:00	SPY	ETF	138.94	139.44	138.94	139.1892	15758186.0
2012-11-09 13:00:00	SPY	ETF	139.18	139.3289	138.11	138.5501	36329236.0
2012-11-09 14:00:00	SPY	ETF	138.555	139.09	138.31	138.54	14791595.0
2012-11-09 15:00:00	SPY	ETF	138.535	138.78	138.13	138.19	36517453.0
2012-11-09 16:00:00	SPY	ETF	138.19	139.3006	138.037	138.16	14285874.0
2012-11-09 17:00:00	SPY	ETF	138.18	138.18	137.94	137.95	642021.0
2012-11-09 18:00:00	SPY	ETF	137.98	138.1	137.91	138.0	89189.0
2012-11-09 19:00:00	SPY	ETF	138.06	138.11	138.03	138.1	15121.0
2012-11-09 04:00:00	QQQ	ETF	63.38	63.38	63.38	63.38	100.0
2012-11-09 05:00:00	QQQ	ETF	63.43	63.43	63.22	63.22	1000.0
2012-11-09 06:00:00	QQQ	ETF	63.2	63.29	63.2	63.27	11000.0
2012-11-09 07:00:00	QQQ	ETF	63.22	63.22	63.0	63.0	43506.0
2012-11-09 08:00:00	QQQ	ETF	63.03	63.15	62.86	63.08	618802.0
2012-11-09 09:00:00	QQQ	ETF	63.09	63.46	63.09	63.31	6447650.0
2012-11-09 10:00:00	QQQ	ETF	63.319	63.76	63.28	63.72	9666690.0
2012-11-09 11:00:00	QQQ	ETF	63.72	63.83	63.63	63.77	4398271.0
2012-11-09 12:00:00	QQQ	ETF	63.77	64.11	63.77	63.96	3997551.0
2012-11-09 13:00:00	QQQ	ETF	63.965	64.039	63.43	63.66	6972473.0
2012-11-09 14:00:00	QQQ	ETF	63.66	63.88	63.4899	63.59	3582464.0
2012-11-09 15:00:00	QQQ	ETF	63.6	63.7	63.43	63.44	6568537.0
2012-11-09 16:00:00	QQQ	ETF	63.43	63.6957	63.1752	63.1752	7389967.0
2012-11-09 17:00:00	QQQ	ETF	63.48	63.5	63.43	63.43	3035.0
2012-11-09 18:00:00	QQQ	ETF	63.5	63.5	63.45	63.49	3125.0
2012-11-09 19:00:00	QQQ	ETF	63.49	63.49	63.45	63.49	5315.0
2012-11-09 05:00:00	IWM	ETF	79.17	79.17	79.0	79.0	400.0
2012-11-09 06:00:00	IWM	ETF	79.0	79.0	79.0	79.0	200.0
2012-11-09 07:00:00	IWM	ETF	78.95	78.98	78.78	78.83	46050.0
2012-11-09 08:00:00	IWM	ETF	78.76	79.19	78.53	78.77	357882.0
2012-11-09 09:00:00	IWM	ETF	78.77	79.27	78.74	79.06	5107112.0
2012-11-09 10:00:00	IWM	ETF	79.05	79.59	79.03	79.5	4466290.0
2012-11-09 11:00:00	IWM	ETF	79.5	79.79	79.47	79.74	3619055.0
2012-11-09 12:00:00	IWM	ETF	79.74	79.97	79.74	79.79	2063628.0
2012-11-09 13:00:00	IWM	ETF	79.8	79.87	79.22	79.52	5914393.0
2012-11-09 14:00:00	IWM	ETF	79.52	79.76	79.34	79.52	2608969.0
2012-11-09 15:00:00	IWM	ETF	79.52	79.55	79.25	79.35	5513534.0
2012-11-09 16:00:00	IWM	ETF	79.36	79.53	79.2333	79.41	1527510.0
2012-11-09 17:00:00	IWM	ETF	79.31	79.4	79.31	79.4	6450.0
2012-11-09 18:00:00	IWM	ETF	79.35	79.35	79.35	79.35	200.0
2012-11-09 05:00:00	DIA	ETF	127.9	127.9	127.9	127.9	100.0
2012-11-09 07:00:00	DIA	ETF	127.7	127.7	127.4	127.4	4700.0
2012-11-09 08:00:00	DIA	ETF	127.5	127.5	127.1	127.36	19025.0
2012-11-09 09:00:00	DIA	ETF	127.44	127.94	127.28	127.83	731592.0

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

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