PREVIEW / etf_1hour / 2015-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-17.parquet
  size:    242 KB
  rows:    7,706

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
2015-02-17 04:00:00	SPY	ETF	209.16	209.16	208.91	208.91	659.0
2015-02-17 05:00:00	SPY	ETF	209.25	209.71	208.91	209.5	3675.0
2015-02-17 06:00:00	SPY	ETF	209.71	209.71	209.51	209.58	14710.0
2015-02-17 07:00:00	SPY	ETF	209.73	209.75	209.59	209.6	69175.0
2015-02-17 08:00:00	SPY	ETF	209.65	209.76	209.34	209.54	622197.0
2015-02-17 09:00:00	SPY	ETF	209.54	209.62	209.1	209.47	10885283.0
2015-02-17 10:00:00	SPY	ETF	209.47	209.69	209.3	209.39	10346337.0
2015-02-17 11:00:00	SPY	ETF	209.39	209.74	209.3	209.7	6584337.0
2015-02-17 12:00:00	SPY	ETF	209.7	209.96	209.61	209.91	6260032.0
2015-02-17 13:00:00	SPY	ETF	209.91	210.32	209.86	210.14	8299144.0
2015-02-17 14:00:00	SPY	ETF	210.14	210.18	209.92	209.96	8164466.0
2015-02-17 15:00:00	SPY	ETF	209.97	210.18	209.8	210.16	14482360.0
2015-02-17 16:00:00	SPY	ETF	210.16	210.24	209.52	210.21	10291743.0
2015-02-17 17:00:00	SPY	ETF	210.22	210.22	210.08	210.14	49314.0
2015-02-17 18:00:00	SPY	ETF	210.13	210.14	210.02	210.14	55201.0
2015-02-17 19:00:00	SPY	ETF	210.1	210.15	210.08	210.11	16606.0
2015-02-17 04:00:00	QQQ	ETF	106.85	106.85	106.63	106.63	400.0
2015-02-17 06:00:00	QQQ	ETF	106.53	106.96	106.53	106.91	3506.0
2015-02-17 07:00:00	QQQ	ETF	106.91	107.01	106.91	106.97	24090.0
2015-02-17 08:00:00	QQQ	ETF	106.98	107.0	106.84	106.92	218836.0
2015-02-17 09:00:00	QQQ	ETF	106.92	106.95	106.6432	106.82	3119536.0
2015-02-17 10:00:00	QQQ	ETF	106.82	107.02	106.701	106.77	2579508.0
2015-02-17 11:00:00	QQQ	ETF	106.77	106.93	106.7	106.8999	1261661.0
2015-02-17 12:00:00	QQQ	ETF	106.9	106.95	106.7751	106.84	1110290.0
2015-02-17 13:00:00	QQQ	ETF	106.835	107.08	106.83	106.92	1935453.0
2015-02-17 14:00:00	QQQ	ETF	106.9234	106.97	106.82	106.88	1070582.0
2015-02-17 15:00:00	QQQ	ETF	106.88	107.02	106.79	107.02	2856750.0
2015-02-17 16:00:00	QQQ	ETF	107.02	107.07	106.8864	107.0	511531.0
2015-02-17 17:00:00	QQQ	ETF	107.0	107.03	107.0	107.03	10297.0
2015-02-17 18:00:00	QQQ	ETF	106.98	107.0	106.95	107.0	1796.0
2015-02-17 19:00:00	QQQ	ETF	107.0	107.0	106.98	106.98	3844.0
2015-02-17 04:00:00	IWM	ETF	121.57	121.57	121.57	121.57	100.0
2015-02-17 06:00:00	IWM	ETF	121.84	121.84	121.84	121.84	200.0
2015-02-17 07:00:00	IWM	ETF	121.73	121.85	121.61	121.85	40000.0
2015-02-17 08:00:00	IWM	ETF	121.86	121.88	121.58	121.69	190723.0
2015-02-17 09:00:00	IWM	ETF	121.72	121.79	121.26	121.6799	2239793.0
2015-02-17 10:00:00	IWM	ETF	121.67	121.9	121.4975	121.589	2245508.0
2015-02-17 11:00:00	IWM	ETF	121.58	121.65	121.42	121.53	1315320.0
2015-02-17 12:00:00	IWM	ETF	121.5372	121.94	121.53	121.9199	1254275.0
2015-02-17 13:00:00	IWM	ETF	121.91	122.06	121.6	121.675	1346055.0
2015-02-17 14:00:00	IWM	ETF	121.67	121.85	121.6238	121.65	1194034.0
2015-02-17 15:00:00	IWM	ETF	121.65	121.88	121.4	121.87	3470389.0
2015-02-17 16:00:00	IWM	ETF	121.88	121.91	121.69	121.83	308166.0
2015-02-17 19:00:00	IWM	ETF	121.75	121.75	121.75	121.75	200.0
2015-02-17 06:00:00	DIA	ETF	180.3	180.3	180.3	180.3	300.0
2015-02-17 07:00:00	DIA	ETF	180.35	180.35	180.19	180.19	508.0
2015-02-17 08:00:00	DIA	ETF	180.24	180.29	180.01	180.15	24850.0
2015-02-17 09:00:00	DIA	ETF	180.2	180.2	179.71	180.07	556459.0
2015-02-17 10:00:00	DIA	ETF	180.06	180.22	179.88	179.91	345362.0
2015-02-17 11:00:00	DIA	ETF	179.91	180.21	179.82	180.14	226650.0

> showing 50 of 7,706 rows — these rows as CSV

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