PREVIEW / etf_1hour / 2011-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-14.parquet
  size:    176 KB
  rows:    5,339

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-01-14 04:00:00	SPY	ETF	128.42	128.42	128.13	128.13	5100.0
2011-01-14 05:00:00	SPY	ETF	128.35	128.41	128.08	128.32	13000.0
2011-01-14 06:00:00	SPY	ETF	128.27	128.43	128.24	128.37	121700.0
2011-01-14 07:00:00	SPY	ETF	128.37	128.37	127.9	128.11	299662.0
2011-01-14 08:00:00	SPY	ETF	128.1	128.2	127.83	128.11	2397720.0
2011-01-14 09:00:00	SPY	ETF	128.1	128.49	128.08	128.46	15067343.0
2011-01-14 10:00:00	SPY	ETF	128.47	128.77	128.27	128.64	17515151.0
2011-01-14 11:00:00	SPY	ETF	128.64	128.87	128.391	128.741	13858435.0
2011-01-14 12:00:00	SPY	ETF	128.75	129.01	128.72	128.88	11362790.0
2011-01-14 13:00:00	SPY	ETF	128.88	129.22	128.84	129.1499	8731732.0
2011-01-14 14:00:00	SPY	ETF	129.15	129.26	129.09	129.15	9639204.0
2011-01-14 15:00:00	SPY	ETF	129.15	129.33	129.11	129.28	22343548.0
2011-01-14 16:00:00	SPY	ETF	129.29	129.4382	128.275	129.35	12567865.0
2011-01-14 17:00:00	SPY	ETF	129.36	129.43	129.26	129.3	388085.0
2011-01-14 18:00:00	SPY	ETF	129.3	129.36	129.28	129.36	44712.0
2011-01-14 19:00:00	SPY	ETF	129.33	129.36	129.3	129.33	25761.0
2011-01-14 04:00:00	QQQ	ETF	56.6	56.6	56.56	56.56	9000.0
2011-01-14 05:00:00	QQQ	ETF	56.53	56.61	56.53	56.61	4200.0
2011-01-14 06:00:00	QQQ	ETF	56.63	56.66	56.62	56.66	1000.0
2011-01-14 07:00:00	QQQ	ETF	56.61	56.61	56.49	56.49	45092.0
2011-01-14 08:00:00	QQQ	ETF	56.52	56.59	56.44	56.55	406829.0
2011-01-14 09:00:00	QQQ	ETF	56.54	56.62	56.46	56.57	6620305.0
2011-01-14 10:00:00	QQQ	ETF	56.5667	56.76	56.55	56.7209	8884470.0
2011-01-14 11:00:00	QQQ	ETF	56.729	56.85	56.72	56.7519	4909257.0
2011-01-14 12:00:00	QQQ	ETF	56.76	56.86	56.755	56.821	2888237.0
2011-01-14 13:00:00	QQQ	ETF	56.828	56.94	56.8	56.9162	2931796.0
2011-01-14 14:00:00	QQQ	ETF	56.91	56.949	56.88	56.91	3574281.0
2011-01-14 15:00:00	QQQ	ETF	56.92	57.02	56.91	57.015	8864467.0
2011-01-14 16:00:00	QQQ	ETF	57.005	57.05	56.9399	57.01	1997790.0
2011-01-14 17:00:00	QQQ	ETF	57.01	57.08	56.99	57.07	23199.0
2011-01-14 18:00:00	QQQ	ETF	57.0	57.06	56.99	57.03	2943.0
2011-01-14 19:00:00	QQQ	ETF	57.06	57.06	57.0	57.03	4397.0
2011-01-14 05:00:00	IWM	ETF	79.92	79.92	79.92	79.92	1000.0
2011-01-14 06:00:00	IWM	ETF	79.9	79.9	79.9	79.9	4200.0
2011-01-14 07:00:00	IWM	ETF	79.91	79.91	79.59	79.76	122230.0
2011-01-14 08:00:00	IWM	ETF	79.73	79.83	79.56	79.77	429613.0
2011-01-14 09:00:00	IWM	ETF	79.77	80.015	79.73	79.89	4576573.0
2011-01-14 10:00:00	IWM	ETF	79.9	80.08	79.69	79.898	6485227.0
2011-01-14 11:00:00	IWM	ETF	79.9	80.19	79.86	80.11	3858470.0
2011-01-14 12:00:00	IWM	ETF	80.12	80.36	80.08	80.2599	2870511.0
2011-01-14 13:00:00	IWM	ETF	80.2599	80.51	80.23	80.46	3200138.0
2011-01-14 14:00:00	IWM	ETF	80.47	80.56	80.32	80.36	3259797.0
2011-01-14 15:00:00	IWM	ETF	80.36	80.68	80.33	80.47	8477205.0
2011-01-14 16:00:00	IWM	ETF	80.54	80.67	79.8	80.67	1336025.0
2011-01-14 17:00:00	IWM	ETF	80.67	80.69	80.6	80.6	6243.0
2011-01-14 19:00:00	IWM	ETF	80.6	80.6	80.56	80.58	2300.0
2011-01-14 05:00:00	DIA	ETF	117.0	117.0	117.0	117.0	100.0
2011-01-14 07:00:00	DIA	ETF	116.95	116.95	116.73	116.84	5200.0
2011-01-14 08:00:00	DIA	ETF	116.87	116.88	116.68	116.84	17911.0
2011-01-14 09:00:00	DIA	ETF	116.84	117.09	116.8045	117.06	852923.0

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

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