PREVIEW / etf_1hour / 2017-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-17.parquet
  size:    280 KB
  rows:    9,313

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
2017-07-17 04:00:00	SPY	ETF	245.54	245.59	245.51	245.53	13804.0
2017-07-17 05:00:00	SPY	ETF	245.51	245.51	245.3	245.41	6616.0
2017-07-17 06:00:00	SPY	ETF	245.45	245.73	245.45	245.62	46152.0
2017-07-17 07:00:00	SPY	ETF	245.64	245.74	245.59	245.65	118223.0
2017-07-17 08:00:00	SPY	ETF	245.72	245.72	245.44	245.46	255738.0
2017-07-17 09:00:00	SPY	ETF	245.46	245.68	245.33	245.64	3208176.0
2017-07-17 10:00:00	SPY	ETF	245.65	245.81	245.49	245.775	4582907.0
2017-07-17 11:00:00	SPY	ETF	245.78	245.87	245.52	245.63	3948169.0
2017-07-17 12:00:00	SPY	ETF	245.62	245.84	245.595	245.79	1781516.0
2017-07-17 13:00:00	SPY	ETF	245.8	245.91	245.65	245.69	1852493.0
2017-07-17 14:00:00	SPY	ETF	245.7	245.73	245.52	245.57	2470162.0
2017-07-17 15:00:00	SPY	ETF	245.57	245.62	245.4	245.51	7700143.0
2017-07-17 16:00:00	SPY	ETF	245.52	245.82	245.5	245.82	6674934.0
2017-07-17 17:00:00	SPY	ETF	245.81	245.82	245.5252	245.78	457808.0
2017-07-17 18:00:00	SPY	ETF	245.81	245.81	245.72	245.76	32112.0
2017-07-17 19:00:00	SPY	ETF	245.76	245.78	245.73	245.76	17913.0
2017-07-17 04:00:00	QQQ	ETF	142.37	142.37	142.27	142.27	3775.0
2017-07-17 05:00:00	QQQ	ETF	142.18	142.22	142.16	142.22	8200.0
2017-07-17 06:00:00	QQQ	ETF	142.35	142.45	142.35	142.4	7948.0
2017-07-17 07:00:00	QQQ	ETF	142.48	142.51	142.42	142.43	11562.0
2017-07-17 08:00:00	QQQ	ETF	142.44	142.45	142.25	142.29	38472.0
2017-07-17 09:00:00	QQQ	ETF	142.25	142.54	142.14	142.53	2324257.0
2017-07-17 10:00:00	QQQ	ETF	142.53	142.69	142.1399	142.17	3884368.0
2017-07-17 11:00:00	QQQ	ETF	142.18	142.255	142.02	142.115	2671563.0
2017-07-17 12:00:00	QQQ	ETF	142.11	142.36	142.07	142.32	1398662.0
2017-07-17 13:00:00	QQQ	ETF	142.319	142.37	142.06	142.12	1673382.0
2017-07-17 14:00:00	QQQ	ETF	142.12	142.16	141.92	142.065	2044924.0
2017-07-17 15:00:00	QQQ	ETF	142.07	142.25	142.03	142.16	3741716.0
2017-07-17 16:00:00	QQQ	ETF	142.16	142.61	142.16	142.59	1444359.0
2017-07-17 17:00:00	QQQ	ETF	142.58	142.59	142.54	142.54	21140.0
2017-07-17 18:00:00	QQQ	ETF	142.54	142.54	142.47	142.49	11772.0
2017-07-17 19:00:00	QQQ	ETF	142.53	142.54	142.51	142.53	5300.0
2017-07-17 05:00:00	IWM	ETF	141.52	141.6	141.52	141.6	200.0
2017-07-17 06:00:00	IWM	ETF	141.67	141.84	141.67	141.72	1200.0
2017-07-17 07:00:00	IWM	ETF	141.77	141.77	141.67	141.76	12597.0
2017-07-17 08:00:00	IWM	ETF	141.77	141.8	141.53	141.54	61784.0
2017-07-17 09:00:00	IWM	ETF	141.52	142.03	141.26	141.95	1791814.0
2017-07-17 10:00:00	IWM	ETF	141.92	142.31	141.73	142.2	2800828.0
2017-07-17 11:00:00	IWM	ETF	142.2	142.46	142.02	142.12	1791488.0
2017-07-17 12:00:00	IWM	ETF	142.11	142.3	142.04	142.255	691735.0
2017-07-17 13:00:00	IWM	ETF	142.26	142.37	142.12	142.3	816326.0
2017-07-17 14:00:00	IWM	ETF	142.3	142.38	142.06	142.16	1343810.0
2017-07-17 15:00:00	IWM	ETF	142.16	142.2	141.87	142.08	2600125.0
2017-07-17 16:00:00	IWM	ETF	142.06	142.2501	141.8422	142.18	1611650.0
2017-07-17 17:00:00	IWM	ETF	142.18	142.18	142.08	142.08	39931.0
2017-07-17 18:00:00	IWM	ETF	142.14	142.15	142.1	142.15	3265.0
2017-07-17 19:00:00	IWM	ETF	142.15	142.16	142.1199	142.16	529700.0
2017-07-17 06:00:00	DIA	ETF	215.95	215.95	215.95	215.95	200.0
2017-07-17 07:00:00	DIA	ETF	216.35	216.5	216.35	216.5	200.0
2017-07-17 08:00:00	DIA	ETF	216.48	216.53	216.41	216.41	3300.0

> showing 50 of 9,313 rows — these rows as CSV

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