PREVIEW / etf_1hour / 2012-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-05.parquet
  size:    183 KB
  rows:    5,650

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
2012-11-05 04:00:00	SPY	ETF	141.16	141.26	141.12	141.12	6640.0
2012-11-05 05:00:00	SPY	ETF	141.09	141.3	141.0	141.3	102326.0
2012-11-05 06:00:00	SPY	ETF	141.34	141.35	141.09	141.19	32709.0
2012-11-05 07:00:00	SPY	ETF	141.22	141.23	140.93	141.1	163718.0
2012-11-05 08:00:00	SPY	ETF	141.1	141.37	140.96	141.3	941157.0
2012-11-05 09:00:00	SPY	ETF	141.31	141.42	140.95	141.12	15978839.0
2012-11-05 10:00:00	SPY	ETF	141.12	141.66	140.93	141.5901	14671414.0
2012-11-05 11:00:00	SPY	ETF	141.6	141.72	141.33	141.445	9424484.0
2012-11-05 12:00:00	SPY	ETF	141.44	141.5	141.11	141.2	8253435.0
2012-11-05 13:00:00	SPY	ETF	141.19	141.54	141.17	141.45	8509458.0
2012-11-05 14:00:00	SPY	ETF	141.45	141.8	141.43	141.69	8172217.0
2012-11-05 15:00:00	SPY	ETF	141.69	142.17	141.64	141.87	21921244.0
2012-11-05 16:00:00	SPY	ETF	141.88	141.9391	141.14	141.7	2569301.0
2012-11-05 17:00:00	SPY	ETF	141.7	141.73	141.59	141.71	111094.0
2012-11-05 18:00:00	SPY	ETF	141.71	141.75	141.68	141.68	48388.0
2012-11-05 19:00:00	SPY	ETF	141.71	141.72	141.63	141.63	17785.0
2012-11-05 04:00:00	QQQ	ETF	65.01	65.01	65.01	65.01	100.0
2012-11-05 05:00:00	QQQ	ETF	64.93	64.93	64.93	64.93	950.0
2012-11-05 07:00:00	QQQ	ETF	65.03	65.03	64.89	64.92	33850.0
2012-11-05 08:00:00	QQQ	ETF	64.93	65.19	64.85	65.16	702842.0
2012-11-05 09:00:00	QQQ	ETF	65.15	65.35	65.04	65.2	4830537.0
2012-11-05 10:00:00	QQQ	ETF	65.2199	65.51	65.06	65.4699	4252965.0
2012-11-05 11:00:00	QQQ	ETF	65.46	65.51	65.26	65.325	2117716.0
2012-11-05 12:00:00	QQQ	ETF	65.33	65.33	65.07	65.1201	1887656.0
2012-11-05 13:00:00	QQQ	ETF	65.13	65.3299	65.12	65.22	1891416.0
2012-11-05 14:00:00	QQQ	ETF	65.22	65.51	65.22	65.44	1931466.0
2012-11-05 15:00:00	QQQ	ETF	65.4499	65.73	65.4	65.59	4560705.0
2012-11-05 16:00:00	QQQ	ETF	65.6	65.63	65.385	65.385	476810.0
2012-11-05 17:00:00	QQQ	ETF	65.39	65.39	65.1872	65.33	515060.0
2012-11-05 18:00:00	QQQ	ETF	65.33	65.35	65.1708	65.1708	1005373.0
2012-11-05 19:00:00	QQQ	ETF	65.35	65.35	65.32	65.32	8453.0
2012-11-05 08:00:00	IWM	ETF	80.98	81.19	80.94	81.14	119509.0
2012-11-05 09:00:00	IWM	ETF	81.12	81.33	80.92	81.15	2955252.0
2012-11-05 10:00:00	IWM	ETF	81.15	81.72	81.08	81.69	4991184.0
2012-11-05 11:00:00	IWM	ETF	81.69	81.81	81.39	81.6	3368779.0
2012-11-05 12:00:00	IWM	ETF	81.6	81.67	81.38	81.44	2257682.0
2012-11-05 13:00:00	IWM	ETF	81.45	81.7	81.44	81.59	1865658.0
2012-11-05 14:00:00	IWM	ETF	81.59	81.84	81.59	81.75	1732500.0
2012-11-05 15:00:00	IWM	ETF	81.76	81.83	81.61	81.77	4875755.0
2012-11-05 16:00:00	IWM	ETF	81.74	81.79	80.95	81.66	1618669.0
2012-11-05 17:00:00	IWM	ETF	81.62	81.68	81.6	81.6	46525.0
2012-11-05 19:00:00	IWM	ETF	81.69	81.7	81.69	81.7	1120.0
2012-11-05 08:00:00	DIA	ETF	130.3	130.46	130.29	130.42	16952.0
2012-11-05 09:00:00	DIA	ETF	130.4	130.52	130.21	130.29	445271.0
2012-11-05 10:00:00	DIA	ETF	130.3	130.65	130.11	130.6139	521113.0
2012-11-05 11:00:00	DIA	ETF	130.61	130.74	130.445	130.5198	271310.0
2012-11-05 12:00:00	DIA	ETF	130.51	130.558	130.32	130.33	263722.0
2012-11-05 13:00:00	DIA	ETF	130.35	130.58	130.3	130.52	209173.0
2012-11-05 14:00:00	DIA	ETF	130.53	130.76	130.51	130.67	222196.0
2012-11-05 15:00:00	DIA	ETF	130.68	131.13	130.65	130.85	604804.0

> showing 50 of 5,650 rows — these rows as CSV

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