PREVIEW / etf_1hour / 2017-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-08.parquet
  size:    276 KB
  rows:    8,906

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-02-08 04:00:00	SPY	ETF	228.83	229.26	228.82	229.26	6430.0
2017-02-08 05:00:00	SPY	ETF	229.28	229.28	229.06	229.08	13100.0
2017-02-08 06:00:00	SPY	ETF	229.13	229.15	229.02	229.02	6500.0
2017-02-08 07:00:00	SPY	ETF	229.04	229.13	228.72	228.72	245081.0
2017-02-08 08:00:00	SPY	ETF	228.75	229.05	228.58	228.75	281326.0
2017-02-08 09:00:00	SPY	ETF	228.75	228.75	228.31	228.5501	6071241.0
2017-02-08 10:00:00	SPY	ETF	228.55	229.07	228.47	228.97	8960784.0
2017-02-08 11:00:00	SPY	ETF	228.99	229.24	228.83	228.86	6756848.0
2017-02-08 12:00:00	SPY	ETF	228.86	229.1	228.82	228.94	4621782.0
2017-02-08 13:00:00	SPY	ETF	228.94	229.28	228.9301	229.21	3019013.0
2017-02-08 14:00:00	SPY	ETF	229.21	229.29	229.1	229.19	3582540.0
2017-02-08 15:00:00	SPY	ETF	229.19	229.39	229.06	229.26	11162643.0
2017-02-08 16:00:00	SPY	ETF	229.27	229.33	229.18	229.24	6154685.0
2017-02-08 17:00:00	SPY	ETF	229.23	229.33	229.2	229.27	100262.0
2017-02-08 18:00:00	SPY	ETF	229.25	229.32	229.24	229.25	20096.0
2017-02-08 19:00:00	SPY	ETF	229.25	229.25	229.13	229.17	159344.0
2017-02-08 04:00:00	QQQ	ETF	126.33	126.43	126.32	126.43	4446.0
2017-02-08 05:00:00	QQQ	ETF	126.41	126.41	126.35	126.35	822.0
2017-02-08 07:00:00	QQQ	ETF	126.29	126.33	126.25	126.25	65479.0
2017-02-08 08:00:00	QQQ	ETF	126.27	126.27	126.14	126.19	99697.0
2017-02-08 09:00:00	QQQ	ETF	126.16	126.16	125.88	126.08	1557987.0
2017-02-08 10:00:00	QQQ	ETF	126.08	126.54	126.05	126.48	2225022.0
2017-02-08 11:00:00	QQQ	ETF	126.4861	126.57	126.374	126.44	1350469.0
2017-02-08 12:00:00	QQQ	ETF	126.44	126.55	126.34	126.43	861901.0
2017-02-08 13:00:00	QQQ	ETF	126.44	126.58	126.43	126.54	695338.0
2017-02-08 14:00:00	QQQ	ETF	126.54	126.625	126.5	126.56	963096.0
2017-02-08 15:00:00	QQQ	ETF	126.56	126.68	126.47	126.52	2952978.0
2017-02-08 16:00:00	QQQ	ETF	126.52	126.57	126.49	126.53	758170.0
2017-02-08 17:00:00	QQQ	ETF	126.55	126.6	126.55	126.58	42335.0
2017-02-08 18:00:00	QQQ	ETF	126.54	126.6	126.54	126.54	33328.0
2017-02-08 19:00:00	QQQ	ETF	126.53	126.53	126.46	126.51	15843.0
2017-02-08 04:00:00	IWM	ETF	135.2	135.25	135.2	135.25	400.0
2017-02-08 07:00:00	IWM	ETF	135.15	135.15	134.94	134.97	65434.0
2017-02-08 08:00:00	IWM	ETF	135.08	135.1	134.8	134.95	109526.0
2017-02-08 09:00:00	IWM	ETF	134.84	134.88	133.89	134.15	4236544.0
2017-02-08 10:00:00	IWM	ETF	134.128	135.03	133.92	134.8983	5124983.0
2017-02-08 11:00:00	IWM	ETF	134.9	135.22	133.94	133.96	3878076.0
2017-02-08 12:00:00	IWM	ETF	133.955	134.4	133.95	134.37	2132938.0
2017-02-08 13:00:00	IWM	ETF	134.36	134.97	134.36	134.87	2033018.0
2017-02-08 14:00:00	IWM	ETF	134.87	135.01	134.68	134.89	1595719.0
2017-02-08 15:00:00	IWM	ETF	134.89	135.125	134.74	135.02	3885666.0
2017-02-08 16:00:00	IWM	ETF	135.0	135.2553	134.86	135.02	2482263.0
2017-02-08 17:00:00	IWM	ETF	134.92	135.05	134.92	135.05	19052.0
2017-02-08 18:00:00	IWM	ETF	135.04	135.04	135.01	135.01	1131.0
2017-02-08 19:00:00	IWM	ETF	135.0	135.0	135.0	135.0	100.0
2017-02-08 06:00:00	DIA	ETF	200.76	200.8	200.76	200.8	300.0
2017-02-08 07:00:00	DIA	ETF	200.73	200.73	200.7	200.7	200.0
2017-02-08 08:00:00	DIA	ETF	200.74	200.74	200.31	200.5	3501.0
2017-02-08 09:00:00	DIA	ETF	200.59	200.59	200.21	200.34	406213.0
2017-02-08 10:00:00	DIA	ETF	200.36	200.56	200.15	200.45	551171.0

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

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