PREVIEW / etf_1hour / 2013-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-02.parquet
  size:    205 KB
  rows:    6,361

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-08-02 04:00:00	SPY	ETF	170.64	170.65	170.59	170.65	4570.0
2013-08-02 05:00:00	SPY	ETF	170.61	170.61	170.54	170.54	9700.0
2013-08-02 06:00:00	SPY	ETF	170.59	170.72	170.59	170.63	15150.0
2013-08-02 07:00:00	SPY	ETF	170.62	170.72	170.58	170.67	78600.0
2013-08-02 08:00:00	SPY	ETF	170.62	170.91	170.07	170.28	3186061.0
2013-08-02 09:00:00	SPY	ETF	170.28	170.6886	170.05	170.22	14343807.0
2013-08-02 10:00:00	SPY	ETF	170.22	170.53	170.12	170.24	14127400.0
2013-08-02 11:00:00	SPY	ETF	170.25	170.51	170.12	170.44	9065337.0
2013-08-02 12:00:00	SPY	ETF	170.45	170.68	170.425	170.63	6159604.0
2013-08-02 13:00:00	SPY	ETF	170.63	170.73	170.48	170.525	5758150.0
2013-08-02 14:00:00	SPY	ETF	170.523	170.695	170.44	170.62	5471273.0
2013-08-02 15:00:00	SPY	ETF	170.62	170.96	170.58	170.93	17050746.0
2013-08-02 16:00:00	SPY	ETF	170.92	170.9736	170.513	170.82	8609967.0
2013-08-02 17:00:00	SPY	ETF	170.82	170.88	170.72	170.8	106738.0
2013-08-02 18:00:00	SPY	ETF	170.82	170.99	170.81	170.87	35590.0
2013-08-02 19:00:00	SPY	ETF	170.9	170.9	170.85	170.89	7916.0
2013-08-02 05:00:00	QQQ	ETF	76.51	76.53	76.51	76.53	1600.0
2013-08-02 06:00:00	QQQ	ETF	76.55	76.59	76.55	76.57	2500.0
2013-08-02 07:00:00	QQQ	ETF	76.59	76.6	76.57	76.59	29261.0
2013-08-02 08:00:00	QQQ	ETF	76.57	76.76	76.47	76.58	2274197.0
2013-08-02 09:00:00	QQQ	ETF	76.57	76.64	76.3801	76.47	2434539.0
2013-08-02 10:00:00	QQQ	ETF	76.46	76.7	76.43	76.52	2318036.0
2013-08-02 11:00:00	QQQ	ETF	76.53	76.66	76.48	76.63	1366175.0
2013-08-02 12:00:00	QQQ	ETF	76.631	76.74	76.62	76.74	1156859.0
2013-08-02 13:00:00	QQQ	ETF	76.735	76.83	76.68	76.7499	1226838.0
2013-08-02 14:00:00	QQQ	ETF	76.7463	76.8201	76.72	76.81	1239197.0
2013-08-02 15:00:00	QQQ	ETF	76.809	76.99	76.79	76.98	3779340.0
2013-08-02 16:00:00	QQQ	ETF	76.99	77.02	76.5493	76.98	2060687.0
2013-08-02 17:00:00	QQQ	ETF	76.98	76.98	76.94	76.95	17190.0
2013-08-02 18:00:00	QQQ	ETF	76.95	76.98	76.95	76.96	3600.0
2013-08-02 19:00:00	QQQ	ETF	76.98	77.01	76.95	76.99	5000.0
2013-08-02 04:00:00	IWM	ETF	105.15	105.15	105.15	105.15	500.0
2013-08-02 05:00:00	IWM	ETF	105.07	105.07	105.07	105.07	500.0
2013-08-02 07:00:00	IWM	ETF	105.1	105.1	105.07	105.09	21225.0
2013-08-02 08:00:00	IWM	ETF	105.1	105.5	104.6	104.77	559585.0
2013-08-02 09:00:00	IWM	ETF	104.78	104.98	104.56	104.91	4541845.0
2013-08-02 10:00:00	IWM	ETF	104.89	105.16	104.81	104.835	3351147.0
2013-08-02 11:00:00	IWM	ETF	104.84	105.0301	104.74	104.95	2737032.0
2013-08-02 12:00:00	IWM	ETF	104.94	105.14	104.93	105.095	1836874.0
2013-08-02 13:00:00	IWM	ETF	105.095	105.25	104.98	105.02	1703743.0
2013-08-02 14:00:00	IWM	ETF	105.01	105.23	105.01	105.17	2140465.0
2013-08-02 15:00:00	IWM	ETF	105.17	105.28	105.11	105.19	3520543.0
2013-08-02 16:00:00	IWM	ETF	105.19	105.24	105.1	105.15	1242940.0
2013-08-02 17:00:00	IWM	ETF	105.13	105.13	105.06	105.06	7800.0
2013-08-02 19:00:00	IWM	ETF	105.2	105.2	105.2	105.2	100.0
2013-08-02 07:00:00	DIA	ETF	155.94	155.95	155.94	155.94	4065.0
2013-08-02 08:00:00	DIA	ETF	155.95	156.0	155.51	155.57	32910.0
2013-08-02 09:00:00	DIA	ETF	155.52	155.67	155.23	155.4	530414.0
2013-08-02 10:00:00	DIA	ETF	155.39	155.7	155.35	155.369	571528.0
2013-08-02 11:00:00	DIA	ETF	155.379	155.71	155.29	155.69	511698.0

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

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