PREVIEW / etf_1hour / 2017-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-17.parquet
  size:    275 KB
  rows:    8,944

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-04-17 04:00:00	SPY	ETF	232.5	232.51	232.4	232.4	2340.0
2017-04-17 05:00:00	SPY	ETF	232.4	232.4	232.4	232.4	304.0
2017-04-17 06:00:00	SPY	ETF	232.5	232.52	232.43	232.48	5090.0
2017-04-17 07:00:00	SPY	ETF	232.5	233.01	232.43	233.01	154449.0
2017-04-17 08:00:00	SPY	ETF	233.01	233.2	232.46	233.14	706977.0
2017-04-17 09:00:00	SPY	ETF	233.14	233.34	232.88	233.22	6788587.0
2017-04-17 10:00:00	SPY	ETF	233.23	233.77	233.21	233.62	8552580.0
2017-04-17 11:00:00	SPY	ETF	233.63	233.95	233.565	233.58	5067843.0
2017-04-17 12:00:00	SPY	ETF	233.575	233.93	233.57	233.736	3422882.0
2017-04-17 13:00:00	SPY	ETF	233.73	233.97	233.7	233.86	3755701.0
2017-04-17 14:00:00	SPY	ETF	233.87	234.09	233.78	233.87	6551841.0
2017-04-17 15:00:00	SPY	ETF	233.86	234.57	233.81	234.57	21067974.0
2017-04-17 16:00:00	SPY	ETF	234.56	234.62	234.41	234.55	10757490.0
2017-04-17 17:00:00	SPY	ETF	234.55	234.6	234.52	234.56	328804.0
2017-04-17 18:00:00	SPY	ETF	234.55	234.58	234.45	234.5	134040.0
2017-04-17 19:00:00	SPY	ETF	234.5	234.52	234.45	234.49	53670.0
2017-04-17 04:00:00	QQQ	ETF	130.45	130.45	130.43	130.43	940.0
2017-04-17 05:00:00	QQQ	ETF	130.4	130.45	130.4	130.45	25138.0
2017-04-17 06:00:00	QQQ	ETF	130.5	130.51	130.45	130.46	5400.0
2017-04-17 07:00:00	QQQ	ETF	130.42	130.75	130.42	130.74	13140.0
2017-04-17 08:00:00	QQQ	ETF	130.69	130.84	130.68	130.83	204216.0
2017-04-17 09:00:00	QQQ	ETF	130.83	131.0153	130.73	130.9	2067297.0
2017-04-17 10:00:00	QQQ	ETF	130.895	131.31	130.87	131.12	2118057.0
2017-04-17 11:00:00	QQQ	ETF	131.115	131.24	131.03	131.03	877995.0
2017-04-17 12:00:00	QQQ	ETF	131.0271	131.22	131.0	131.09	752562.0
2017-04-17 13:00:00	QQQ	ETF	131.09	131.24	131.0764	131.16	768215.0
2017-04-17 14:00:00	QQQ	ETF	131.16	131.25	131.1	131.15	895672.0
2017-04-17 15:00:00	QQQ	ETF	131.15	131.5	131.1	131.48	3303298.0
2017-04-17 16:00:00	QQQ	ETF	131.49	131.51	131.34	131.46	778998.0
2017-04-17 17:00:00	QQQ	ETF	131.45	131.55	131.45	131.45	17755.0
2017-04-17 18:00:00	QQQ	ETF	131.43	131.45	131.39	131.45	4920.0
2017-04-17 19:00:00	QQQ	ETF	131.46	131.46	131.43	131.43	3180.0
2017-04-17 07:00:00	IWM	ETF	133.62	134.13	133.58	134.1	89857.0
2017-04-17 08:00:00	IWM	ETF	134.12	134.25	133.95	134.23	84996.0
2017-04-17 09:00:00	IWM	ETF	134.27	134.3	133.68	134.09	2282027.0
2017-04-17 10:00:00	IWM	ETF	134.091	134.36	133.875	134.29	2613309.0
2017-04-17 11:00:00	IWM	ETF	134.3	134.73	134.28	134.29	1665802.0
2017-04-17 12:00:00	IWM	ETF	134.29	134.52	134.24	134.305	828258.0
2017-04-17 13:00:00	IWM	ETF	134.29	134.39	134.18	134.245	904108.0
2017-04-17 14:00:00	IWM	ETF	134.25	134.53	134.21	134.3	1550146.0
2017-04-17 15:00:00	IWM	ETF	134.3	135.32	134.29	135.26	5033030.0
2017-04-17 16:00:00	IWM	ETF	135.26	135.56	135.17	135.49	1800650.0
2017-04-17 17:00:00	IWM	ETF	134.45	135.47	134.45	135.47	87248.0
2017-04-17 18:00:00	IWM	ETF	135.38	135.39	135.38	135.39	2350.0
2017-04-17 19:00:00	IWM	ETF	135.37	135.42	135.37	135.42	2671.0
2017-04-17 07:00:00	DIA	ETF	204.34	204.85	204.34	204.85	402.0
2017-04-17 08:00:00	DIA	ETF	204.76	205.11	204.22	205.11	4018.0
2017-04-17 09:00:00	DIA	ETF	205.0	205.18	204.86	205.08	227994.0
2017-04-17 10:00:00	DIA	ETF	205.094	205.385	205.05	205.36	345353.0
2017-04-17 11:00:00	DIA	ETF	205.37	205.605	205.3	205.31	181483.0

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

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