PREVIEW / etf_1hour / 2011-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-05.parquet
  size:    184 KB
  rows:    5,647

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-12-05 04:00:00	SPY	ETF	125.72	126.37	125.72	126.37	32316.0
2011-12-05 05:00:00	SPY	ETF	126.26	126.3	126.2	126.26	86306.0
2011-12-05 06:00:00	SPY	ETF	126.2	126.24	125.95	126.12	206340.0
2011-12-05 07:00:00	SPY	ETF	126.1	126.58	126.06	126.47	1568697.0
2011-12-05 08:00:00	SPY	ETF	126.43	126.75	125.75	126.69	3214011.0
2011-12-05 09:00:00	SPY	ETF	126.7	126.89	126.41	126.86	26199823.0
2011-12-05 10:00:00	SPY	ETF	126.85	127.15	126.54	126.881	35855812.0
2011-12-05 11:00:00	SPY	ETF	126.88	127.0	126.72	126.81	16700200.0
2011-12-05 12:00:00	SPY	ETF	126.81	127.18	126.76	127.0589	13724311.0
2011-12-05 13:00:00	SPY	ETF	127.05	127.1	126.17	126.29	28397690.0
2011-12-05 14:00:00	SPY	ETF	126.3	126.34	125.86	126.28	23886260.0
2011-12-05 15:00:00	SPY	ETF	126.27	126.4	125.44	126.21	53655018.0
2011-12-05 16:00:00	SPY	ETF	126.21	126.4316	124.9109	125.84	15288980.0
2011-12-05 17:00:00	SPY	ETF	125.82	126.21	125.78	125.95	282617.0
2011-12-05 18:00:00	SPY	ETF	125.91	126.21	125.71	125.8	365458.0
2011-12-05 19:00:00	SPY	ETF	125.79	125.9	125.73	125.86	137088.0
2011-12-05 04:00:00	QQQ	ETF	56.96	57.18	56.96	57.1	6130.0
2011-12-05 05:00:00	QQQ	ETF	57.16	57.16	57.15	57.16	1400.0
2011-12-05 06:00:00	QQQ	ETF	57.15	57.16	57.06	57.1	35800.0
2011-12-05 07:00:00	QQQ	ETF	57.1	57.42	57.1	57.34	250934.0
2011-12-05 08:00:00	QQQ	ETF	57.32	57.44	57.2	57.41	275573.0
2011-12-05 09:00:00	QQQ	ETF	57.42	57.5	57.07	57.29	5809777.0
2011-12-05 10:00:00	QQQ	ETF	57.28	57.62	57.17	57.5	9018816.0
2011-12-05 11:00:00	QQQ	ETF	57.5	57.54	57.4	57.47	2584687.0
2011-12-05 12:00:00	QQQ	ETF	57.48	57.61	57.45	57.565	2041231.0
2011-12-05 13:00:00	QQQ	ETF	57.56	57.59	57.23	57.2775	4969018.0
2011-12-05 14:00:00	QQQ	ETF	57.27	57.29	57.08	57.26	3374868.0
2011-12-05 15:00:00	QQQ	ETF	57.26	57.32	56.915	57.22	8727714.0
2011-12-05 16:00:00	QQQ	ETF	57.22	57.35	57.06	57.16	838587.0
2011-12-05 17:00:00	QQQ	ETF	57.12	57.19	57.11	57.15	34000.0
2011-12-05 18:00:00	QQQ	ETF	57.15	57.15	57.08	57.11	122697.0
2011-12-05 19:00:00	QQQ	ETF	57.11	57.16	57.11	57.14	4676.0
2011-12-05 04:00:00	IWM	ETF	74.17	74.53	74.17	74.53	1242.0
2011-12-05 05:00:00	IWM	ETF	74.51	74.51	74.51	74.51	200.0
2011-12-05 06:00:00	IWM	ETF	74.32	74.32	74.32	74.32	200.0
2011-12-05 07:00:00	IWM	ETF	74.29	74.6	74.29	74.48	66261.0
2011-12-05 08:00:00	IWM	ETF	74.5	74.85	74.42	74.8	618770.0
2011-12-05 09:00:00	IWM	ETF	74.81	75.01	74.44	74.76	4583567.0
2011-12-05 10:00:00	IWM	ETF	74.74	75.09	74.51	74.93	7459586.0
2011-12-05 11:00:00	IWM	ETF	74.93	75.05	74.85	74.9445	2997089.0
2011-12-05 12:00:00	IWM	ETF	74.95	75.39	74.94	75.28	3543238.0
2011-12-05 13:00:00	IWM	ETF	75.285	75.38	74.75	74.8275	6260219.0
2011-12-05 14:00:00	IWM	ETF	74.829	74.829	74.42	74.73	5168608.0
2011-12-05 15:00:00	IWM	ETF	74.73	74.84	74.13	74.75	9351316.0
2011-12-05 16:00:00	IWM	ETF	74.74	74.97	73.5406	74.53	6107823.0
2011-12-05 17:00:00	IWM	ETF	74.53	74.73	74.52	74.65	76231.0
2011-12-05 18:00:00	IWM	ETF	74.65	74.65	74.53	74.53	15079.0
2011-12-05 19:00:00	IWM	ETF	74.58	74.6	74.53	74.55	2929.0
2011-12-05 07:00:00	DIA	ETF	121.37	121.51	121.37	121.4	1680.0
2011-12-05 08:00:00	DIA	ETF	121.21	121.57	121.21	121.52	25521.0

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

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