PREVIEW / etf_1hour / 2012-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-04.parquet
  size:    183 KB
  rows:    5,691

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
2012-10-04 04:00:00	SPY	ETF	145.77	145.77	145.37	145.37	37080.0
2012-10-04 05:00:00	SPY	ETF	145.38	145.5	145.37	145.5	6200.0
2012-10-04 06:00:00	SPY	ETF	145.5	145.76	145.5	145.74	51865.0
2012-10-04 07:00:00	SPY	ETF	145.66	145.73	145.52	145.67	245576.0
2012-10-04 08:00:00	SPY	ETF	145.67	145.94	145.0826	145.71	2076309.0
2012-10-04 09:00:00	SPY	ETF	145.7	145.86	145.44	145.66	11693403.0
2012-10-04 10:00:00	SPY	ETF	145.65	146.34	145.53	146.101	21822745.0
2012-10-04 11:00:00	SPY	ETF	146.1	146.16	145.64	145.83	18102356.0
2012-10-04 12:00:00	SPY	ETF	145.83	146.12	145.7917	145.92	10287884.0
2012-10-04 13:00:00	SPY	ETF	145.925	146.24	145.696	146.16	9693472.0
2012-10-04 14:00:00	SPY	ETF	146.17	146.19	145.9	146.11	18552876.0
2012-10-04 15:00:00	SPY	ETF	146.11	146.25	145.95	146.2	21130434.0
2012-10-04 16:00:00	SPY	ETF	146.21	146.27	145.0826	146.18	7001623.0
2012-10-04 17:00:00	SPY	ETF	146.19	146.24	146.15	146.21	106640.0
2012-10-04 18:00:00	SPY	ETF	146.2	146.24	146.18	146.22	36745.0
2012-10-04 19:00:00	SPY	ETF	146.22	146.24	146.2	146.22	31187.0
2012-10-04 04:00:00	QQQ	ETF	69.16	69.16	69.15	69.15	10000.0
2012-10-04 06:00:00	QQQ	ETF	69.31	69.37	69.31	69.37	15050.0
2012-10-04 07:00:00	QQQ	ETF	69.31	69.37	69.3	69.33	68500.0
2012-10-04 08:00:00	QQQ	ETF	69.34	69.4	69.21	69.3	733518.0
2012-10-04 09:00:00	QQQ	ETF	69.27	69.34	69.0	69.13	3824183.0
2012-10-04 10:00:00	QQQ	ETF	69.13	69.46	69.06	69.3384	4600165.0
2012-10-04 11:00:00	QQQ	ETF	69.34	69.36	69.06	69.21	2764898.0
2012-10-04 12:00:00	QQQ	ETF	69.21	69.35	69.16	69.22	1707554.0
2012-10-04 13:00:00	QQQ	ETF	69.23	69.35	69.21	69.3301	1326439.0
2012-10-04 14:00:00	QQQ	ETF	69.33	69.4299	69.19	69.37	2261544.0
2012-10-04 15:00:00	QQQ	ETF	69.37	69.54	69.3	69.36	3997690.0
2012-10-04 16:00:00	QQQ	ETF	69.35	69.3997	69.1226	69.35	2525429.0
2012-10-04 17:00:00	QQQ	ETF	69.37	69.4	69.36	69.38	40912.0
2012-10-04 18:00:00	QQQ	ETF	69.37	69.4	69.36	69.37	33483.0
2012-10-04 19:00:00	QQQ	ETF	69.38	69.39	69.38	69.38	8058.0
2012-10-04 05:00:00	IWM	ETF	83.8	83.85	83.8	83.85	9700.0
2012-10-04 07:00:00	IWM	ETF	83.95	84.0	83.9	84.0	101657.0
2012-10-04 08:00:00	IWM	ETF	83.98	84.1	83.88	84.0	234343.0
2012-10-04 09:00:00	IWM	ETF	84.03	84.1	83.56	83.68	3227204.0
2012-10-04 10:00:00	IWM	ETF	83.68	84.17	83.57	83.71	10547200.0
2012-10-04 11:00:00	IWM	ETF	83.71	83.77	83.2	83.4801	8420626.0
2012-10-04 12:00:00	IWM	ETF	83.49	83.86	83.45	83.72	3647034.0
2012-10-04 13:00:00	IWM	ETF	83.73	84.22	83.72	84.191	3780790.0
2012-10-04 14:00:00	IWM	ETF	84.19	84.26	83.84	84.06	3571634.0
2012-10-04 15:00:00	IWM	ETF	84.06	84.22	83.99	84.21	4838460.0
2012-10-04 16:00:00	IWM	ETF	84.22	84.35	83.629	84.18	1171777.0
2012-10-04 17:00:00	IWM	ETF	84.22	84.24	84.18	84.24	3584.0
2012-10-04 19:00:00	IWM	ETF	84.2	84.2	84.18	84.18	300.0
2012-10-04 08:00:00	DIA	ETF	135.2	135.37	135.1	135.19	63724.0
2012-10-04 09:00:00	DIA	ETF	135.25	135.32	134.955	135.1	448742.0
2012-10-04 10:00:00	DIA	ETF	135.09	135.71	135.0	135.59	863780.0
2012-10-04 11:00:00	DIA	ETF	135.5955	135.64	135.25	135.37	568093.0
2012-10-04 12:00:00	DIA	ETF	135.35	135.65	135.315	135.41	424147.0
2012-10-04 13:00:00	DIA	ETF	135.41	135.69	135.405	135.59	341436.0

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

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