PREVIEW / etf_1hour / 2011-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-28.parquet
  size:    184 KB
  rows:    5,665

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
2011-07-28 04:00:00	SPY	ETF	130.77	131.0	130.77	130.92	3350.0
2011-07-28 05:00:00	SPY	ETF	130.62	130.8	130.4	130.4	3600.0
2011-07-28 06:00:00	SPY	ETF	130.3	130.7	130.11	130.6	123671.0
2011-07-28 07:00:00	SPY	ETF	130.64	130.75	130.43	130.53	456734.0
2011-07-28 08:00:00	SPY	ETF	130.54	131.05	130.18	130.6	7251611.0
2011-07-28 09:00:00	SPY	ETF	130.6	130.92	130.45	130.79	22055264.0
2011-07-28 10:00:00	SPY	ETF	130.8	131.23	130.48	131.16	29985939.0
2011-07-28 11:00:00	SPY	ETF	131.15	131.73	131.04	131.66	25060179.0
2011-07-28 12:00:00	SPY	ETF	131.669	131.77	131.2	131.39	19769743.0
2011-07-28 13:00:00	SPY	ETF	131.4	131.49	131.14	131.32	15005121.0
2011-07-28 14:00:00	SPY	ETF	131.325	131.35	130.73	130.905	20929022.0
2011-07-28 15:00:00	SPY	ETF	130.9	130.9	130.01	130.22	47357219.0
2011-07-28 16:00:00	SPY	ETF	130.21	130.9188	130.06	130.29	15867761.0
2011-07-28 17:00:00	SPY	ETF	130.3	130.5962	129.7	130.1	1855762.0
2011-07-28 18:00:00	SPY	ETF	130.1	130.34	129.8	130.02	468186.0
2011-07-28 19:00:00	SPY	ETF	130.03	130.13	129.92	130.05	100040.0
2011-07-28 04:00:00	QQQ	ETF	58.3	58.3	58.3	58.3	100.0
2011-07-28 06:00:00	QQQ	ETF	57.94	58.03	57.94	58.03	300.0
2011-07-28 07:00:00	QQQ	ETF	58.05	58.12	58.0	58.03	54009.0
2011-07-28 08:00:00	QQQ	ETF	58.06	58.3	57.92	58.14	668745.0
2011-07-28 09:00:00	QQQ	ETF	58.16	58.3	57.89	58.27	8943438.0
2011-07-28 10:00:00	QQQ	ETF	58.27	58.6	58.12	58.5501	8100722.0
2011-07-28 11:00:00	QQQ	ETF	58.55	58.89	58.51	58.87	7309875.0
2011-07-28 12:00:00	QQQ	ETF	58.87	58.93	58.69	58.7829	5805580.0
2011-07-28 13:00:00	QQQ	ETF	58.78	58.87	58.68	58.75	5560108.0
2011-07-28 14:00:00	QQQ	ETF	58.755	58.7638	58.355	58.52	7671056.0
2011-07-28 15:00:00	QQQ	ETF	58.52	58.52	58.13	58.22	11133803.0
2011-07-28 16:00:00	QQQ	ETF	58.22	58.34	58.15	58.3	4656238.0
2011-07-28 17:00:00	QQQ	ETF	58.3	58.32	58.07	58.16	61342.0
2011-07-28 18:00:00	QQQ	ETF	58.19	58.26	58.11	58.17	63355.0
2011-07-28 19:00:00	QQQ	ETF	58.18	58.24	58.16	58.23	28942.0
2011-07-28 04:00:00	IWM	ETF	80.18	80.18	80.08	80.08	8411.0
2011-07-28 05:00:00	IWM	ETF	79.82	79.82	79.82	79.82	111.0
2011-07-28 06:00:00	IWM	ETF	79.77	79.94	79.77	79.94	25400.0
2011-07-28 07:00:00	IWM	ETF	79.94	80.01	79.09	79.9	69094.0
2011-07-28 08:00:00	IWM	ETF	79.9	80.22	79.65	79.99	855486.0
2011-07-28 09:00:00	IWM	ETF	80.0	80.28	79.85	80.21	6966027.0
2011-07-28 10:00:00	IWM	ETF	80.23	80.6	80.02	80.44	8039467.0
2011-07-28 11:00:00	IWM	ETF	80.44	80.95	80.36	80.877	7236953.0
2011-07-28 12:00:00	IWM	ETF	80.88	80.97	80.54	80.697	4312499.0
2011-07-28 13:00:00	IWM	ETF	80.69	80.7	80.37	80.39	7249719.0
2011-07-28 14:00:00	IWM	ETF	80.4	80.41	79.89	80.16	6181936.0
2011-07-28 15:00:00	IWM	ETF	80.16	80.17	79.69	79.84	12047188.0
2011-07-28 16:00:00	IWM	ETF	79.84	79.92	79.72	79.85	5640360.0
2011-07-28 17:00:00	IWM	ETF	79.86	79.87	79.61	79.71	39563.0
2011-07-28 18:00:00	IWM	ETF	79.77	79.82	79.69	79.71	16841.0
2011-07-28 19:00:00	IWM	ETF	79.69	79.76	79.68	79.74	4100.0
2011-07-28 07:00:00	DIA	ETF	122.96	123.0	122.82	122.87	3928.0
2011-07-28 08:00:00	DIA	ETF	122.87	123.2	122.59	122.93	59666.0
2011-07-28 09:00:00	DIA	ETF	122.89	123.16	122.72	122.97	947742.0

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

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