PREVIEW / etf_1hour / 2015-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-20.parquet
  size:    241 KB
  rows:    7,567

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-20 04:00:00	SPY	ETF	209.86	209.9	209.85	209.85	2200.0
2015-02-20 05:00:00	SPY	ETF	209.88	210.06	209.8	210.06	6810.0
2015-02-20 06:00:00	SPY	ETF	210.04	210.12	210.01	210.08	59926.0
2015-02-20 07:00:00	SPY	ETF	210.18	210.33	209.51	209.58	668934.0
2015-02-20 08:00:00	SPY	ETF	209.62	209.94	209.43	209.66	1109237.0
2015-02-20 09:00:00	SPY	ETF	209.65	209.86	208.78	208.89	16416053.0
2015-02-20 10:00:00	SPY	ETF	208.88	209.83	208.73	209.68	23536950.0
2015-02-20 11:00:00	SPY	ETF	209.67	209.83	209.54	209.765	9514993.0
2015-02-20 12:00:00	SPY	ETF	209.76	210.31	209.65	210.0899	16380599.0
2015-02-20 13:00:00	SPY	ETF	210.08	210.8	210.03	210.73	12502601.0
2015-02-20 14:00:00	SPY	ETF	210.73	210.97	210.61	210.93	13936117.0
2015-02-20 15:00:00	SPY	ETF	210.94	211.33	210.94	211.27	28922021.0
2015-02-20 16:00:00	SPY	ETF	211.28	211.31	211.1	211.24	10474776.0
2015-02-20 17:00:00	SPY	ETF	211.231	211.24	211.1	211.18	2570678.0
2015-02-20 18:00:00	SPY	ETF	211.19	211.22	211.15	211.22	14239.0
2015-02-20 19:00:00	SPY	ETF	211.2	211.24	211.11	211.24	27189.0
2015-02-20 04:00:00	QQQ	ETF	107.65	107.65	107.65	107.65	400.0
2015-02-20 05:00:00	QQQ	ETF	107.8	107.8	107.8	107.8	1000.0
2015-02-20 07:00:00	QQQ	ETF	107.94	107.94	107.6	107.6	72988.0
2015-02-20 08:00:00	QQQ	ETF	107.66	107.7	107.54	107.7	247047.0
2015-02-20 09:00:00	QQQ	ETF	107.66	107.739	107.28	107.39	5214088.0
2015-02-20 10:00:00	QQQ	ETF	107.39	107.88	107.311	107.79	3388457.0
2015-02-20 11:00:00	QQQ	ETF	107.78	107.8789	107.69	107.75	1637276.0
2015-02-20 12:00:00	QQQ	ETF	107.76	107.95	107.737	107.9	2594116.0
2015-02-20 13:00:00	QQQ	ETF	107.89	108.2	107.87	108.1801	2707941.0
2015-02-20 14:00:00	QQQ	ETF	108.18	108.3	108.12	108.264	2954727.0
2015-02-20 15:00:00	QQQ	ETF	108.265	108.47	108.265	108.4	5270037.0
2015-02-20 16:00:00	QQQ	ETF	108.4	108.4384	108.32	108.42	1767429.0
2015-02-20 17:00:00	QQQ	ETF	108.37	108.39	108.36	108.39	2805.0
2015-02-20 18:00:00	QQQ	ETF	108.35	108.39	108.35	108.39	2430.0
2015-02-20 19:00:00	QQQ	ETF	108.39	108.41	108.39	108.41	1388.0
2015-02-20 04:00:00	IWM	ETF	122.13	122.13	122.13	122.13	820.0
2015-02-20 07:00:00	IWM	ETF	122.32	122.32	121.97	122.07	52045.0
2015-02-20 08:00:00	IWM	ETF	122.03	122.07	121.91	122.07	57177.0
2015-02-20 09:00:00	IWM	ETF	122.0	122.07	120.98	121.1	4545356.0
2015-02-20 10:00:00	IWM	ETF	121.09	121.89	120.9	121.85	4284111.0
2015-02-20 11:00:00	IWM	ETF	121.86	122.03	121.69	121.92	2292986.0
2015-02-20 12:00:00	IWM	ETF	121.92	122.2399	121.87	121.95	3033394.0
2015-02-20 13:00:00	IWM	ETF	121.95	122.11	121.89	122.04	1805542.0
2015-02-20 14:00:00	IWM	ETF	122.04	122.23	122.004	122.2	2188310.0
2015-02-20 15:00:00	IWM	ETF	122.19	122.54	122.16	122.36	5305419.0
2015-02-20 16:00:00	IWM	ETF	122.37	122.41	122.0077	122.32	1226681.0
2015-02-20 17:00:00	IWM	ETF	122.27	122.38	122.25	122.33	1485988.0
2015-02-20 19:00:00	IWM	ETF	122.29	122.29	122.29	122.29	260.0
2015-02-20 04:00:00	DIA	ETF	179.72	179.72	179.48	179.48	650.0
2015-02-20 07:00:00	DIA	ETF	179.75	179.75	179.5	179.5	700.0
2015-02-20 08:00:00	DIA	ETF	179.24	179.32	179.14	179.31	5500.0
2015-02-20 09:00:00	DIA	ETF	179.26	179.42	178.5	178.62	754530.0
2015-02-20 10:00:00	DIA	ETF	178.6	179.7	178.51	179.52	1002115.0
2015-02-20 11:00:00	DIA	ETF	179.51	179.81	179.47	179.72	497207.0

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

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