PREVIEW / etf_1hour / 2012-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-17.parquet
  size:    185 KB
  rows:    5,738

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-17 04:00:00	SPY	ETF	145.27	145.49	145.27	145.47	23215.0
2012-10-17 05:00:00	SPY	ETF	145.45	145.61	145.45	145.61	15700.0
2012-10-17 06:00:00	SPY	ETF	145.57	145.7	145.54	145.67	95628.0
2012-10-17 07:00:00	SPY	ETF	145.7	145.85	145.63	145.75	278540.0
2012-10-17 08:00:00	SPY	ETF	145.74	146.0	145.61	145.88	1564494.0
2012-10-17 09:00:00	SPY	ETF	145.86	145.95	145.42	145.88	15029578.0
2012-10-17 10:00:00	SPY	ETF	145.88	146.22	145.85	146.055	19967938.0
2012-10-17 11:00:00	SPY	ETF	146.06	146.16	145.88	146.11	8879658.0
2012-10-17 12:00:00	SPY	ETF	146.11	146.32	146.1	146.195	8008606.0
2012-10-17 13:00:00	SPY	ETF	146.19	146.26	145.7	145.86	12160669.0
2012-10-17 14:00:00	SPY	ETF	145.86	146.19	145.83	146.16	12373731.0
2012-10-17 15:00:00	SPY	ETF	146.16	146.32	146.1	146.19	22980890.0
2012-10-17 16:00:00	SPY	ETF	146.17	146.38	145.5801	146.26	15761101.0
2012-10-17 17:00:00	SPY	ETF	146.26	146.31	146.22	146.25	198314.0
2012-10-17 18:00:00	SPY	ETF	146.25	146.25	146.19	146.19	53865.0
2012-10-17 19:00:00	SPY	ETF	146.21	146.24	146.18	146.22	22873.0
2012-10-17 05:00:00	QQQ	ETF	67.95	67.95	67.95	67.95	500.0
2012-10-17 06:00:00	QQQ	ETF	67.97	67.98	67.91	67.95	216648.0
2012-10-17 07:00:00	QQQ	ETF	67.95	67.99	67.83	67.84	537821.0
2012-10-17 08:00:00	QQQ	ETF	67.86	67.9	67.8	67.87	409382.0
2012-10-17 09:00:00	QQQ	ETF	67.88	68.12	67.68	68.075	6670908.0
2012-10-17 10:00:00	QQQ	ETF	68.08	68.29	68.05	68.12	9248190.0
2012-10-17 11:00:00	QQQ	ETF	68.12	68.27	68.03	68.22	2765960.0
2012-10-17 12:00:00	QQQ	ETF	68.2101	68.3	68.205	68.23	1845399.0
2012-10-17 13:00:00	QQQ	ETF	68.24	68.26	67.915	67.95	3602648.0
2012-10-17 14:00:00	QQQ	ETF	67.95	68.1	67.93	68.0517	2266801.0
2012-10-17 15:00:00	QQQ	ETF	68.06	68.23	68.02	68.09	3638217.0
2012-10-17 16:00:00	QQQ	ETF	68.08	68.15	68.05	68.14	547316.0
2012-10-17 17:00:00	QQQ	ETF	68.07	68.12	68.07	68.11	4988.0
2012-10-17 18:00:00	QQQ	ETF	68.1	68.14	68.07	68.07	10035.0
2012-10-17 19:00:00	QQQ	ETF	68.1	68.11	68.09	68.11	13650.0
2012-10-17 06:00:00	IWM	ETF	83.3	83.35	83.3	83.35	815.0
2012-10-17 07:00:00	IWM	ETF	83.38	83.47	83.38	83.41	141900.0
2012-10-17 08:00:00	IWM	ETF	83.44	83.6	83.37	83.5	959156.0
2012-10-17 09:00:00	IWM	ETF	83.52	83.725	83.25	83.65	4137833.0
2012-10-17 10:00:00	IWM	ETF	83.65	84.07	83.65	83.92	7789094.0
2012-10-17 11:00:00	IWM	ETF	83.92	83.98	83.78	83.91	1662987.0
2012-10-17 12:00:00	IWM	ETF	83.92	84.15	83.91	83.99	3159729.0
2012-10-17 13:00:00	IWM	ETF	83.99	84.02	83.48	83.52	3670198.0
2012-10-17 14:00:00	IWM	ETF	83.53	83.76	83.44	83.75	1756108.0
2012-10-17 15:00:00	IWM	ETF	83.76	84.03	83.7	84.0	6296824.0
2012-10-17 16:00:00	IWM	ETF	83.99	84.18	83.98	84.14	1769749.0
2012-10-17 17:00:00	IWM	ETF	84.13	84.13	84.09	84.09	1817.0
2012-10-17 18:00:00	IWM	ETF	84.1	84.15	84.1	84.15	3800.0
2012-10-17 04:00:00	DIA	ETF	135.06	135.06	135.06	135.06	100.0
2012-10-17 07:00:00	DIA	ETF	135.16	135.16	135.04	135.04	650.0
2012-10-17 08:00:00	DIA	ETF	135.04	135.24	134.97	135.2	17942.0
2012-10-17 09:00:00	DIA	ETF	135.17	135.28	134.85	135.23	693283.0
2012-10-17 10:00:00	DIA	ETF	135.22	135.4	135.17	135.3266	587394.0
2012-10-17 11:00:00	DIA	ETF	135.33	135.33	135.19	135.3	252455.0

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

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