PREVIEW / etf_1hour / 2017-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-21.parquet
  size:    293 KB
  rows:    9,679

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-12-21 04:00:00	SPY	ETF	267.07	267.1	267.04	267.1	5461.0
2017-12-21 05:00:00	SPY	ETF	267.14	267.3	267.14	267.3	7145.0
2017-12-21 06:00:00	SPY	ETF	267.31	267.5	267.31	267.49	8322.0
2017-12-21 07:00:00	SPY	ETF	267.5	267.54	267.45	267.45	297957.0
2017-12-21 08:00:00	SPY	ETF	267.51	267.75	267.42	267.69	807361.0
2017-12-21 09:00:00	SPY	ETF	267.69	267.84	267.3	267.38	6323376.0
2017-12-21 10:00:00	SPY	ETF	267.38	268.09	267.37	267.87	7220338.0
2017-12-21 11:00:00	SPY	ETF	267.87	268.17	267.8	268.03	5408267.0
2017-12-21 12:00:00	SPY	ETF	268.03	268.21	267.91	268.19	6496065.0
2017-12-21 13:00:00	SPY	ETF	268.19	268.385	268.17	268.19	5300289.0
2017-12-21 14:00:00	SPY	ETF	268.19	268.2	267.925	268.09	4674942.0
2017-12-21 15:00:00	SPY	ETF	268.0925	268.12	267.41	267.57	16488330.0
2017-12-21 16:00:00	SPY	ETF	267.56	267.9523	267.42	267.46	7471848.0
2017-12-21 17:00:00	SPY	ETF	267.45	267.58	267.42	267.44	2390942.0
2017-12-21 18:00:00	SPY	ETF	267.43	267.74	267.43	267.68	1066211.0
2017-12-21 19:00:00	SPY	ETF	267.67	267.72	267.56	267.72	22116.0
2017-12-21 04:00:00	QQQ	ETF	157.39	157.46	157.39	157.42	12100.0
2017-12-21 05:00:00	QQQ	ETF	157.5	157.5	157.48	157.48	1300.0
2017-12-21 06:00:00	QQQ	ETF	157.58	157.68	157.52	157.62	5500.0
2017-12-21 07:00:00	QQQ	ETF	157.64	157.75	157.64	157.71	70295.0
2017-12-21 08:00:00	QQQ	ETF	157.71	157.81	157.64	157.77	55617.0
2017-12-21 09:00:00	QQQ	ETF	157.76	157.98	157.37	157.47	2645960.0
2017-12-21 10:00:00	QQQ	ETF	157.48	157.87	157.41	157.5967	2382863.0
2017-12-21 11:00:00	QQQ	ETF	157.59	158.09	157.58	157.93	1785031.0
2017-12-21 12:00:00	QQQ	ETF	157.93	158.11	157.86	158.09	987169.0
2017-12-21 13:00:00	QQQ	ETF	158.09	158.25	158.075	158.09	944025.0
2017-12-21 14:00:00	QQQ	ETF	158.09	158.09	157.76	157.86	1990476.0
2017-12-21 15:00:00	QQQ	ETF	157.85	157.9	157.41	157.56	3456885.0
2017-12-21 16:00:00	QQQ	ETF	157.56	157.8907	157.46	157.48	1326395.0
2017-12-21 17:00:00	QQQ	ETF	157.53	157.53	157.53	157.53	4924.0
2017-12-21 18:00:00	QQQ	ETF	157.5	157.69	157.49	157.68	6345.0
2017-12-21 19:00:00	QQQ	ETF	157.63	157.64	157.63	157.63	1900.0
2017-12-21 05:00:00	IWM	ETF	152.68	152.68	152.68	152.68	1000.0
2017-12-21 06:00:00	IWM	ETF	152.91	153.01	152.91	153.01	6531.0
2017-12-21 07:00:00	IWM	ETF	153.02	153.07	152.98	152.98	38530.0
2017-12-21 08:00:00	IWM	ETF	152.98	153.14	152.93	153.14	36963.0
2017-12-21 09:00:00	IWM	ETF	153.2	153.59	153.08	153.1	1678268.0
2017-12-21 10:00:00	IWM	ETF	153.1	153.55	153.1	153.5	1442179.0
2017-12-21 11:00:00	IWM	ETF	153.5	153.82	153.47	153.73	1635984.0
2017-12-21 12:00:00	IWM	ETF	153.725	153.78	153.55	153.77	1104787.0
2017-12-21 13:00:00	IWM	ETF	153.7714	153.91	153.74	153.81	876646.0
2017-12-21 14:00:00	IWM	ETF	153.8	153.91	153.6165	153.88	1372067.0
2017-12-21 15:00:00	IWM	ETF	153.88	154.0199	153.4	153.46	3058731.0
2017-12-21 16:00:00	IWM	ETF	153.46	153.55	153.4	153.49	1166899.0
2017-12-21 17:00:00	IWM	ETF	153.55	153.55	153.55	153.55	100.0
2017-12-21 18:00:00	IWM	ETF	153.53	153.67	153.47	153.66	9443.0
2017-12-21 19:00:00	IWM	ETF	153.67	153.7	153.55	153.68	8178.0
2017-12-21 07:00:00	DIA	ETF	247.31	247.31	247.31	247.31	2500.0
2017-12-21 08:00:00	DIA	ETF	247.45	247.5	247.07	247.5	188197.0
2017-12-21 09:00:00	DIA	ETF	247.62	247.89	247.4201	247.78	326486.0

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

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