PREVIEW / etf_1hour / 2013-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-20.parquet
  size:    205 KB
  rows:    6,389

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-05-20 04:00:00	SPY	ETF	166.68	166.71	166.67	166.71	3997.0
2013-05-20 05:00:00	SPY	ETF	166.66	166.82	166.65	166.74	85427.0
2013-05-20 06:00:00	SPY	ETF	166.82	166.82	166.73	166.73	20800.0
2013-05-20 07:00:00	SPY	ETF	166.74	166.8	166.64	166.73	129357.0
2013-05-20 08:00:00	SPY	ETF	166.73	166.8	166.48	166.54	479421.0
2013-05-20 09:00:00	SPY	ETF	166.53	167.09	166.51	166.97	13653516.0
2013-05-20 10:00:00	SPY	ETF	166.97	167.18	166.949	167.08	12758766.0
2013-05-20 11:00:00	SPY	ETF	167.09	167.52	167.08	167.47	10363617.0
2013-05-20 12:00:00	SPY	ETF	167.47	167.58	167.18	167.23	7708251.0
2013-05-20 13:00:00	SPY	ETF	167.23	167.31	166.7	166.93	11029862.0
2013-05-20 14:00:00	SPY	ETF	166.935	167.1	166.61	166.92	8648031.0
2013-05-20 15:00:00	SPY	ETF	166.92	167.08	166.76	166.93	15307588.0
2013-05-20 16:00:00	SPY	ETF	166.94	167.025	166.82	166.89	4179083.0
2013-05-20 17:00:00	SPY	ETF	166.9	166.93	166.8644	166.88	285110.0
2013-05-20 18:00:00	SPY	ETF	166.88	166.92	166.83	166.86	39154.0
2013-05-20 19:00:00	SPY	ETF	166.86	166.93	166.83	166.93	26593.0
2013-05-20 04:00:00	QQQ	ETF	74.12	74.13	74.11	74.13	300.0
2013-05-20 05:00:00	QQQ	ETF	74.12	74.13	74.12	74.13	1100.0
2013-05-20 06:00:00	QQQ	ETF	74.18	74.18	74.16	74.16	1400.0
2013-05-20 07:00:00	QQQ	ETF	74.16	74.17	74.1	74.1	10459.0
2013-05-20 08:00:00	QQQ	ETF	74.15	74.15	74.0	74.02	82605.0
2013-05-20 09:00:00	QQQ	ETF	74.01	74.3	74.01	74.27	3561638.0
2013-05-20 10:00:00	QQQ	ETF	74.28	74.4	74.2	74.2422	3215707.0
2013-05-20 11:00:00	QQQ	ETF	74.25	74.425	74.248	74.39	1786686.0
2013-05-20 12:00:00	QQQ	ETF	74.39	74.42	74.13	74.18	2114975.0
2013-05-20 13:00:00	QQQ	ETF	74.18	74.25	73.95	74.02	3409708.0
2013-05-20 14:00:00	QQQ	ETF	74.03	74.2	73.89	74.12	2870946.0
2013-05-20 15:00:00	QQQ	ETF	74.13	74.25	74.07	74.16	3460208.0
2013-05-20 16:00:00	QQQ	ETF	74.17	74.3329	74.0736	74.19	3531768.0
2013-05-20 17:00:00	QQQ	ETF	74.18	74.18	74.1	74.15	11359.0
2013-05-20 18:00:00	QQQ	ETF	74.14	74.15	74.13	74.13	3369.0
2013-05-20 19:00:00	QQQ	ETF	74.12	74.15	74.11	74.13	2525.0
2013-05-20 06:00:00	IWM	ETF	98.82	98.82	98.82	98.82	100.0
2013-05-20 07:00:00	IWM	ETF	98.78	98.78	98.71	98.71	4700.0
2013-05-20 08:00:00	IWM	ETF	98.79	98.79	98.55	98.56	51458.0
2013-05-20 09:00:00	IWM	ETF	98.55	99.12	98.55	99.08	4337803.0
2013-05-20 10:00:00	IWM	ETF	99.0899	99.26	99.002	99.14	4432499.0
2013-05-20 11:00:00	IWM	ETF	99.15	99.58	99.1488	99.55	2339226.0
2013-05-20 12:00:00	IWM	ETF	99.56	99.6	99.32	99.38	1742557.0
2013-05-20 13:00:00	IWM	ETF	99.39	99.52	99.01	99.12	3010483.0
2013-05-20 14:00:00	IWM	ETF	99.12	99.26	98.93	99.09	2231629.0
2013-05-20 15:00:00	IWM	ETF	99.09	99.24	99.02	99.22	3661136.0
2013-05-20 16:00:00	IWM	ETF	99.21	99.3	99.1	99.19	820951.0
2013-05-20 17:00:00	IWM	ETF	99.19	99.19	99.18	99.18	1200.0
2013-05-20 18:00:00	IWM	ETF	99.13	99.19	99.1	99.19	8300.0
2013-05-20 19:00:00	IWM	ETF	99.22	99.22	99.22	99.22	1000.0
2013-05-20 05:00:00	DIA	ETF	153.03	153.03	153.03	153.03	100.0
2013-05-20 07:00:00	DIA	ETF	152.94	152.94	152.94	152.94	750.0
2013-05-20 08:00:00	DIA	ETF	152.92	153.05	152.92	152.92	600.0
2013-05-20 09:00:00	DIA	ETF	152.8	153.16	152.77	152.99	499169.0

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

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