PREVIEW / etf_1hour / 2012-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-09.parquet
  size:    179 KB
  rows:    5,535

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-09 04:00:00	SPY	ETF	135.26	135.26	135.0	135.0	69326.0
2012-07-09 05:00:00	SPY	ETF	134.99	135.21	134.93	135.16	118078.0
2012-07-09 06:00:00	SPY	ETF	135.16	135.34	135.1	135.3	59931.0
2012-07-09 07:00:00	SPY	ETF	135.31	135.32	135.13	135.13	775329.0
2012-07-09 08:00:00	SPY	ETF	135.16	135.45	135.08	135.35	2677938.0
2012-07-09 09:00:00	SPY	ETF	135.36	135.57	134.93	135.03	13122055.0
2012-07-09 10:00:00	SPY	ETF	135.03	135.28	134.77	135.18	17087795.0
2012-07-09 11:00:00	SPY	ETF	135.18	135.21	134.7	134.73	12505339.0
2012-07-09 12:00:00	SPY	ETF	134.73	135.04	134.71	134.87	10690558.0
2012-07-09 13:00:00	SPY	ETF	134.88	135.35	134.85	135.22	8215060.0
2012-07-09 14:00:00	SPY	ETF	135.22	135.25	134.82	134.95	10604353.0
2012-07-09 15:00:00	SPY	ETF	134.95	135.42	134.93	135.31	18506667.0
2012-07-09 16:00:00	SPY	ETF	135.32	135.55	135.26	135.28	6659583.0
2012-07-09 17:00:00	SPY	ETF	135.29	135.34	135.22	135.27	62923.0
2012-07-09 18:00:00	SPY	ETF	135.27	135.29	135.19	135.28	45123.0
2012-07-09 19:00:00	SPY	ETF	135.28	135.37	135.26	135.37	31768.0
2012-07-09 04:00:00	QQQ	ETF	64.01	64.01	63.86	63.86	1100.0
2012-07-09 06:00:00	QQQ	ETF	63.97	63.97	63.97	63.97	5000.0
2012-07-09 07:00:00	QQQ	ETF	63.99	64.01	63.93	63.95	19996.0
2012-07-09 08:00:00	QQQ	ETF	63.96	64.1	63.94	64.03	913184.0
2012-07-09 09:00:00	QQQ	ETF	64.06	64.26	63.85	63.87	3533362.0
2012-07-09 10:00:00	QQQ	ETF	63.87	64.0	63.68	63.97	7806337.0
2012-07-09 11:00:00	QQQ	ETF	63.97	63.98	63.695	63.7	4391246.0
2012-07-09 12:00:00	QQQ	ETF	63.7	63.85	63.69	63.8	2285918.0
2012-07-09 13:00:00	QQQ	ETF	63.8	64.07	63.78	64.0	3347212.0
2012-07-09 14:00:00	QQQ	ETF	64.0	64.02	63.74	63.83	3252398.0
2012-07-09 15:00:00	QQQ	ETF	63.83	64.0301	63.82	64.0	5447473.0
2012-07-09 16:00:00	QQQ	ETF	64.0	64.1	63.9128	63.95	1640767.0
2012-07-09 17:00:00	QQQ	ETF	63.96	64.0	63.95	64.0	8700.0
2012-07-09 18:00:00	QQQ	ETF	63.98	63.98	63.95	63.96	5250.0
2012-07-09 19:00:00	QQQ	ETF	64.0	64.01	63.97	63.97	8980.0
2012-07-09 04:00:00	IWM	ETF	80.04	80.05	80.04	80.05	881.0
2012-07-09 05:00:00	IWM	ETF	80.0	80.0	80.0	80.0	500.0
2012-07-09 06:00:00	IWM	ETF	79.99	80.15	79.99	80.15	1400.0
2012-07-09 07:00:00	IWM	ETF	80.2	80.21	80.09	80.15	101974.0
2012-07-09 08:00:00	IWM	ETF	80.1	80.32	80.09	80.24	78685.0
2012-07-09 09:00:00	IWM	ETF	80.28	80.525	79.97	80.1	3514483.0
2012-07-09 10:00:00	IWM	ETF	80.1	80.41	79.86	80.3	6788192.0
2012-07-09 11:00:00	IWM	ETF	80.3	80.32	79.95	79.975	3568908.0
2012-07-09 12:00:00	IWM	ETF	79.97	80.23	79.95	80.04	3571196.0
2012-07-09 13:00:00	IWM	ETF	80.04	80.38	80.03	80.255	2364462.0
2012-07-09 14:00:00	IWM	ETF	80.26	80.28	79.92	80.1	3749575.0
2012-07-09 15:00:00	IWM	ETF	80.099	80.34	80.02	80.25	5288591.0
2012-07-09 16:00:00	IWM	ETF	80.24	80.49	80.1	80.26	508594.0
2012-07-09 17:00:00	IWM	ETF	80.31	80.31	80.29	80.29	1950.0
2012-07-09 18:00:00	IWM	ETF	80.3	80.3	80.29	80.29	1400.0
2012-07-09 19:00:00	IWM	ETF	80.34	80.34	80.34	80.34	190.0
2012-07-09 07:00:00	DIA	ETF	127.15	127.15	127.15	127.15	100.0
2012-07-09 08:00:00	DIA	ETF	127.38	127.38	127.31	127.31	300.0
2012-07-09 09:00:00	DIA	ETF	127.33	127.5	126.95	127.01	310849.0

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

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