PREVIEW / etf_1hour / 2011-01-13

all etf 1-hour files

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

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-13 04:00:00	SPY	ETF	128.54	128.72	128.21	128.21	4750.0
2011-01-13 05:00:00	SPY	ETF	128.62	128.65	128.51	128.51	20700.0
2011-01-13 06:00:00	SPY	ETF	128.55	128.7	128.55	128.7	3300.0
2011-01-13 07:00:00	SPY	ETF	128.65	128.83	128.61	128.76	116290.0
2011-01-13 08:00:00	SPY	ETF	128.75	128.84	128.31	128.43	1800453.0
2011-01-13 09:00:00	SPY	ETF	128.435	128.66	128.38	128.53	12407161.0
2011-01-13 10:00:00	SPY	ETF	128.53	128.55	128.17	128.46	19676934.0
2011-01-13 11:00:00	SPY	ETF	128.47	128.69	128.42	128.55	9801484.0
2011-01-13 12:00:00	SPY	ETF	128.55	128.69	128.48	128.53	7877753.0
2011-01-13 13:00:00	SPY	ETF	128.525	128.62	128.38	128.48	10318663.0
2011-01-13 14:00:00	SPY	ETF	128.48	128.5101	128.13	128.18	19826246.0
2011-01-13 15:00:00	SPY	ETF	128.18	128.47	128.05	128.42	25850016.0
2011-01-13 16:00:00	SPY	ETF	128.42	128.74	128.1926	128.64	18946536.0
2011-01-13 17:00:00	SPY	ETF	128.66	128.83	128.6077	128.74	842672.0
2011-01-13 18:00:00	SPY	ETF	128.76	128.8	128.45	128.7	176090.0
2011-01-13 19:00:00	SPY	ETF	128.68	128.68	128.61	128.63	78680.0
2011-01-13 06:00:00	QQQ	ETF	56.59	56.59	56.59	56.59	100.0
2011-01-13 07:00:00	QQQ	ETF	56.62	56.68	56.61	56.66	24100.0
2011-01-13 08:00:00	QQQ	ETF	56.66	56.67	56.48	56.52	517862.0
2011-01-13 09:00:00	QQQ	ETF	56.52	56.6	56.44	56.545	7710848.0
2011-01-13 10:00:00	QQQ	ETF	56.55	56.71	56.48	56.68	9471792.0
2011-01-13 11:00:00	QQQ	ETF	56.685	56.73	56.61	56.62	4928020.0
2011-01-13 12:00:00	QQQ	ETF	56.61	56.7	56.61	56.64	2410294.0
2011-01-13 13:00:00	QQQ	ETF	56.64	56.7	56.58	56.62	3759605.0
2011-01-13 14:00:00	QQQ	ETF	56.63	56.65	56.46	56.4896	3670707.0
2011-01-13 15:00:00	QQQ	ETF	56.4819	56.6	56.41	56.6	8680812.0
2011-01-13 16:00:00	QQQ	ETF	56.61	56.9	56.54	56.7	3658043.0
2011-01-13 17:00:00	QQQ	ETF	56.7	56.8	56.69	56.77	279133.0
2011-01-13 18:00:00	QQQ	ETF	56.75	56.75	56.72	56.73	44494.0
2011-01-13 19:00:00	QQQ	ETF	56.72	56.72	56.68	56.68	46297.0
2011-01-13 06:00:00	IWM	ETF	79.95	79.95	79.95	79.95	100.0
2011-01-13 07:00:00	IWM	ETF	79.99	80.11	79.98	80.1	13760.0
2011-01-13 08:00:00	IWM	ETF	80.08	80.13	79.63	79.83	204485.0
2011-01-13 09:00:00	IWM	ETF	79.82	80.03	79.75	79.98	3304554.0
2011-01-13 10:00:00	IWM	ETF	79.98	80.1	79.75	80.0601	4106972.0
2011-01-13 11:00:00	IWM	ETF	80.06	80.3	80.0	80.13	2830890.0
2011-01-13 12:00:00	IWM	ETF	80.13	80.24	80.06	80.07	2352027.0
2011-01-13 13:00:00	IWM	ETF	80.075	80.18	79.91	80.09	1952360.0
2011-01-13 14:00:00	IWM	ETF	80.0884	80.09	79.66	79.71	5343302.0
2011-01-13 15:00:00	IWM	ETF	79.72	79.95	79.57	79.95	7301024.0
2011-01-13 16:00:00	IWM	ETF	79.94	80.11	79.91	80.11	679245.0
2011-01-13 17:00:00	IWM	ETF	80.11	80.27	80.11	80.27	50463.0
2011-01-13 18:00:00	IWM	ETF	80.16	80.23	80.09	80.2	17008.0
2011-01-13 19:00:00	IWM	ETF	80.11	80.2	80.1	80.16	9281.0
2011-01-13 05:00:00	DIA	ETF	117.29	117.29	117.25	117.25	6700.0
2011-01-13 07:00:00	DIA	ETF	117.5	117.5	117.49	117.49	7000.0
2011-01-13 08:00:00	DIA	ETF	117.47	117.47	117.17	117.17	108545.0
2011-01-13 09:00:00	DIA	ETF	117.21	117.38	117.15	117.25	1116178.0
2011-01-13 10:00:00	DIA	ETF	117.25	117.26	116.99	117.18	791929.0
2011-01-13 11:00:00	DIA	ETF	117.18	117.33	117.14	117.18	395972.0

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

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