PREVIEW / etf_1hour / 2011-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-22.parquet
  size:    181 KB
  rows:    5,537

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-06-22 04:00:00	SPY	ETF	129.25	129.25	128.91	129.0	2200.0
2011-06-22 05:00:00	SPY	ETF	129.01	129.01	128.69	128.77	31500.0
2011-06-22 06:00:00	SPY	ETF	128.79	128.92	128.68	128.78	36300.0
2011-06-22 07:00:00	SPY	ETF	128.78	129.16	128.75	129.16	1217136.0
2011-06-22 08:00:00	SPY	ETF	129.16	129.22	128.74	128.89	2130463.0
2011-06-22 09:00:00	SPY	ETF	128.9	129.55	128.9	129.49	19579495.0
2011-06-22 10:00:00	SPY	ETF	129.49	129.81	129.15	129.74	26708970.0
2011-06-22 11:00:00	SPY	ETF	129.73	129.75	129.48	129.48	15304565.0
2011-06-22 12:00:00	SPY	ETF	129.48	129.715	129.21	129.66	16653073.0
2011-06-22 13:00:00	SPY	ETF	129.66	129.7	129.5	129.7	7545843.0
2011-06-22 14:00:00	SPY	ETF	129.69	129.77	129.11	129.16	27783066.0
2011-06-22 15:00:00	SPY	ETF	129.165	129.37	128.59	128.67	45197981.0
2011-06-22 16:00:00	SPY	ETF	128.68	129.4738	128.35	128.42	11636715.0
2011-06-22 17:00:00	SPY	ETF	128.41	128.46	128.29	128.38	215036.0
2011-06-22 18:00:00	SPY	ETF	128.39	128.7	128.0	128.05	575616.0
2011-06-22 19:00:00	SPY	ETF	128.06	128.09	127.93	128.05	189387.0
2011-06-22 04:00:00	QQQ	ETF	55.0	55.05	55.0	55.05	461.0
2011-06-22 05:00:00	QQQ	ETF	55.05	55.05	54.93	54.93	2000.0
2011-06-22 06:00:00	QQQ	ETF	54.94	54.97	54.94	54.97	2650.0
2011-06-22 07:00:00	QQQ	ETF	54.91	55.07	54.91	55.07	44400.0
2011-06-22 08:00:00	QQQ	ETF	55.07	55.1	54.94	55.02	421027.0
2011-06-22 09:00:00	QQQ	ETF	55.03	55.22	54.97	55.1862	5032278.0
2011-06-22 10:00:00	QQQ	ETF	55.18	55.29	55.06	55.23	4950767.0
2011-06-22 11:00:00	QQQ	ETF	55.23	55.26	55.14	55.15	2911513.0
2011-06-22 12:00:00	QQQ	ETF	55.15	55.28	55.08	55.25	3904867.0
2011-06-22 13:00:00	QQQ	ETF	55.25	55.29	55.18	55.265	1806471.0
2011-06-22 14:00:00	QQQ	ETF	55.27	55.32	55.08	55.11	7082873.0
2011-06-22 15:00:00	QQQ	ETF	55.11	55.175	54.82	54.835	7995119.0
2011-06-22 16:00:00	QQQ	ETF	54.84	54.85	54.73	54.75	1108319.0
2011-06-22 17:00:00	QQQ	ETF	54.75	54.78	54.71	54.78	127336.0
2011-06-22 18:00:00	QQQ	ETF	54.76	54.84	54.6	54.61	125412.0
2011-06-22 19:00:00	QQQ	ETF	54.61	54.63	54.6	54.63	19559.0
2011-06-22 05:00:00	IWM	ETF	80.23	80.33	80.06	80.06	3300.0
2011-06-22 06:00:00	IWM	ETF	80.06	80.08	79.95	80.0	7900.0
2011-06-22 07:00:00	IWM	ETF	80.01	80.26	79.99	80.26	39550.0
2011-06-22 08:00:00	IWM	ETF	80.33	80.36	80.0	80.12	533254.0
2011-06-22 09:00:00	IWM	ETF	80.12	80.66	80.12	80.64	5682506.0
2011-06-22 10:00:00	IWM	ETF	80.63	80.97	80.32	80.92	7948940.0
2011-06-22 11:00:00	IWM	ETF	80.91	81.11	80.81	80.9001	4649798.0
2011-06-22 12:00:00	IWM	ETF	80.89	81.05	80.65	80.97	5668189.0
2011-06-22 13:00:00	IWM	ETF	80.97	81.08	80.87	81.05	2637618.0
2011-06-22 14:00:00	IWM	ETF	81.05	81.06	80.4	80.49	10185843.0
2011-06-22 15:00:00	IWM	ETF	80.48	80.66	80.01	80.04	14164125.0
2011-06-22 16:00:00	IWM	ETF	80.03	80.6	79.81	79.81	1584489.0
2011-06-22 17:00:00	IWM	ETF	79.81	79.9	79.77	79.85	15653.0
2011-06-22 18:00:00	IWM	ETF	79.75	79.8	79.69	79.71	29041.0
2011-06-22 19:00:00	IWM	ETF	79.71	79.75	79.63	79.67	8041.0
2011-06-22 05:00:00	DIA	ETF	121.15	121.16	120.95	120.95	6900.0
2011-06-22 06:00:00	DIA	ETF	120.99	121.06	120.99	121.06	500.0
2011-06-22 07:00:00	DIA	ETF	121.05	121.26	120.97	121.26	1700.0

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

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