PREVIEW / etf_1hour / 2011-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-17.parquet
  size:    179 KB
  rows:    5,540

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-17 04:00:00	SPY	ETF	126.71	126.71	126.35	126.42	5580.0
2011-06-17 05:00:00	SPY	ETF	126.49	127.24	126.47	127.24	15297.0
2011-06-17 06:00:00	SPY	ETF	127.15	127.84	126.98	127.73	78120.0
2011-06-17 07:00:00	SPY	ETF	127.76	128.19	127.75	128.07	1027744.0
2011-06-17 08:00:00	SPY	ETF	127.92	128.15	127.8	128.03	3330000.0
2011-06-17 09:00:00	SPY	ETF	128.02	128.02	127.42	127.64	28950206.0
2011-06-17 10:00:00	SPY	ETF	127.64	127.94	127.18	127.57	38410122.0
2011-06-17 11:00:00	SPY	ETF	127.58	127.68	127.29	127.561	29043872.0
2011-06-17 12:00:00	SPY	ETF	127.57	127.6	126.95	127.08	20133391.0
2011-06-17 13:00:00	SPY	ETF	127.09	127.19	126.8	126.97	18440844.0
2011-06-17 14:00:00	SPY	ETF	126.97	127.46	126.9499	127.19	20699865.0
2011-06-17 15:00:00	SPY	ETF	127.2	127.34	126.62	127.05	50680632.0
2011-06-17 16:00:00	SPY	ETF	127.06	127.5	126.6688	127.0	17132417.0
2011-06-17 17:00:00	SPY	ETF	127.0	127.02	126.95	126.96	302242.0
2011-06-17 18:00:00	SPY	ETF	126.96	127.05	126.93	127.0	1629701.0
2011-06-17 19:00:00	SPY	ETF	126.95	127.22	126.95	127.14	135390.0
2011-06-17 04:00:00	QQQ	ETF	53.85	53.85	53.85	53.85	200.0
2011-06-17 06:00:00	QQQ	ETF	54.22	54.3	54.22	54.28	1090.0
2011-06-17 07:00:00	QQQ	ETF	54.32	54.44	54.28	54.39	106065.0
2011-06-17 08:00:00	QQQ	ETF	54.38	54.41	54.29	54.38	1122328.0
2011-06-17 09:00:00	QQQ	ETF	54.38	54.52	54.18	54.2	10945485.0
2011-06-17 10:00:00	QQQ	ETF	54.2	54.329	53.975	54.07	11660317.0
2011-06-17 11:00:00	QQQ	ETF	54.07	54.14	53.94	54.06	6798485.0
2011-06-17 12:00:00	QQQ	ETF	54.06	54.08	53.795	53.859	6045078.0
2011-06-17 13:00:00	QQQ	ETF	53.86	53.94	53.73	53.82	4898468.0
2011-06-17 14:00:00	QQQ	ETF	53.82	54.0	53.8	53.885	4592194.0
2011-06-17 15:00:00	QQQ	ETF	53.885	53.915	53.631	53.79	10330686.0
2011-06-17 16:00:00	QQQ	ETF	53.8	53.91	53.77	53.85	2848109.0
2011-06-17 17:00:00	QQQ	ETF	53.85	53.92	53.82	53.82	18045.0
2011-06-17 18:00:00	QQQ	ETF	53.82	53.88	53.81	53.87	22462.0
2011-06-17 19:00:00	QQQ	ETF	53.88	53.89	53.84	53.85	6376.0
2011-06-17 04:00:00	IWM	ETF	78.09	78.09	78.01	78.01	391.0
2011-06-17 05:00:00	IWM	ETF	78.22	78.53	78.22	78.53	700.0
2011-06-17 06:00:00	IWM	ETF	78.47	79.1	78.47	79.09	89950.0
2011-06-17 07:00:00	IWM	ETF	79.01	79.29	78.98	79.26	222213.0
2011-06-17 08:00:00	IWM	ETF	79.03	79.24	79.0	79.07	805592.0
2011-06-17 09:00:00	IWM	ETF	79.06	79.07	78.54	78.63	10101642.0
2011-06-17 10:00:00	IWM	ETF	78.63	79.1271	78.55	78.8	11567591.0
2011-06-17 11:00:00	IWM	ETF	78.8	79.03	78.6	78.98	6080224.0
2011-06-17 12:00:00	IWM	ETF	78.98	79.01	78.26	78.43	7221203.0
2011-06-17 13:00:00	IWM	ETF	78.43	78.47	78.06	78.16	6952648.0
2011-06-17 14:00:00	IWM	ETF	78.16	78.57	78.08	78.3	6333276.0
2011-06-17 15:00:00	IWM	ETF	78.31	78.38	77.83	78.22	14893664.0
2011-06-17 16:00:00	IWM	ETF	78.22	78.31	78.07	78.23	3072275.0
2011-06-17 17:00:00	IWM	ETF	78.27	78.28	78.16	78.24	363308.0
2011-06-17 18:00:00	IWM	ETF	78.24	78.24	78.24	78.24	882.0
2011-06-17 19:00:00	IWM	ETF	78.25	78.32	78.23	78.32	3199.0
2011-06-17 05:00:00	DIA	ETF	119.68	119.68	119.68	119.68	450.0
2011-06-17 06:00:00	DIA	ETF	119.92	119.92	119.92	119.92	100.0
2011-06-17 07:00:00	DIA	ETF	120.28	120.49	120.14	120.48	11240.0

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

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