PREVIEW / etf_1hour / 2016-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-20.parquet
  size:    257 KB
  rows:    8,209

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
2016-04-20 04:00:00	SPY	ETF	209.28	209.47	209.12	209.12	16528.0
2016-04-20 05:00:00	SPY	ETF	209.19	209.54	209.19	209.54	9149.0
2016-04-20 06:00:00	SPY	ETF	209.42	209.86	209.38	209.79	53447.0
2016-04-20 07:00:00	SPY	ETF	209.79	210.21	209.79	210.05	443605.0
2016-04-20 08:00:00	SPY	ETF	209.95	210.14	209.4	210.09	464768.0
2016-04-20 09:00:00	SPY	ETF	210.06	210.15	209.67	209.9876	7444829.0
2016-04-20 10:00:00	SPY	ETF	209.99	210.0399	209.39	209.85	9604701.0
2016-04-20 11:00:00	SPY	ETF	209.85	210.47	209.77	210.26	10241414.0
2016-04-20 12:00:00	SPY	ETF	210.25	210.5	210.135	210.39	7232393.0
2016-04-20 13:00:00	SPY	ETF	210.39	210.69	210.22	210.57	6510256.0
2016-04-20 14:00:00	SPY	ETF	210.57	210.85	210.5	210.83	6849001.0
2016-04-20 15:00:00	SPY	ETF	210.83	210.92	210.0	210.06	19871139.0
2016-04-20 16:00:00	SPY	ETF	210.07	210.25	209.99	210.2	8829200.0
2016-04-20 17:00:00	SPY	ETF	210.19	210.24	210.1	210.16	1979237.0
2016-04-20 18:00:00	SPY	ETF	210.16	210.26	210.14	210.19	38212.0
2016-04-20 19:00:00	SPY	ETF	210.25	210.25	210.0309	210.23	423791.0
2016-04-20 04:00:00	QQQ	ETF	110.35	110.35	110.11	110.11	8750.0
2016-04-20 06:00:00	QQQ	ETF	110.38	110.58	110.27	110.56	51936.0
2016-04-20 07:00:00	QQQ	ETF	110.6	110.71	110.5	110.59	157577.0
2016-04-20 08:00:00	QQQ	ETF	110.58	110.67	110.55	110.62	115135.0
2016-04-20 09:00:00	QQQ	ETF	110.62	110.864	110.17	110.72	2822803.0
2016-04-20 10:00:00	QQQ	ETF	110.72	110.82	110.32	110.64	2764508.0
2016-04-20 11:00:00	QQQ	ETF	110.64	111.1	110.56	110.935	2415156.0
2016-04-20 12:00:00	QQQ	ETF	110.94	111.06	110.83	110.92	1491172.0
2016-04-20 13:00:00	QQQ	ETF	110.9201	111.03	110.79	110.9399	1552006.0
2016-04-20 14:00:00	QQQ	ETF	110.94	111.15	110.89	111.01	1596709.0
2016-04-20 15:00:00	QQQ	ETF	111.01	111.081	110.57	110.62	3128773.0
2016-04-20 16:00:00	QQQ	ETF	110.63	110.72	110.52	110.62	335851.0
2016-04-20 17:00:00	QQQ	ETF	110.63	110.75	110.53	110.62	36956.0
2016-04-20 18:00:00	QQQ	ETF	110.66	110.66	110.56	110.62	4915.0
2016-04-20 19:00:00	QQQ	ETF	110.64	110.67	110.5893	110.65	70983.0
2016-04-20 04:00:00	IWM	ETF	113.1	113.1	113.1	113.1	500.0
2016-04-20 07:00:00	IWM	ETF	113.49	113.56	113.48	113.5	24300.0
2016-04-20 08:00:00	IWM	ETF	113.47	113.53	113.43	113.53	107676.0
2016-04-20 09:00:00	IWM	ETF	113.52	113.61	113.18	113.55	1700133.0
2016-04-20 10:00:00	IWM	ETF	113.55	113.59	112.97	113.44	2640499.0
2016-04-20 11:00:00	IWM	ETF	113.45	113.78	113.36	113.53	2399704.0
2016-04-20 12:00:00	IWM	ETF	113.53	113.59	113.32	113.38	1485021.0
2016-04-20 13:00:00	IWM	ETF	113.39	113.95	113.35	113.85	2168657.0
2016-04-20 14:00:00	IWM	ETF	113.85	114.15	113.81	114.1325	1985963.0
2016-04-20 15:00:00	IWM	ETF	114.13	114.21	113.54	113.61	4034234.0
2016-04-20 16:00:00	IWM	ETF	113.61	113.68	113.4299	113.52	1121218.0
2016-04-20 17:00:00	IWM	ETF	113.58	113.58	113.54	113.56	800.0
2016-04-20 07:00:00	DIA	ETF	180.32	180.32	180.32	180.32	200.0
2016-04-20 08:00:00	DIA	ETF	180.45	180.45	180.23	180.31	775.0
2016-04-20 09:00:00	DIA	ETF	180.29	180.5	180.0	180.4	248979.0
2016-04-20 10:00:00	DIA	ETF	180.42	180.52	180.04	180.41	399946.0
2016-04-20 11:00:00	DIA	ETF	180.4	180.88	180.3538	180.73	389092.0
2016-04-20 12:00:00	DIA	ETF	180.74	181.05	180.67	180.95	249044.0
2016-04-20 13:00:00	DIA	ETF	180.97	181.27	180.87	181.16	343767.0

> showing 50 of 8,209 rows — these rows as CSV

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