PREVIEW / etf_1hour / 2013-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-17.parquet
  size:    204 KB
  rows:    6,426

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-06-17 04:00:00	SPY	ETF	163.82	164.5	163.73	164.34	36757.0
2013-06-17 05:00:00	SPY	ETF	164.35	164.56	164.35	164.54	41111.0
2013-06-17 06:00:00	SPY	ETF	164.53	164.6	164.38	164.44	127901.0
2013-06-17 07:00:00	SPY	ETF	164.41	164.465	164.13	164.19	452704.0
2013-06-17 08:00:00	SPY	ETF	164.19	164.45	164.08	164.27	1796413.0
2013-06-17 09:00:00	SPY	ETF	164.27	164.96	164.15	164.81	15648182.0
2013-06-17 10:00:00	SPY	ETF	164.83	165.06	164.68	165.03	17319956.0
2013-06-17 11:00:00	SPY	ETF	165.03	165.22	164.75	164.87	15190350.0
2013-06-17 12:00:00	SPY	ETF	164.87	164.95	164.73	164.82	6045088.0
2013-06-17 13:00:00	SPY	ETF	164.82	165.1	164.72	164.9799	7368173.0
2013-06-17 14:00:00	SPY	ETF	164.975	165.01	163.55	163.765	24897159.0
2013-06-17 15:00:00	SPY	ETF	163.76	164.65	163.62	164.45	32431203.0
2013-06-17 16:00:00	SPY	ETF	164.45	164.8366	164.3164	164.63	9305314.0
2013-06-17 17:00:00	SPY	ETF	164.61	164.7	164.57	164.61	283195.0
2013-06-17 18:00:00	SPY	ETF	164.61	164.67	164.55	164.67	157027.0
2013-06-17 19:00:00	SPY	ETF	164.63	164.67	164.56	164.59	38557.0
2013-06-17 04:00:00	QQQ	ETF	72.8	72.98	72.26	72.92	33121.0
2013-06-17 05:00:00	QQQ	ETF	72.94	72.99	72.94	72.99	4200.0
2013-06-17 06:00:00	QQQ	ETF	72.99	73.02	72.96	72.98	4900.0
2013-06-17 07:00:00	QQQ	ETF	72.96	72.96	72.85	72.86	24564.0
2013-06-17 08:00:00	QQQ	ETF	72.87	72.92	72.81	72.9	92926.0
2013-06-17 09:00:00	QQQ	ETF	72.87	73.12	72.84	73.08	4451280.0
2013-06-17 10:00:00	QQQ	ETF	73.08	73.29	73.03	73.26	4707169.0
2013-06-17 11:00:00	QQQ	ETF	73.27	73.4	73.2	73.26	3173669.0
2013-06-17 12:00:00	QQQ	ETF	73.26	73.33	73.22	73.3	1355882.0
2013-06-17 13:00:00	QQQ	ETF	73.3	73.395	73.2301	73.33	1500716.0
2013-06-17 14:00:00	QQQ	ETF	73.33	73.368	72.6	72.71	8561396.0
2013-06-17 15:00:00	QQQ	ETF	72.71	73.08	72.65	72.96	7225282.0
2013-06-17 16:00:00	QQQ	ETF	72.96	73.03	72.94	73.03	1186704.0
2013-06-17 17:00:00	QQQ	ETF	73.02	73.04	73.02	73.04	3900.0
2013-06-17 18:00:00	QQQ	ETF	73.01	73.04	72.98	73.04	2107.0
2013-06-17 19:00:00	QQQ	ETF	72.99	72.99	72.99	72.99	1600.0
2013-06-17 04:00:00	IWM	ETF	98.55	98.55	98.55	98.55	100.0
2013-06-17 05:00:00	IWM	ETF	98.6	98.73	98.6	98.73	400.0
2013-06-17 06:00:00	IWM	ETF	98.61	98.67	98.61	98.67	28600.0
2013-06-17 07:00:00	IWM	ETF	98.64	98.7	98.52	98.53	96554.0
2013-06-17 08:00:00	IWM	ETF	98.54	98.69	98.45	98.6	229115.0
2013-06-17 09:00:00	IWM	ETF	98.61	98.855	98.43	98.65	6340670.0
2013-06-17 10:00:00	IWM	ETF	98.67	98.82	98.26	98.59	4872864.0
2013-06-17 11:00:00	IWM	ETF	98.59	98.71	98.45	98.48	2461600.0
2013-06-17 12:00:00	IWM	ETF	98.48	98.6	98.38	98.5	2519028.0
2013-06-17 13:00:00	IWM	ETF	98.49	98.59	98.3399	98.5	1886921.0
2013-06-17 14:00:00	IWM	ETF	98.51	98.53	97.76	97.85	4528206.0
2013-06-17 15:00:00	IWM	ETF	97.85	98.43	97.76	98.31	5769200.0
2013-06-17 16:00:00	IWM	ETF	98.31	98.55	97.679	98.54	1692446.0
2013-06-17 17:00:00	IWM	ETF	98.55	98.57	98.54	98.54	26676.0
2013-06-17 18:00:00	IWM	ETF	98.55	98.55	98.47	98.48	3136.0
2013-06-17 19:00:00	IWM	ETF	98.49	98.5	98.48	98.48	2164.0
2013-06-17 04:00:00	DIA	ETF	151.71	151.71	151.71	151.71	100.0
2013-06-17 05:00:00	DIA	ETF	151.78	151.78	151.78	151.78	400.0

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

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