PREVIEW / etf_1hour / 2013-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-16.parquet
  size:    215 KB
  rows:    6,780

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-09-16 04:00:00	SPY	ETF	171.0	171.4	170.66	171.25	111495.0
2013-09-16 05:00:00	SPY	ETF	171.26	171.31	171.13	171.19	7407.0
2013-09-16 06:00:00	SPY	ETF	171.21	171.34	171.2	171.22	158563.0
2013-09-16 07:00:00	SPY	ETF	171.22	171.22	171.09	171.17	328704.0
2013-09-16 08:00:00	SPY	ETF	171.17	171.61	170.97	171.01	1367787.0
2013-09-16 09:00:00	SPY	ETF	171.0	171.24	170.57	170.68	18011285.0
2013-09-16 10:00:00	SPY	ETF	170.68	170.88	170.4	170.65	16770152.0
2013-09-16 11:00:00	SPY	ETF	170.65	170.945	170.58	170.91	8750132.0
2013-09-16 12:00:00	SPY	ETF	170.91	171.06	170.72	170.73	8937038.0
2013-09-16 13:00:00	SPY	ETF	170.73	170.82	170.22	170.53	15373462.0
2013-09-16 14:00:00	SPY	ETF	170.52	170.56	170.15	170.22	9795245.0
2013-09-16 15:00:00	SPY	ETF	170.22	170.48	170.04	170.31	19084655.0
2013-09-16 16:00:00	SPY	ETF	170.32	170.89	169.3357	170.35	19658907.0
2013-09-16 17:00:00	SPY	ETF	170.34	170.5538	170.17	170.19	462665.0
2013-09-16 18:00:00	SPY	ETF	170.18	170.31	170.18	170.3	42386.0
2013-09-16 19:00:00	SPY	ETF	170.29	170.31	170.15	170.18	32864.0
2013-09-16 04:00:00	QQQ	ETF	78.55	78.9	78.16	78.83	69965.0
2013-09-16 05:00:00	QQQ	ETF	78.82	78.82	78.82	78.82	600.0
2013-09-16 06:00:00	QQQ	ETF	78.83	78.83	78.78	78.8	4600.0
2013-09-16 07:00:00	QQQ	ETF	78.81	78.81	78.77	78.8	29965.0
2013-09-16 08:00:00	QQQ	ETF	78.78	78.81	78.57	78.6	336190.0
2013-09-16 09:00:00	QQQ	ETF	78.62	78.72	78.27	78.32	4545751.0
2013-09-16 10:00:00	QQQ	ETF	78.31	78.36	78.1	78.17	5081788.0
2013-09-16 11:00:00	QQQ	ETF	78.17	78.3	78.11	78.24	2060649.0
2013-09-16 12:00:00	QQQ	ETF	78.24	78.265	78.02	78.03	1985104.0
2013-09-16 13:00:00	QQQ	ETF	78.03	78.16	77.82	77.96	2562212.0
2013-09-16 14:00:00	QQQ	ETF	77.97	78.0	77.73	77.77	3047578.0
2013-09-16 15:00:00	QQQ	ETF	77.7628	77.88	77.67	77.84	3725595.0
2013-09-16 16:00:00	QQQ	ETF	77.84	78.5914	77.76	77.82	935958.0
2013-09-16 17:00:00	QQQ	ETF	77.79	78.0365	77.75	77.75	113381.0
2013-09-16 18:00:00	QQQ	ETF	77.79	77.79	77.75	77.76	12981.0
2013-09-16 19:00:00	QQQ	ETF	77.77	77.77	77.68	77.68	5316.0
2013-09-16 04:00:00	IWM	ETF	105.8	106.33	105.8	106.33	828.0
2013-09-16 06:00:00	IWM	ETF	106.24	106.24	106.1	106.1	2100.0
2013-09-16 07:00:00	IWM	ETF	106.1	106.12	106.08	106.08	37250.0
2013-09-16 08:00:00	IWM	ETF	106.08	106.13	105.73	105.97	320026.0
2013-09-16 09:00:00	IWM	ETF	105.97	106.08	105.47	105.56	4183614.0
2013-09-16 10:00:00	IWM	ETF	105.565	105.76	105.27	105.33	5234797.0
2013-09-16 11:00:00	IWM	ETF	105.325	105.58	105.26	105.57	2510018.0
2013-09-16 12:00:00	IWM	ETF	105.58	105.6199	105.4	105.4045	1984658.0
2013-09-16 13:00:00	IWM	ETF	105.4	105.48	105.025	105.22	2213361.0
2013-09-16 14:00:00	IWM	ETF	105.22	105.255	104.96	105.04	2294019.0
2013-09-16 15:00:00	IWM	ETF	105.03	105.18	104.85	104.97	5226292.0
2013-09-16 16:00:00	IWM	ETF	104.97	105.15	104.88	105.01	1274410.0
2013-09-16 17:00:00	IWM	ETF	104.96	105.3601	104.8004	104.88	2473368.0
2013-09-16 18:00:00	IWM	ETF	104.88	104.92	104.88	104.88	685.0
2013-09-16 19:00:00	IWM	ETF	104.87	104.89	104.87	104.89	1700.0
2013-09-16 04:00:00	DIA	ETF	155.37	155.51	155.37	155.51	9500.0
2013-09-16 06:00:00	DIA	ETF	155.4	155.4	155.33	155.33	2200.0
2013-09-16 07:00:00	DIA	ETF	155.22	155.32	155.22	155.3	5367.0

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

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