PREVIEW / etf_1hour / 2017-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-03.parquet
  size:    274 KB
  rows:    8,867

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-03 04:00:00	SPY	ETF	237.88	237.88	237.66	237.75	14326.0
2017-03-03 05:00:00	SPY	ETF	237.76	238.09	237.76	238.09	24805.0
2017-03-03 06:00:00	SPY	ETF	238.07	238.31	238.07	238.17	62635.0
2017-03-03 07:00:00	SPY	ETF	238.16	238.25	237.98	238.03	82655.0
2017-03-03 08:00:00	SPY	ETF	238.02	238.27	237.85	238.2	383288.0
2017-03-03 09:00:00	SPY	ETF	238.2	238.48	238.04	238.05	6631281.0
2017-03-03 10:00:00	SPY	ETF	238.05	238.3	237.73	237.89	11389577.0
2017-03-03 11:00:00	SPY	ETF	237.89	238.3972	237.77	238.065	5479820.0
2017-03-03 12:00:00	SPY	ETF	238.06	238.3	237.96	238.2	5038420.0
2017-03-03 13:00:00	SPY	ETF	238.19	238.39	237.92	238.27	7892529.0
2017-03-03 14:00:00	SPY	ETF	238.27	238.43	238.14	238.355	4198066.0
2017-03-03 15:00:00	SPY	ETF	238.36	238.61	238.23	238.48	15816583.0
2017-03-03 16:00:00	SPY	ETF	238.47	238.5167	238.25	238.36	21329801.0
2017-03-03 17:00:00	SPY	ETF	238.34	238.35	238.3	238.33	74228.0
2017-03-03 18:00:00	SPY	ETF	238.32	238.42	238.25	238.31	214614.0
2017-03-03 19:00:00	SPY	ETF	238.3	238.35	238.29	238.35	21539.0
2017-03-03 04:00:00	QQQ	ETF	130.5	130.5	130.44	130.44	1550.0
2017-03-03 05:00:00	QQQ	ETF	130.5	130.62	130.5	130.62	18187.0
2017-03-03 06:00:00	QQQ	ETF	130.61	130.61	130.61	130.61	449.0
2017-03-03 07:00:00	QQQ	ETF	130.61	130.65	130.56	130.58	19797.0
2017-03-03 08:00:00	QQQ	ETF	130.65	130.66	130.53	130.66	98101.0
2017-03-03 09:00:00	QQQ	ETF	130.64	130.83	130.59	130.65	1714705.0
2017-03-03 10:00:00	QQQ	ETF	130.66	130.77	130.341	130.52	1632782.0
2017-03-03 11:00:00	QQQ	ETF	130.51	130.685	130.42	130.678	706031.0
2017-03-03 12:00:00	QQQ	ETF	130.66	130.85	130.63	130.8156	784871.0
2017-03-03 13:00:00	QQQ	ETF	130.81	130.95	130.63	130.85	1604907.0
2017-03-03 14:00:00	QQQ	ETF	130.845	130.97	130.78	130.9035	921897.0
2017-03-03 15:00:00	QQQ	ETF	130.9	131.06	130.85	131.035	2737476.0
2017-03-03 16:00:00	QQQ	ETF	131.035	131.04	130.98	131.03	1016107.0
2017-03-03 17:00:00	QQQ	ETF	131.03	131.04	131.0	131.04	35363.0
2017-03-03 18:00:00	QQQ	ETF	131.01	131.07	130.97	130.97	4768.0
2017-03-03 19:00:00	QQQ	ETF	130.98	131.02	130.98	131.02	2529.0
2017-03-03 04:00:00	IWM	ETF	138.26	138.26	138.08	138.08	460.0
2017-03-03 06:00:00	IWM	ETF	138.62	138.68	138.55	138.55	15600.0
2017-03-03 07:00:00	IWM	ETF	138.62	138.79	138.56	138.56	64529.0
2017-03-03 08:00:00	IWM	ETF	138.56	138.71	138.53	138.67	219757.0
2017-03-03 09:00:00	IWM	ETF	138.67	139.42	138.25	138.32	4030905.0
2017-03-03 10:00:00	IWM	ETF	138.34	138.7	137.99	138.35	4428972.0
2017-03-03 11:00:00	IWM	ETF	138.34	138.42	137.88	138.25	2792056.0
2017-03-03 12:00:00	IWM	ETF	138.25	138.48	138.02	138.21	1741942.0
2017-03-03 13:00:00	IWM	ETF	138.2	138.33	137.92	138.19	2392852.0
2017-03-03 14:00:00	IWM	ETF	138.17	138.37	138.05	138.34	1343451.0
2017-03-03 15:00:00	IWM	ETF	138.33	138.78	138.23	138.63	3630756.0
2017-03-03 16:00:00	IWM	ETF	138.65	138.6522	138.31	138.46	1730732.0
2017-03-03 17:00:00	IWM	ETF	138.49	138.5	138.48	138.5	3575.0
2017-03-03 19:00:00	IWM	ETF	138.45	138.6508	138.45	138.46	318100.0
2017-03-03 04:00:00	DIA	ETF	209.71	209.71	209.55	209.55	355.0
2017-03-03 06:00:00	DIA	ETF	210.04	210.04	210.04	210.04	200.0
2017-03-03 07:00:00	DIA	ETF	210.0	210.0	210.0	210.0	100.0
2017-03-03 08:00:00	DIA	ETF	210.12	210.12	210.05	210.05	600.0

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

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