PREVIEW / etf_1hour / 2017-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-09.parquet
  size:    277 KB
  rows:    9,011

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-03-09 04:00:00	SPY	ETF	236.79	236.95	236.76	236.78	29952.0
2017-03-09 05:00:00	SPY	ETF	236.78	236.78	236.46	236.46	44361.0
2017-03-09 06:00:00	SPY	ETF	236.46	236.53	236.27	236.53	38330.0
2017-03-09 07:00:00	SPY	ETF	236.56	236.56	236.2	236.2	240167.0
2017-03-09 08:00:00	SPY	ETF	236.29	236.84	236.27	236.79	4055939.0
2017-03-09 09:00:00	SPY	ETF	236.8	237.05	236.48	236.89	8503022.0
2017-03-09 10:00:00	SPY	ETF	236.88	237.24	236.7	236.91	10090349.0
2017-03-09 11:00:00	SPY	ETF	236.905	237.09	236.74	236.895	7683980.0
2017-03-09 12:00:00	SPY	ETF	236.9	237.01	236.72	236.88	3439148.0
2017-03-09 13:00:00	SPY	ETF	236.875	236.97	236.42	236.46	7177062.0
2017-03-09 14:00:00	SPY	ETF	236.465	236.51	235.74	236.32	13679500.0
2017-03-09 15:00:00	SPY	ETF	236.32	236.97	236.3	236.82	19694696.0
2017-03-09 16:00:00	SPY	ETF	236.83	237.12	236.75	237.11	7004900.0
2017-03-09 17:00:00	SPY	ETF	237.08	237.09	236.79	237.05	221864.0
2017-03-09 18:00:00	SPY	ETF	237.05	237.41	236.96	237.3	149915.0
2017-03-09 19:00:00	SPY	ETF	237.27	237.4	237.24	237.35	171444.0
2017-03-09 06:00:00	QQQ	ETF	130.66	130.7	130.62	130.7	750.0
2017-03-09 07:00:00	QQQ	ETF	130.72	130.75	130.6	130.63	35191.0
2017-03-09 08:00:00	QQQ	ETF	130.65	130.82	130.63	130.82	64124.0
2017-03-09 09:00:00	QQQ	ETF	130.74	130.905	130.44	130.834	1792085.0
2017-03-09 10:00:00	QQQ	ETF	130.83	131.02	130.69	130.872	1399159.0
2017-03-09 11:00:00	QQQ	ETF	130.88	130.97	130.73	130.87	1138588.0
2017-03-09 12:00:00	QQQ	ETF	130.8648	130.9278	130.76	130.86	850103.0
2017-03-09 13:00:00	QQQ	ETF	130.87	130.9	130.58	130.6099	3415230.0
2017-03-09 14:00:00	QQQ	ETF	130.6	130.62	130.14	130.52	4247849.0
2017-03-09 15:00:00	QQQ	ETF	130.53	130.94	130.52	130.84	3975589.0
2017-03-09 16:00:00	QQQ	ETF	130.83	130.99	130.81	130.99	2377282.0
2017-03-09 17:00:00	QQQ	ETF	131.0	131.02	130.92	130.95	15971.0
2017-03-09 18:00:00	QQQ	ETF	130.91	131.02	130.9	131.01	6405.0
2017-03-09 19:00:00	QQQ	ETF	131.1	131.1	131.03	131.03	2000.0
2017-03-09 05:00:00	IWM	ETF	135.68	135.68	135.61	135.61	4700.0
2017-03-09 06:00:00	IWM	ETF	135.55	135.58	135.44	135.58	24378.0
2017-03-09 07:00:00	IWM	ETF	135.61	135.61	135.39	135.39	189712.0
2017-03-09 08:00:00	IWM	ETF	135.44	135.92	135.44	135.89	205461.0
2017-03-09 09:00:00	IWM	ETF	135.9	136.27	135.61	136.065	4182000.0
2017-03-09 10:00:00	IWM	ETF	136.05	136.49	135.74	136.0	3938307.0
2017-03-09 11:00:00	IWM	ETF	136.02	136.329	135.895	136.08	1902955.0
2017-03-09 12:00:00	IWM	ETF	136.08	136.17	135.83	135.945	2351549.0
2017-03-09 13:00:00	IWM	ETF	135.94	136.07	135.47	135.475	2161139.0
2017-03-09 14:00:00	IWM	ETF	135.47	135.52	134.89	135.22	5157612.0
2017-03-09 15:00:00	IWM	ETF	135.22	135.5299	135.13	135.34	7178612.0
2017-03-09 16:00:00	IWM	ETF	135.36	135.44	135.13	135.44	740709.0
2017-03-09 17:00:00	IWM	ETF	135.42	135.42	135.27	135.27	4620.0
2017-03-09 18:00:00	IWM	ETF	135.37	135.44	135.29	135.44	4696.0
2017-03-09 19:00:00	IWM	ETF	135.43	135.6	135.42	135.54	6994.0
2017-03-09 06:00:00	DIA	ETF	208.28	208.3	208.28	208.3	250.0
2017-03-09 07:00:00	DIA	ETF	208.32	208.32	208.31	208.31	10200.0
2017-03-09 08:00:00	DIA	ETF	208.32	208.67	208.27	208.65	12360.0
2017-03-09 09:00:00	DIA	ETF	208.55	208.905	208.55	208.79	404001.0
2017-03-09 10:00:00	DIA	ETF	208.79	209.09	208.73	208.8801	381347.0

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

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