PREVIEW / etf_1hour / 2013-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-24.parquet
  size:    208 KB
  rows:    6,486

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-24 04:00:00	SPY	ETF	169.53	169.7	169.53	169.7	18027.0
2013-07-24 05:00:00	SPY	ETF	169.7	169.76	169.48	169.52	117650.0
2013-07-24 06:00:00	SPY	ETF	169.5	169.75	169.48	169.71	130700.0
2013-07-24 07:00:00	SPY	ETF	169.71	169.94	169.71	169.86	399622.0
2013-07-24 08:00:00	SPY	ETF	169.84	169.94	169.61	169.69	534856.0
2013-07-24 09:00:00	SPY	ETF	169.69	169.86	169.11	169.1299	14613453.0
2013-07-24 10:00:00	SPY	ETF	169.12	169.29	168.68	168.87	19894993.0
2013-07-24 11:00:00	SPY	ETF	168.87	169.13	168.75	168.88	11155239.0
2013-07-24 12:00:00	SPY	ETF	168.88	168.92	168.45	168.52	11846596.0
2013-07-24 13:00:00	SPY	ETF	168.52	168.65	168.18	168.37	14203137.0
2013-07-24 14:00:00	SPY	ETF	168.37	168.62	168.36	168.54	9790122.0
2013-07-24 15:00:00	SPY	ETF	168.535	168.59	168.24	168.53	21212060.0
2013-07-24 16:00:00	SPY	ETF	168.53	168.88	168.39	168.85	5578301.0
2013-07-24 17:00:00	SPY	ETF	168.86	168.89	168.82	168.86	78060.0
2013-07-24 18:00:00	SPY	ETF	168.85	168.89	168.76	168.77	65001.0
2013-07-24 19:00:00	SPY	ETF	168.75	168.8	168.7	168.73	47709.0
2013-07-24 04:00:00	QQQ	ETF	74.83	74.88	74.82	74.88	34300.0
2013-07-24 05:00:00	QQQ	ETF	74.9	74.9	74.84	74.84	4400.0
2013-07-24 06:00:00	QQQ	ETF	74.83	74.93	74.82	74.89	18924.0
2013-07-24 07:00:00	QQQ	ETF	74.92	75.01	74.92	74.99	42700.0
2013-07-24 08:00:00	QQQ	ETF	74.89	75.01	74.89	74.96	162545.0
2013-07-24 09:00:00	QQQ	ETF	74.96	75.02	74.61	74.63	3971544.0
2013-07-24 10:00:00	QQQ	ETF	74.62	74.72	74.4	74.63	3757356.0
2013-07-24 11:00:00	QQQ	ETF	74.63	74.87	74.62	74.71	2550116.0
2013-07-24 12:00:00	QQQ	ETF	74.71	74.77	74.49	74.55	2193038.0
2013-07-24 13:00:00	QQQ	ETF	74.549	74.58	74.33	74.44	2367082.0
2013-07-24 14:00:00	QQQ	ETF	74.4494	74.58	74.43	74.53	1340586.0
2013-07-24 15:00:00	QQQ	ETF	74.53	74.57	74.41	74.49	4297652.0
2013-07-24 16:00:00	QQQ	ETF	74.5	74.93	74.2615	74.91	2980598.0
2013-07-24 17:00:00	QQQ	ETF	74.93	74.94	74.87	74.88	42503.0
2013-07-24 18:00:00	QQQ	ETF	74.9	74.92	74.88	74.92	22350.0
2013-07-24 19:00:00	QQQ	ETF	74.89	74.9	74.88	74.89	25750.0
2013-07-24 05:00:00	IWM	ETF	104.85	104.85	104.85	104.85	120.0
2013-07-24 06:00:00	IWM	ETF	104.75	104.94	104.75	104.94	1120.0
2013-07-24 07:00:00	IWM	ETF	104.98	105.07	104.98	104.99	144800.0
2013-07-24 08:00:00	IWM	ETF	104.98	105.0	104.81	104.86	58553.0
2013-07-24 09:00:00	IWM	ETF	104.86	104.98	104.3	104.3	3525406.0
2013-07-24 10:00:00	IWM	ETF	104.29	104.44	103.93	104.16	5532452.0
2013-07-24 11:00:00	IWM	ETF	104.16	104.33	104.04	104.05	2981813.0
2013-07-24 12:00:00	IWM	ETF	104.04	104.1	103.69	103.73	2745507.0
2013-07-24 13:00:00	IWM	ETF	103.73	103.795	103.44	103.615	3303765.0
2013-07-24 14:00:00	IWM	ETF	103.61	103.84	103.59	103.71	2931776.0
2013-07-24 15:00:00	IWM	ETF	103.71	103.725	103.46	103.59	4785619.0
2013-07-24 16:00:00	IWM	ETF	103.58	104.4122	103.5436	103.85	2169599.0
2013-07-24 17:00:00	IWM	ETF	103.84	103.86	103.81	103.81	13511.0
2013-07-24 18:00:00	IWM	ETF	103.81	103.86	103.72	103.86	10597.0
2013-07-24 19:00:00	IWM	ETF	103.78	103.78	103.78	103.78	2600.0
2013-07-24 05:00:00	DIA	ETF	155.6	155.6	155.6	155.6	180.0
2013-07-24 07:00:00	DIA	ETF	155.7	155.82	155.7	155.76	5300.0
2013-07-24 08:00:00	DIA	ETF	155.7	155.73	155.65	155.65	6200.0

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

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