PREVIEW / etf_1hour / 2012-10-03

all etf 1-hour files

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

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-03 04:00:00	SPY	ETF	144.19	144.69	144.19	144.55	2536.0
2012-10-03 05:00:00	SPY	ETF	144.63	144.82	144.61	144.76	1490.0
2012-10-03 06:00:00	SPY	ETF	144.74	144.8	144.57	144.57	12933.0
2012-10-03 07:00:00	SPY	ETF	144.62	144.73	144.55	144.67	485855.0
2012-10-03 08:00:00	SPY	ETF	144.68	144.96	144.625	144.85	1869268.0
2012-10-03 09:00:00	SPY	ETF	144.87	144.93	144.32	144.4299	11928805.0
2012-10-03 10:00:00	SPY	ETF	144.43	144.95	144.13	144.68	22330410.0
2012-10-03 11:00:00	SPY	ETF	144.67	145.34	144.65	145.259	18141515.0
2012-10-03 12:00:00	SPY	ETF	145.259	145.43	145.18	145.3	8141158.0
2012-10-03 13:00:00	SPY	ETF	145.3	145.32	144.81	144.94	9619961.0
2012-10-03 14:00:00	SPY	ETF	144.93	145.05	144.74	144.86	12232614.0
2012-10-03 15:00:00	SPY	ETF	144.859	145.16	144.68	145.09	23040883.0
2012-10-03 16:00:00	SPY	ETF	145.09	145.15	144.5569	145.09	6661829.0
2012-10-03 17:00:00	SPY	ETF	145.1	145.26	145.07	145.18	632275.0
2012-10-03 18:00:00	SPY	ETF	145.19	145.47	145.19	145.38	190340.0
2012-10-03 19:00:00	SPY	ETF	145.39	145.39	145.24	145.31	83062.0
2012-10-03 04:00:00	QQQ	ETF	68.7	68.7	68.7	68.7	200.0
2012-10-03 05:00:00	QQQ	ETF	68.77	68.81	68.77	68.81	200.0
2012-10-03 06:00:00	QQQ	ETF	68.8	68.8	68.73	68.75	30000.0
2012-10-03 07:00:00	QQQ	ETF	68.77	68.82	68.71	68.82	511313.0
2012-10-03 08:00:00	QQQ	ETF	68.83	68.95	68.76	68.87	1530875.0
2012-10-03 09:00:00	QQQ	ETF	68.88	68.97	68.69	68.76	3022599.0
2012-10-03 10:00:00	QQQ	ETF	68.76	69.02	68.59	68.85	4833516.0
2012-10-03 11:00:00	QQQ	ETF	68.85	69.2	68.84	69.15	5715489.0
2012-10-03 12:00:00	QQQ	ETF	69.15	69.24	69.09	69.16	3403125.0
2012-10-03 13:00:00	QQQ	ETF	69.16	69.1683	68.87	68.925	3613281.0
2012-10-03 14:00:00	QQQ	ETF	68.92	69.02	68.85	68.93	4001260.0
2012-10-03 15:00:00	QQQ	ETF	68.94	69.16	68.86	69.12	5934107.0
2012-10-03 16:00:00	QQQ	ETF	69.11	69.12	68.654	69.06	1693736.0
2012-10-03 17:00:00	QQQ	ETF	69.07	69.13	69.07	69.13	7022.0
2012-10-03 18:00:00	QQQ	ETF	69.14	69.26	69.14	69.23	5733.0
2012-10-03 19:00:00	QQQ	ETF	69.21	69.21	69.17	69.18	8995.0
2012-10-03 07:00:00	IWM	ETF	83.75	83.82	83.73	83.81	10000.0
2012-10-03 08:00:00	IWM	ETF	83.79	84.0	83.77	83.93	610864.0
2012-10-03 09:00:00	IWM	ETF	83.89	83.97	83.35	83.42	4604967.0
2012-10-03 10:00:00	IWM	ETF	83.42	83.85	83.17	83.67	7923991.0
2012-10-03 11:00:00	IWM	ETF	83.67	84.16	83.65	84.11	4166642.0
2012-10-03 12:00:00	IWM	ETF	84.12	84.22	84.04	84.13	2304975.0
2012-10-03 13:00:00	IWM	ETF	84.122	84.16	83.64	83.72	3049618.0
2012-10-03 14:00:00	IWM	ETF	83.72	83.81	83.46	83.5299	4070178.0
2012-10-03 15:00:00	IWM	ETF	83.53	83.6899	83.35	83.62	5823112.0
2012-10-03 16:00:00	IWM	ETF	83.63	83.6837	83.51	83.63	1201281.0
2012-10-03 17:00:00	IWM	ETF	83.63	83.67	83.63	83.67	1200.0
2012-10-03 18:00:00	IWM	ETF	83.79	83.85	83.79	83.79	1000.0
2012-10-03 19:00:00	IWM	ETF	83.75	83.8	83.75	83.8	1500.0
2012-10-03 06:00:00	DIA	ETF	134.6	134.6	134.6	134.6	143.0
2012-10-03 07:00:00	DIA	ETF	134.53	134.53	134.53	134.53	100.0
2012-10-03 08:00:00	DIA	ETF	134.59	134.75	134.59	134.71	11757.0
2012-10-03 09:00:00	DIA	ETF	134.74	134.78	134.22	134.3941	352425.0
2012-10-03 10:00:00	DIA	ETF	134.39	134.795	134.1	134.62	626070.0

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

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