PREVIEW / etf_1hour / 2011-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-23.parquet
  size:    184 KB
  rows:    5,737

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-11-23 04:00:00	SPY	ETF	118.19	118.3	117.77	118.01	164053.0
2011-11-23 05:00:00	SPY	ETF	118.27	118.31	117.37	117.87	82158.0
2011-11-23 06:00:00	SPY	ETF	117.84	118.39	117.77	118.1	153383.0
2011-11-23 07:00:00	SPY	ETF	118.07	118.14	117.67	117.87	679919.0
2011-11-23 08:00:00	SPY	ETF	117.9	118.42	117.55	117.78	3979276.0
2011-11-23 09:00:00	SPY	ETF	117.8	118.24	117.41	117.43	26864297.0
2011-11-23 10:00:00	SPY	ETF	117.43	117.58	117.0	117.3	34811561.0
2011-11-23 11:00:00	SPY	ETF	117.3001	117.45	116.71	117.06	28628254.0
2011-11-23 12:00:00	SPY	ETF	117.05	117.55	116.93	117.45	20291549.0
2011-11-23 13:00:00	SPY	ETF	117.45	119.19	116.99	117.08	17207832.0
2011-11-23 14:00:00	SPY	ETF	117.08	117.15	116.69	116.93	21100943.0
2011-11-23 15:00:00	SPY	ETF	116.92	117.58	116.56	116.63	49944498.0
2011-11-23 16:00:00	SPY	ETF	116.65	119.19	116.44	116.56	15732663.0
2011-11-23 17:00:00	SPY	ETF	116.55	119.19	116.51	116.59	2146472.0
2011-11-23 18:00:00	SPY	ETF	116.6	116.7	116.55	116.67	409214.0
2011-11-23 19:00:00	SPY	ETF	116.69	116.82	116.61	116.76	192138.0
2011-11-23 04:00:00	QQQ	ETF	54.23	54.23	54.01	54.22	5400.0
2011-11-23 05:00:00	QQQ	ETF	54.15	54.15	53.92	53.96	2600.0
2011-11-23 06:00:00	QQQ	ETF	54.05	54.23	54.05	54.19	25915.0
2011-11-23 07:00:00	QQQ	ETF	54.13	54.15	54.0	54.03	33502.0
2011-11-23 08:00:00	QQQ	ETF	54.06	54.16	53.96	54.04	373357.0
2011-11-23 09:00:00	QQQ	ETF	54.03	54.23	53.73	53.73	6597993.0
2011-11-23 10:00:00	QQQ	ETF	53.73	53.8	53.42	53.63	9271633.0
2011-11-23 11:00:00	QQQ	ETF	53.62	53.69	53.39	53.502	5323524.0
2011-11-23 12:00:00	QQQ	ETF	53.5	53.7	53.45	53.66	2668563.0
2011-11-23 13:00:00	QQQ	ETF	53.66	53.745	53.48	53.52	3031618.0
2011-11-23 14:00:00	QQQ	ETF	53.52	53.5387	53.33	53.45	4220491.0
2011-11-23 15:00:00	QQQ	ETF	53.44	53.73	53.26	53.26	9878198.0
2011-11-23 16:00:00	QQQ	ETF	53.27	53.57	53.17	53.26	2044630.0
2011-11-23 17:00:00	QQQ	ETF	53.26	53.29	53.24	53.29	32638.0
2011-11-23 18:00:00	QQQ	ETF	53.27	53.31	53.25	53.27	4620.0
2011-11-23 19:00:00	QQQ	ETF	53.29	53.37	53.28	53.34	30050.0
2011-11-23 04:00:00	IWM	ETF	68.87	68.93	68.87	68.93	1486.0
2011-11-23 05:00:00	IWM	ETF	68.82	68.82	68.35	68.54	1276.0
2011-11-23 06:00:00	IWM	ETF	68.67	69.09	68.67	69.09	600.0
2011-11-23 07:00:00	IWM	ETF	68.85	68.85	68.58	68.69	29803.0
2011-11-23 08:00:00	IWM	ETF	68.7	69.15	68.64	68.73	478267.0
2011-11-23 09:00:00	IWM	ETF	68.71	69.09	68.49	68.5	6073845.0
2011-11-23 10:00:00	IWM	ETF	68.51	68.53	67.72	68.03	12002400.0
2011-11-23 11:00:00	IWM	ETF	68.02	68.14	67.64	67.79	7194236.0
2011-11-23 12:00:00	IWM	ETF	67.795	68.07	67.68	67.97	4539456.0
2011-11-23 13:00:00	IWM	ETF	67.97	68.08	67.7	67.76	3515799.0
2011-11-23 14:00:00	IWM	ETF	67.75	67.82	67.37	67.53	6875226.0
2011-11-23 15:00:00	IWM	ETF	67.52	67.94	67.425	67.5	14264539.0
2011-11-23 16:00:00	IWM	ETF	67.5	69.6375	67.27	69.6375	4150057.0
2011-11-23 17:00:00	IWM	ETF	67.4	67.46	67.37	67.38	10492.0
2011-11-23 18:00:00	IWM	ETF	67.4	67.4418	67.35	67.4418	1803400.0
2011-11-23 19:00:00	IWM	ETF	67.4	67.47	67.38	67.39	33885.0
2011-11-23 04:00:00	DIA	ETF	113.9	113.9	113.65	113.9	400.0
2011-11-23 07:00:00	DIA	ETF	113.9	113.9	113.58	113.65	2107.0

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

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