PREVIEW / etf_1hour / 2013-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-02.parquet
  size:    199 KB
  rows:    6,219

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
2013-04-02 04:00:00	SPY	ETF	156.05	156.54	156.05	156.54	12760.0
2013-04-02 05:00:00	SPY	ETF	156.49	156.68	156.49	156.68	28850.0
2013-04-02 06:00:00	SPY	ETF	156.65	156.76	156.64	156.7	94500.0
2013-04-02 07:00:00	SPY	ETF	156.67	156.71	156.64	156.67	245125.0
2013-04-02 08:00:00	SPY	ETF	156.69	156.79	156.56	156.64	1432992.0
2013-04-02 09:00:00	SPY	ETF	156.64	156.95	156.05	156.86	13812800.0
2013-04-02 10:00:00	SPY	ETF	156.86	157.17	156.79	157.129	17305256.0
2013-04-02 11:00:00	SPY	ETF	157.125	157.21	156.98	157.05	10178207.0
2013-04-02 12:00:00	SPY	ETF	157.05	157.17	157.01	157.12	4723484.0
2013-04-02 13:00:00	SPY	ETF	157.125	157.15	156.91	157.03	9090055.0
2013-04-02 14:00:00	SPY	ETF	157.035	157.08	156.65	156.78	12857026.0
2013-04-02 15:00:00	SPY	ETF	156.78	156.9789	156.37	156.8	22933070.0
2013-04-02 16:00:00	SPY	ETF	156.79	156.95	156.73	156.93	6161653.0
2013-04-02 17:00:00	SPY	ETF	156.93	157.01	156.92	156.99	208734.0
2013-04-02 18:00:00	SPY	ETF	156.98	156.99	156.91	156.98	60560.0
2013-04-02 19:00:00	SPY	ETF	156.98	157.02	156.96	156.97	64078.0
2013-04-02 04:00:00	QQQ	ETF	68.6	68.74	68.6	68.74	1700.0
2013-04-02 05:00:00	QQQ	ETF	68.73	68.73	68.73	68.73	600.0
2013-04-02 06:00:00	QQQ	ETF	68.85	68.88	68.83	68.83	1400.0
2013-04-02 07:00:00	QQQ	ETF	68.83	68.88	68.83	68.88	13600.0
2013-04-02 08:00:00	QQQ	ETF	68.86	68.89	68.77	68.8	938779.0
2013-04-02 09:00:00	QQQ	ETF	68.82	69.11	68.77	69.06	5171942.0
2013-04-02 10:00:00	QQQ	ETF	69.07	69.24	69.02	69.18	4432567.0
2013-04-02 11:00:00	QQQ	ETF	69.19	69.27	69.1201	69.165	2180289.0
2013-04-02 12:00:00	QQQ	ETF	69.17	69.265	69.15	69.238	1035679.0
2013-04-02 13:00:00	QQQ	ETF	69.24	69.2499	69.12	69.15	1805730.0
2013-04-02 14:00:00	QQQ	ETF	69.15	69.19	68.89	68.99	4244454.0
2013-04-02 15:00:00	QQQ	ETF	68.99	69.06	68.84	69.03	4616817.0
2013-04-02 16:00:00	QQQ	ETF	69.03	69.08	68.4886	69.05	3527374.0
2013-04-02 17:00:00	QQQ	ETF	69.07	69.07	69.07	69.07	21200.0
2013-04-02 18:00:00	QQQ	ETF	69.08	69.09	69.07	69.07	4623.0
2013-04-02 19:00:00	QQQ	ETF	69.09	69.1	69.08	69.08	28175.0
2013-04-02 04:00:00	IWM	ETF	93.47	93.47	93.47	93.47	269.0
2013-04-02 05:00:00	IWM	ETF	93.47	93.52	93.47	93.52	500.0
2013-04-02 06:00:00	IWM	ETF	93.6	93.74	93.6	93.74	750.0
2013-04-02 07:00:00	IWM	ETF	93.71	93.79	93.71	93.73	45325.0
2013-04-02 08:00:00	IWM	ETF	93.73	93.8	93.62	93.73	359625.0
2013-04-02 09:00:00	IWM	ETF	93.73	93.92	93.12	93.56	7839631.0
2013-04-02 10:00:00	IWM	ETF	93.57	93.819	93.26	93.709	6679891.0
2013-04-02 11:00:00	IWM	ETF	93.71	93.73	93.25	93.3	4925252.0
2013-04-02 12:00:00	IWM	ETF	93.3	93.5	93.3	93.38	2053221.0
2013-04-02 13:00:00	IWM	ETF	93.38	93.411	93.23	93.33	2366306.0
2013-04-02 14:00:00	IWM	ETF	93.32	93.35	92.8124	92.95	6867855.0
2013-04-02 15:00:00	IWM	ETF	92.94	92.99	92.5	92.72	9332281.0
2013-04-02 16:00:00	IWM	ETF	92.71	93.2799	92.58	92.83	2122356.0
2013-04-02 17:00:00	IWM	ETF	92.85	92.9	92.82	92.84	69666.0
2013-04-02 18:00:00	IWM	ETF	92.86	92.9	92.81	92.82	13450.0
2013-04-02 19:00:00	IWM	ETF	92.85	92.9	92.84	92.9	10460.0
2013-04-02 04:00:00	DIA	ETF	145.65	145.65	145.65	145.65	100.0
2013-04-02 05:00:00	DIA	ETF	145.8	145.88	145.8	145.88	200.0

> showing 50 of 6,219 rows — these rows as CSV

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