PREVIEW / etf_1hour / 2017-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-30.parquet
  size:    280 KB
  rows:    8,987

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-01-30 04:00:00	SPY	ETF	228.59	228.59	228.29	228.36	17007.0
2017-01-30 05:00:00	SPY	ETF	228.35	228.4	228.31	228.31	8801.0
2017-01-30 06:00:00	SPY	ETF	228.35	228.4	228.31	228.31	17503.0
2017-01-30 07:00:00	SPY	ETF	228.32	228.4	228.21	228.33	75888.0
2017-01-30 08:00:00	SPY	ETF	228.31	228.38	228.01	228.19	375299.0
2017-01-30 09:00:00	SPY	ETF	228.18	228.24	227.02	227.3	12868062.0
2017-01-30 10:00:00	SPY	ETF	227.3	227.38	226.41	226.591	12945373.0
2017-01-30 11:00:00	SPY	ETF	226.6	227.17	226.53	227.115	9419993.0
2017-01-30 12:00:00	SPY	ETF	227.13	227.1739	226.81	226.935	5408203.0
2017-01-30 13:00:00	SPY	ETF	226.935	227.11	226.71	226.8501	4861579.0
2017-01-30 14:00:00	SPY	ETF	226.86	227.38	226.86	227.31	6528225.0
2017-01-30 15:00:00	SPY	ETF	227.3	227.76	226.99	227.62	15002804.0
2017-01-30 16:00:00	SPY	ETF	227.62	227.7123	227.53	227.68	8609353.0
2017-01-30 17:00:00	SPY	ETF	227.68	227.73	227.55	227.67	874468.0
2017-01-30 18:00:00	SPY	ETF	227.68	227.68	227.56	227.64	93746.0
2017-01-30 19:00:00	SPY	ETF	227.65	227.67	227.58	227.66	50268.0
2017-01-30 04:00:00	QQQ	ETF	125.45	125.45	125.39	125.39	1171.0
2017-01-30 05:00:00	QQQ	ETF	125.38	125.38	125.35	125.37	3798.0
2017-01-30 06:00:00	QQQ	ETF	125.37	125.42	125.36	125.36	16796.0
2017-01-30 07:00:00	QQQ	ETF	125.35	125.43	125.33	125.37	29487.0
2017-01-30 08:00:00	QQQ	ETF	125.37	125.42	125.21	125.39	435577.0
2017-01-30 09:00:00	QQQ	ETF	125.41	125.41	124.435	124.56	4842441.0
2017-01-30 10:00:00	QQQ	ETF	124.56	124.6	124.13	124.27	4248118.0
2017-01-30 11:00:00	QQQ	ETF	124.27	124.66	124.18	124.6458	2458955.0
2017-01-30 12:00:00	QQQ	ETF	124.65	124.69	124.425	124.4966	1418054.0
2017-01-30 13:00:00	QQQ	ETF	124.49	124.619	124.42	124.49	1137729.0
2017-01-30 14:00:00	QQQ	ETF	124.49	124.77	124.475	124.731	1739250.0
2017-01-30 15:00:00	QQQ	ETF	124.73	124.905	124.55	124.83	3618898.0
2017-01-30 16:00:00	QQQ	ETF	124.84	124.88	124.5289	124.87	937551.0
2017-01-30 17:00:00	QQQ	ETF	124.87	124.87	124.85	124.86	1750.0
2017-01-30 18:00:00	QQQ	ETF	124.85	124.85	124.78	124.78	22756.0
2017-01-30 19:00:00	QQQ	ETF	124.81	124.81	124.79	124.8	10086.0
2017-01-30 04:00:00	IWM	ETF	135.52	135.52	135.31	135.31	1137.0
2017-01-30 05:00:00	IWM	ETF	135.28	135.29	135.24	135.29	3002.0
2017-01-30 06:00:00	IWM	ETF	135.23	135.23	135.23	135.23	373.0
2017-01-30 07:00:00	IWM	ETF	135.24	135.35	135.17	135.25	89451.0
2017-01-30 08:00:00	IWM	ETF	135.24	135.24	134.96	135.15	144215.0
2017-01-30 09:00:00	IWM	ETF	135.16	135.27	133.36	133.8739	7570493.0
2017-01-30 10:00:00	IWM	ETF	133.87	134.01	133.24	133.41	5027612.0
2017-01-30 11:00:00	IWM	ETF	133.415	134.04	133.35	134.02	3736940.0
2017-01-30 12:00:00	IWM	ETF	134.02	134.24	133.94	134.13	2717467.0
2017-01-30 13:00:00	IWM	ETF	134.12	134.29	134.04	134.18	2099281.0
2017-01-30 14:00:00	IWM	ETF	134.18	134.64	134.18	134.46	3785677.0
2017-01-30 15:00:00	IWM	ETF	134.465	134.485	134.11	134.34	5900370.0
2017-01-30 16:00:00	IWM	ETF	134.33	134.35	134.21	134.21	1365409.0
2017-01-30 17:00:00	IWM	ETF	134.29	134.29	134.21	134.22	151377.0
2017-01-30 18:00:00	IWM	ETF	134.22	134.22	134.22	134.22	1200.0
2017-01-30 19:00:00	IWM	ETF	134.26	134.28	134.23	134.23	1872.0
2017-01-30 04:00:00	DIA	ETF	200.2	200.2	200.2	200.2	200.0
2017-01-30 06:00:00	DIA	ETF	200.13	200.13	200.11	200.11	410.0

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

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