PREVIEW / etf_1hour / 2013-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-04.parquet
  size:    200 KB
  rows:    6,263

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-04-04 04:00:00	SPY	ETF	155.65	155.94	155.62	155.9	34400.0
2013-04-04 05:00:00	SPY	ETF	155.87	156.04	155.87	156.0	32276.0
2013-04-04 06:00:00	SPY	ETF	155.94	155.97	155.76	155.79	119300.0
2013-04-04 07:00:00	SPY	ETF	155.85	156.0	155.82	155.83	699569.0
2013-04-04 08:00:00	SPY	ETF	155.83	155.92	155.15	155.33	4107217.0
2013-04-04 09:00:00	SPY	ETF	155.34	156.0	155.22	155.87	17649551.0
2013-04-04 10:00:00	SPY	ETF	155.87	156.17	155.3	155.69	25843966.0
2013-04-04 11:00:00	SPY	ETF	155.691	155.93	155.49	155.54	11863612.0
2013-04-04 12:00:00	SPY	ETF	155.53	155.54	155.26	155.44	11440576.0
2013-04-04 13:00:00	SPY	ETF	155.43	155.69	155.09	155.58	15154441.0
2013-04-04 14:00:00	SPY	ETF	155.58	155.85	155.48	155.62	11127843.0
2013-04-04 15:00:00	SPY	ETF	155.63	155.92	155.52	155.851	17736412.0
2013-04-04 16:00:00	SPY	ETF	155.84	155.98	155.2443	155.2443	14364936.0
2013-04-04 17:00:00	SPY	ETF	155.76	155.89	155.76	155.87	104487.0
2013-04-04 18:00:00	SPY	ETF	155.89	155.92	155.85	155.89	41156.0
2013-04-04 19:00:00	SPY	ETF	155.89	155.89	155.75	155.81	44803.0
2013-04-04 20:00:00	SPY	ETF	155.94	155.94	155.94	155.94	100.0
2013-04-04 06:00:00	QQQ	ETF	68.7	68.71	68.66	68.66	6991.0
2013-04-04 07:00:00	QQQ	ETF	68.68	68.7	68.66	68.68	12670.0
2013-04-04 08:00:00	QQQ	ETF	68.63	68.63	68.33	68.38	627147.0
2013-04-04 09:00:00	QQQ	ETF	68.38	68.525	68.27	68.46	4955503.0
2013-04-04 10:00:00	QQQ	ETF	68.47	68.6	68.1825	68.26	5752169.0
2013-04-04 11:00:00	QQQ	ETF	68.27	68.41	68.26	68.29	2818521.0
2013-04-04 12:00:00	QQQ	ETF	68.285	68.32	68.06	68.255	3661035.0
2013-04-04 13:00:00	QQQ	ETF	68.26	68.42	68.1313	68.39	2759896.0
2013-04-04 14:00:00	QQQ	ETF	68.38	68.47	68.31	68.31	1984437.0
2013-04-04 15:00:00	QQQ	ETF	68.31	68.47	68.27	68.43	3238478.0
2013-04-04 16:00:00	QQQ	ETF	68.44	68.49	68.29	68.33	5386675.0
2013-04-04 17:00:00	QQQ	ETF	68.41	68.41	68.33	68.36	89172.0
2013-04-04 18:00:00	QQQ	ETF	68.36	68.37	68.32	68.33	61215.0
2013-04-04 19:00:00	QQQ	ETF	68.35	68.35	68.3	68.32	14832.0
2013-04-04 05:00:00	IWM	ETF	91.84	91.88	91.84	91.85	1300.0
2013-04-04 06:00:00	IWM	ETF	91.8	91.82	91.69	91.69	29100.0
2013-04-04 07:00:00	IWM	ETF	91.71	91.79	91.67	91.71	41976.0
2013-04-04 08:00:00	IWM	ETF	91.7	91.72	91.13	91.27	392436.0
2013-04-04 09:00:00	IWM	ETF	91.26	91.48	91.09	91.42	4424445.0
2013-04-04 10:00:00	IWM	ETF	91.415	91.56	90.96	91.24	8226172.0
2013-04-04 11:00:00	IWM	ETF	91.23	91.48	91.2	91.29	2728444.0
2013-04-04 12:00:00	IWM	ETF	91.3	91.44	91.08	91.4	3152645.0
2013-04-04 13:00:00	IWM	ETF	91.41	91.62	91.2	91.55	3962214.0
2013-04-04 14:00:00	IWM	ETF	91.55	91.73	91.52	91.53	2015089.0
2013-04-04 15:00:00	IWM	ETF	91.53	91.94	91.53	91.9299	5418280.0
2013-04-04 16:00:00	IWM	ETF	91.92	91.93	91.75	91.76	1231463.0
2013-04-04 17:00:00	IWM	ETF	91.79	91.84	91.77	91.84	28950.0
2013-04-04 18:00:00	IWM	ETF	91.77	91.78	91.77	91.77	925.0
2013-04-04 19:00:00	IWM	ETF	91.77	91.78	91.76	91.78	700.0
2013-04-04 05:00:00	DIA	ETF	145.97	145.97	145.9	145.9	300.0
2013-04-04 06:00:00	DIA	ETF	145.82	145.83	145.2	145.2	32000.0
2013-04-04 07:00:00	DIA	ETF	145.82	145.84	145.77	145.77	6700.0
2013-04-04 08:00:00	DIA	ETF	145.82	145.82	145.2	145.29	119598.0

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

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