PREVIEW / etf_1hour / 2013-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-08.parquet
  size:    206 KB
  rows:    6,524

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-07-08 04:00:00	SPY	ETF	163.66	163.78	163.54	163.74	45238.0
2013-07-08 05:00:00	SPY	ETF	163.76	164.23	163.76	164.14	48174.0
2013-07-08 06:00:00	SPY	ETF	164.14	164.25	164.02	164.04	88456.0
2013-07-08 07:00:00	SPY	ETF	164.04	164.14	163.93	164.1	495176.0
2013-07-08 08:00:00	SPY	ETF	163.59	164.12	163.59	163.9	981383.0
2013-07-08 09:00:00	SPY	ETF	163.9	164.16	163.66	164.08	18897374.0
2013-07-08 10:00:00	SPY	ETF	164.08	164.39	164.0	164.061	19016106.0
2013-07-08 11:00:00	SPY	ETF	164.06	164.23	163.65	163.76	11385925.0
2013-07-08 12:00:00	SPY	ETF	163.76	163.91	163.58	163.7	8874379.0
2013-07-08 13:00:00	SPY	ETF	163.69	164.06	163.59	164.01	7962175.0
2013-07-08 14:00:00	SPY	ETF	164.005	164.12	163.84	164.05	7645401.0
2013-07-08 15:00:00	SPY	ETF	164.0499	164.06	163.68	163.91	19269860.0
2013-07-08 16:00:00	SPY	ETF	163.89	164.19	163.59	164.16	4675323.0
2013-07-08 17:00:00	SPY	ETF	164.18	164.23	163.95	164.16	311480.0
2013-07-08 18:00:00	SPY	ETF	164.15	164.15	164.08	164.12	89377.0
2013-07-08 19:00:00	SPY	ETF	164.12	164.26	164.12	164.26	159725.0
2013-07-08 04:00:00	QQQ	ETF	72.88	72.89	72.82	72.88	17100.0
2013-07-08 05:00:00	QQQ	ETF	72.88	73.05	72.88	73.02	13400.0
2013-07-08 06:00:00	QQQ	ETF	73.02	73.07	72.98	72.98	11500.0
2013-07-08 07:00:00	QQQ	ETF	72.96	73.01	72.94	73.0	20432.0
2013-07-08 08:00:00	QQQ	ETF	72.99	73.01	72.92	72.93	68335.0
2013-07-08 09:00:00	QQQ	ETF	72.92	72.99	72.75	72.82	3455912.0
2013-07-08 10:00:00	QQQ	ETF	72.82	72.97	72.5792	72.62	4771361.0
2013-07-08 11:00:00	QQQ	ETF	72.62	72.711	72.48	72.5	2442454.0
2013-07-08 12:00:00	QQQ	ETF	72.491	72.55	72.38	72.42	2091333.0
2013-07-08 13:00:00	QQQ	ETF	72.42	72.59	72.38	72.5499	1646890.0
2013-07-08 14:00:00	QQQ	ETF	72.55	72.62	72.46	72.59	1037154.0
2013-07-08 15:00:00	QQQ	ETF	72.6	72.65	72.47	72.64	4043375.0
2013-07-08 16:00:00	QQQ	ETF	72.64	72.746	72.4982	72.7	554673.0
2013-07-08 17:00:00	QQQ	ETF	72.71	72.71	72.64	72.65	35135.0
2013-07-08 18:00:00	QQQ	ETF	72.66	72.66	72.66	72.66	16000.0
2013-07-08 19:00:00	QQQ	ETF	72.66	72.71	72.66	72.7	5235.0
2013-07-08 04:00:00	IWM	ETF	100.06	100.06	100.06	100.06	320.0
2013-07-08 05:00:00	IWM	ETF	100.28	100.28	100.2	100.2	2600.0
2013-07-08 06:00:00	IWM	ETF	100.2	100.3	100.07	100.3	6700.0
2013-07-08 07:00:00	IWM	ETF	100.27	100.28	100.18	100.23	10523.0
2013-07-08 08:00:00	IWM	ETF	100.26	100.27	100.15	100.19	301488.0
2013-07-08 09:00:00	IWM	ETF	100.19	100.23	99.9	100.16	3827364.0
2013-07-08 10:00:00	IWM	ETF	100.15	100.44	100.12	100.19	5486969.0
2013-07-08 11:00:00	IWM	ETF	100.18	100.33	100.045	100.1	3279232.0
2013-07-08 12:00:00	IWM	ETF	100.09	100.34	99.89	100.25	3108671.0
2013-07-08 13:00:00	IWM	ETF	100.25	100.3	100.03	100.2	2607361.0
2013-07-08 14:00:00	IWM	ETF	100.21	100.3	100.15	100.23	2484244.0
2013-07-08 15:00:00	IWM	ETF	100.23	100.26	100.03	100.1	5216741.0
2013-07-08 16:00:00	IWM	ETF	100.11	100.2276	100.06	100.19	1744930.0
2013-07-08 17:00:00	IWM	ETF	100.19	100.19	100.05	100.05	57364.0
2013-07-08 18:00:00	IWM	ETF	100.11	100.15	100.11	100.15	6350.0
2013-07-08 19:00:00	IWM	ETF	100.15	100.2	100.15	100.15	15250.0
2013-07-08 05:00:00	DIA	ETF	151.8	151.89	151.8	151.89	361.0
2013-07-08 07:00:00	DIA	ETF	151.82	151.85	151.77	151.85	1300.0

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

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