PREVIEW / etf_1hour / 2011-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-29.parquet
  size:    188 KB
  rows:    5,807

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-29 04:00:00	SPY	ETF	130.05	130.05	129.42	129.83	5100.0
2011-07-29 05:00:00	SPY	ETF	129.65	129.8	129.5	129.73	2800.0
2011-07-29 06:00:00	SPY	ETF	129.74	129.74	129.18	129.41	70300.0
2011-07-29 07:00:00	SPY	ETF	129.48	129.72	129.38	129.52	385758.0
2011-07-29 08:00:00	SPY	ETF	129.56	129.67	128.67	128.95	8816131.0
2011-07-29 09:00:00	SPY	ETF	128.96	129.29	128.36	129.11	50166471.0
2011-07-29 10:00:00	SPY	ETF	129.12	130.14	127.9667	129.92	59810695.0
2011-07-29 11:00:00	SPY	ETF	129.93	130.55	129.25	130.05	34936081.0
2011-07-29 12:00:00	SPY	ETF	130.05	130.14	129.51	129.565	25931786.0
2011-07-29 13:00:00	SPY	ETF	129.57	130.05	129.44	129.97	18055751.0
2011-07-29 14:00:00	SPY	ETF	129.97	130.19	129.6859	129.79	18202232.0
2011-07-29 15:00:00	SPY	ETF	129.79	130.0	129.23	129.32	55113414.0
2011-07-29 16:00:00	SPY	ETF	129.32	130.174	129.01	129.51	32515935.0
2011-07-29 17:00:00	SPY	ETF	129.5	129.59	129.41	129.45	200086.0
2011-07-29 18:00:00	SPY	ETF	129.43	129.5	129.05	129.42	442742.0
2011-07-29 19:00:00	SPY	ETF	129.42	129.59	129.42	129.58	64039.0
2011-07-29 04:00:00	QQQ	ETF	58.23	58.23	57.97	58.11	700.0
2011-07-29 06:00:00	QQQ	ETF	58.01	58.01	57.99	57.99	1600.0
2011-07-29 07:00:00	QQQ	ETF	58.0	58.06	57.95	58.0	52025.0
2011-07-29 08:00:00	QQQ	ETF	57.99	58.11	57.7	57.79	1126359.0
2011-07-29 09:00:00	QQQ	ETF	57.79	57.89	57.44	57.87	12893234.0
2011-07-29 10:00:00	QQQ	ETF	57.865	58.36	57.68	58.32	17825740.0
2011-07-29 11:00:00	QQQ	ETF	58.32	58.61	58.2	58.33	10350136.0
2011-07-29 12:00:00	QQQ	ETF	58.34	58.37	58.08	58.11	6339739.0
2011-07-29 13:00:00	QQQ	ETF	58.11	58.41	58.07	58.35	6529059.0
2011-07-29 14:00:00	QQQ	ETF	58.35	58.44	58.185	58.21	4377370.0
2011-07-29 15:00:00	QQQ	ETF	58.22	58.29	57.97	58.0	11162470.0
2011-07-29 16:00:00	QQQ	ETF	58.0	58.11	57.84	58.01	3312247.0
2011-07-29 17:00:00	QQQ	ETF	58.01	58.1269	57.99	58.09	46236.0
2011-07-29 18:00:00	QQQ	ETF	58.08	58.1	57.97	58.08	25892.0
2011-07-29 19:00:00	QQQ	ETF	58.05	58.11	58.05	58.11	6546.0
2011-07-29 04:00:00	IWM	ETF	79.5	79.5	79.5	79.5	272.0
2011-07-29 05:00:00	IWM	ETF	79.76	79.76	79.76	79.76	100.0
2011-07-29 06:00:00	IWM	ETF	79.42	79.42	79.42	79.42	100.0
2011-07-29 07:00:00	IWM	ETF	79.45	79.57	79.39	79.43	27600.0
2011-07-29 08:00:00	IWM	ETF	79.47	79.47	78.62	78.82	1745341.0
2011-07-29 09:00:00	IWM	ETF	78.82	79.07	78.14	79.01	14389082.0
2011-07-29 10:00:00	IWM	ETF	79.0	79.89	78.67	79.72	21158982.0
2011-07-29 11:00:00	IWM	ETF	79.71	80.18	79.56	79.66	9929572.0
2011-07-29 12:00:00	IWM	ETF	79.66	79.69	79.29	79.505	5233524.0
2011-07-29 13:00:00	IWM	ETF	79.5	79.99	79.44	79.95	3318851.0
2011-07-29 14:00:00	IWM	ETF	79.95	80.15	79.64	79.72	5329705.0
2011-07-29 15:00:00	IWM	ETF	79.72	79.86	79.455	79.74	15010271.0
2011-07-29 16:00:00	IWM	ETF	79.74	79.98	79.5	79.86	2202023.0
2011-07-29 17:00:00	IWM	ETF	79.83	79.89	79.77	79.84	26680.0
2011-07-29 18:00:00	IWM	ETF	79.79	79.86	79.7	79.76	8068.0
2011-07-29 19:00:00	IWM	ETF	79.84	79.9	79.79	79.9	6101.0
2011-07-29 05:00:00	DIA	ETF	121.88	121.88	121.88	121.88	100.0
2011-07-29 06:00:00	DIA	ETF	121.64	121.64	121.54	121.54	200.0
2011-07-29 07:00:00	DIA	ETF	121.61	121.68	121.61	121.68	1500.0

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

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