PREVIEW / etf_1hour / 2011-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-07.parquet
  size:    183 KB
  rows:    5,574

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-09-07 04:00:00	SPY	ETF	117.79	118.43	117.79	118.13	30497.0
2011-09-07 05:00:00	SPY	ETF	118.29	118.3	117.91	117.94	28300.0
2011-09-07 06:00:00	SPY	ETF	118.0	118.6	117.89	118.44	122390.0
2011-09-07 07:00:00	SPY	ETF	118.45	118.55	118.15	118.24	584149.0
2011-09-07 08:00:00	SPY	ETF	118.24	118.62	118.01	118.56	1792134.0
2011-09-07 09:00:00	SPY	ETF	118.56	119.05	118.36	119.0	32642119.0
2011-09-07 10:00:00	SPY	ETF	118.99	119.19	118.71	118.93	33355310.0
2011-09-07 11:00:00	SPY	ETF	118.93	119.48	118.8699	119.37	22358629.0
2011-09-07 12:00:00	SPY	ETF	119.38	119.7	119.28	119.57	16576384.0
2011-09-07 13:00:00	SPY	ETF	119.5691	119.86	119.5	119.78	15448121.0
2011-09-07 14:00:00	SPY	ETF	119.78	120.34	119.71	120.25	23047924.0
2011-09-07 15:00:00	SPY	ETF	120.25	120.34	119.76	120.2899	43469482.0
2011-09-07 16:00:00	SPY	ETF	120.28	120.63	119.1114	120.49	16037014.0
2011-09-07 17:00:00	SPY	ETF	120.48	120.62	120.42	120.55	244325.0
2011-09-07 18:00:00	SPY	ETF	120.55	120.75	120.27	120.7	249099.0
2011-09-07 19:00:00	SPY	ETF	120.68	120.75	120.61	120.71	78883.0
2011-09-07 04:00:00	QQQ	ETF	53.76	53.83	53.75	53.75	400.0
2011-09-07 05:00:00	QQQ	ETF	53.77	53.77	53.77	53.77	500.0
2011-09-07 06:00:00	QQQ	ETF	53.66	53.86	53.51	53.86	15100.0
2011-09-07 07:00:00	QQQ	ETF	53.87	53.87	53.7	53.72	41287.0
2011-09-07 08:00:00	QQQ	ETF	53.74	53.94	53.66	53.93	369901.0
2011-09-07 09:00:00	QQQ	ETF	53.93	54.18	53.9	54.1	7990679.0
2011-09-07 10:00:00	QQQ	ETF	54.1	54.15	53.9	53.989	6991353.0
2011-09-07 11:00:00	QQQ	ETF	53.98	54.27	53.94	54.23	4582572.0
2011-09-07 12:00:00	QQQ	ETF	54.23	54.32	54.18	54.26	2699446.0
2011-09-07 13:00:00	QQQ	ETF	54.26	54.44	54.24	54.35	4638934.0
2011-09-07 14:00:00	QQQ	ETF	54.37	54.64	54.3201	54.62	4388240.0
2011-09-07 15:00:00	QQQ	ETF	54.62	54.65	54.46	54.64	7855645.0
2011-09-07 16:00:00	QQQ	ETF	54.64	54.71	54.5514	54.68	1061565.0
2011-09-07 17:00:00	QQQ	ETF	54.68	54.72	54.66	54.66	48574.0
2011-09-07 18:00:00	QQQ	ETF	54.68	54.79	54.64	54.79	38408.0
2011-09-07 19:00:00	QQQ	ETF	54.79	54.8	54.75	54.78	38900.0
2011-09-07 04:00:00	IWM	ETF	68.5	69.0	68.5	69.0	1025.0
2011-09-07 05:00:00	IWM	ETF	68.76	68.76	68.76	68.76	200.0
2011-09-07 06:00:00	IWM	ETF	68.73	69.17	68.71	69.17	5000.0
2011-09-07 07:00:00	IWM	ETF	69.05	69.13	68.95	68.95	70577.0
2011-09-07 08:00:00	IWM	ETF	68.98	69.31	68.9	69.27	612434.0
2011-09-07 09:00:00	IWM	ETF	69.26	69.61	69.07	69.58	11707720.0
2011-09-07 10:00:00	IWM	ETF	69.58	70.04	69.52	69.669	9144410.0
2011-09-07 11:00:00	IWM	ETF	69.67	70.11	69.61	70.01	5307111.0
2011-09-07 12:00:00	IWM	ETF	70.01	70.39	69.93	70.33	3195227.0
2011-09-07 13:00:00	IWM	ETF	70.33	70.64	70.3	70.48	4091356.0
2011-09-07 14:00:00	IWM	ETF	70.47	70.88	70.431	70.86	5811078.0
2011-09-07 15:00:00	IWM	ETF	70.86	70.95	70.46	70.87	13343054.0
2011-09-07 16:00:00	IWM	ETF	70.87	71.08	68.1279	70.99	4009000.0
2011-09-07 17:00:00	IWM	ETF	70.96	71.04	70.96	71.01	16600.0
2011-09-07 18:00:00	IWM	ETF	71.03	71.47	71.0	71.18	4798.0
2011-09-07 19:00:00	IWM	ETF	71.04	71.22	71.04	71.11	2040.0
2011-09-07 07:00:00	DIA	ETF	112.5	113.07	112.15	112.15	1400.0
2011-09-07 08:00:00	DIA	ETF	112.15	112.55	112.15	112.55	43290.0

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

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