PREVIEW / etf_1hour / 2017-07-18

all etf 1-hour files

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

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-18 04:00:00	SPY	ETF	245.45	245.9	245.45	245.88	92077.0
2017-07-18 05:00:00	SPY	ETF	245.83	245.88	245.73	245.73	18600.0
2017-07-18 06:00:00	SPY	ETF	245.85	245.85	245.62	245.63	12860.0
2017-07-18 07:00:00	SPY	ETF	245.67	245.71	245.5	245.55	89502.0
2017-07-18 08:00:00	SPY	ETF	245.56	245.67	245.1	245.11	708241.0
2017-07-18 09:00:00	SPY	ETF	245.11	245.26	244.88	245.14	6680652.0
2017-07-18 10:00:00	SPY	ETF	245.14	245.35	244.67	245.225	7357898.0
2017-07-18 11:00:00	SPY	ETF	245.22	245.46	245.07	245.39	4041933.0
2017-07-18 12:00:00	SPY	ETF	245.39	245.46	245.21	245.23	4399104.0
2017-07-18 13:00:00	SPY	ETF	245.23	245.49	245.1	245.44	2921313.0
2017-07-18 14:00:00	SPY	ETF	245.43	245.55	245.35	245.46	2778089.0
2017-07-18 15:00:00	SPY	ETF	245.45	245.72	245.43	245.69	7522901.0
2017-07-18 16:00:00	SPY	ETF	245.68	245.93	244.9574	245.85	4751025.0
2017-07-18 17:00:00	SPY	ETF	245.85	245.92	245.6762	245.87	374081.0
2017-07-18 18:00:00	SPY	ETF	245.86	245.86	245.68	245.72	177569.0
2017-07-18 19:00:00	SPY	ETF	245.76	245.76	245.71	245.74	13200.0
2017-07-18 04:00:00	QQQ	ETF	142.4	142.59	142.4	142.59	540.0
2017-07-18 05:00:00	QQQ	ETF	142.58	142.61	142.56	142.56	21100.0
2017-07-18 06:00:00	QQQ	ETF	142.59	142.59	142.45	142.45	7728.0
2017-07-18 07:00:00	QQQ	ETF	142.49	142.49	142.3	142.31	95909.0
2017-07-18 08:00:00	QQQ	ETF	142.33	142.83	141.96	141.96	266880.0
2017-07-18 09:00:00	QQQ	ETF	141.95	142.833	141.64	142.1599	2958478.0
2017-07-18 10:00:00	QQQ	ETF	142.16	142.55	142.01	142.53	4536071.0
2017-07-18 11:00:00	QQQ	ETF	142.53	142.77	142.38	142.7	2459400.0
2017-07-18 12:00:00	QQQ	ETF	142.71	142.785	142.56	142.65	1282742.0
2017-07-18 13:00:00	QQQ	ETF	142.65	142.94	142.51	142.92	1260555.0
2017-07-18 14:00:00	QQQ	ETF	142.92	143.065	142.86	142.96	2858337.0
2017-07-18 15:00:00	QQQ	ETF	142.96	143.17	142.93	143.14	5241928.0
2017-07-18 16:00:00	QQQ	ETF	143.13	143.53	142.6059	143.5	2165572.0
2017-07-18 17:00:00	QQQ	ETF	143.5	143.5	143.41	143.43	54354.0
2017-07-18 18:00:00	QQQ	ETF	143.47	143.47	143.33	143.34	56231.0
2017-07-18 19:00:00	QQQ	ETF	143.35	143.42	143.33	143.39	14139.0
2017-07-18 04:00:00	IWM	ETF	142.01	142.05	141.79	142.05	600.0
2017-07-18 05:00:00	IWM	ETF	142.05	142.05	141.88	141.88	200.0
2017-07-18 06:00:00	IWM	ETF	141.89	141.89	141.81	141.81	400.0
2017-07-18 07:00:00	IWM	ETF	141.8	141.8	141.59	141.7	42691.0
2017-07-18 08:00:00	IWM	ETF	141.71	141.71	141.37	141.44	110282.0
2017-07-18 09:00:00	IWM	ETF	141.44	141.79	141.26	141.73	2380866.0
2017-07-18 10:00:00	IWM	ETF	141.72	141.87	141.04	141.5	3167968.0
2017-07-18 11:00:00	IWM	ETF	141.49	141.54	141.22	141.48	1593212.0
2017-07-18 12:00:00	IWM	ETF	141.49	141.85	141.44	141.47	1259512.0
2017-07-18 13:00:00	IWM	ETF	141.46	141.635	141.38	141.59	1052348.0
2017-07-18 14:00:00	IWM	ETF	141.585	141.69	141.48	141.6	1032468.0
2017-07-18 15:00:00	IWM	ETF	141.595	141.84	141.57	141.68	2243889.0
2017-07-18 16:00:00	IWM	ETF	141.69	142.1182	141.5901	141.78	1221325.0
2017-07-18 17:00:00	IWM	ETF	141.7	141.7	141.69	141.69	34115.0
2017-07-18 18:00:00	IWM	ETF	141.67	141.69	141.67	141.69	7036.0
2017-07-18 19:00:00	IWM	ETF	141.76	141.76	141.76	141.76	500.0
2017-07-18 07:00:00	DIA	ETF	216.11	216.11	216.08	216.08	1700.0
2017-07-18 08:00:00	DIA	ETF	216.14	216.14	215.95	215.95	1300.0

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

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