PREVIEW / etf_1hour / 2017-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-27.parquet
  size:    288 KB
  rows:    9,416

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-10-27 04:00:00	SPY	ETF	256.35	256.56	256.34	256.48	12244.0
2017-10-27 05:00:00	SPY	ETF	256.53	256.76	256.53	256.67	9210.0
2017-10-27 06:00:00	SPY	ETF	256.7	256.7	256.54	256.65	5992.0
2017-10-27 07:00:00	SPY	ETF	256.62	256.69	256.55	256.56	125335.0
2017-10-27 08:00:00	SPY	ETF	256.57	256.62	256.17	256.5	482154.0
2017-10-27 09:00:00	SPY	ETF	256.5	256.65	256.16	256.51	7893517.0
2017-10-27 10:00:00	SPY	ETF	256.515	257.08	256.5	256.93	9130368.0
2017-10-27 11:00:00	SPY	ETF	256.92	257.51	256.92	257.455	7008667.0
2017-10-27 12:00:00	SPY	ETF	257.455	257.745	257.435	257.6	4184587.0
2017-10-27 13:00:00	SPY	ETF	257.6	257.71	257.45	257.69	4188761.0
2017-10-27 14:00:00	SPY	ETF	257.68	257.89	257.55	257.64	7078874.0
2017-10-27 15:00:00	SPY	ETF	257.64	257.76	257.43	257.68	25962110.0
2017-10-27 16:00:00	SPY	ETF	257.68	257.71	257.4	257.52	15678444.0
2017-10-27 17:00:00	SPY	ETF	257.52	257.67	257.41	257.6	532778.0
2017-10-27 18:00:00	SPY	ETF	257.59	257.62	257.52	257.61	42806.0
2017-10-27 19:00:00	SPY	ETF	257.61	257.65	257.56	257.58	125382.0
2017-10-27 04:00:00	QQQ	ETF	148.73	148.74	148.65	148.68	4429.0
2017-10-27 05:00:00	QQQ	ETF	148.77	148.91	148.73	148.89	23240.0
2017-10-27 06:00:00	QQQ	ETF	148.89	149.0	148.88	148.92	22975.0
2017-10-27 07:00:00	QQQ	ETF	148.92	149.07	148.82	149.01	200781.0
2017-10-27 08:00:00	QQQ	ETF	146.96	149.46	146.96	149.41	837929.0
2017-10-27 09:00:00	QQQ	ETF	149.39	149.93	149.2	149.79	8234277.0
2017-10-27 10:00:00	QQQ	ETF	149.8	150.48	149.75	150.09	7555467.0
2017-10-27 11:00:00	QQQ	ETF	150.1	150.99	150.09	150.866	6237593.0
2017-10-27 12:00:00	QQQ	ETF	150.86	151.27	150.82	151.075	6162254.0
2017-10-27 13:00:00	QQQ	ETF	151.07	151.38	150.98	151.37	2645766.0
2017-10-27 14:00:00	QQQ	ETF	151.36	151.5166	151.15	151.3	3571433.0
2017-10-27 15:00:00	QQQ	ETF	151.29	151.52	151.17	151.23	9665859.0
2017-10-27 16:00:00	QQQ	ETF	151.22	151.37	151.2	151.27	3268375.0
2017-10-27 17:00:00	QQQ	ETF	151.26	151.29	150.91	151.09	125847.0
2017-10-27 18:00:00	QQQ	ETF	151.09	151.19	151.09	151.18	8230.0
2017-10-27 19:00:00	QQQ	ETF	151.17	151.2	151.15	151.19	32399.0
2017-10-27 04:00:00	IWM	ETF	149.26	149.26	149.07	149.24	8715.0
2017-10-27 05:00:00	IWM	ETF	149.3	149.3	149.3	149.3	5000.0
2017-10-27 06:00:00	IWM	ETF	149.25	149.25	149.25	149.25	1000.0
2017-10-27 07:00:00	IWM	ETF	149.25	149.3	149.17	149.17	110410.0
2017-10-27 08:00:00	IWM	ETF	149.15	149.15	148.85	148.85	292385.0
2017-10-27 09:00:00	IWM	ETF	148.82	148.97	148.3	148.7	3391313.0
2017-10-27 10:00:00	IWM	ETF	148.7	149.095	148.43	148.91	3737200.0
2017-10-27 11:00:00	IWM	ETF	148.9	149.53	148.84	149.49	3462126.0
2017-10-27 12:00:00	IWM	ETF	149.49	149.76	149.46	149.69	1628246.0
2017-10-27 13:00:00	IWM	ETF	149.69	149.82	149.54	149.69	1210133.0
2017-10-27 14:00:00	IWM	ETF	149.7	149.84	149.629	149.66	1301779.0
2017-10-27 15:00:00	IWM	ETF	149.67	149.91	149.6	149.8	4355130.0
2017-10-27 16:00:00	IWM	ETF	149.8	149.9	149.0687	149.77	6119974.0
2017-10-27 17:00:00	IWM	ETF	149.79	149.79	149.69	149.77	259168.0
2017-10-27 18:00:00	IWM	ETF	149.79	149.8	149.72	149.8	4550.0
2017-10-27 19:00:00	IWM	ETF	149.8686	149.8686	149.76	149.81	83800.0
2017-10-27 07:00:00	DIA	ETF	234.32	234.45	234.32	234.41	525.0
2017-10-27 08:00:00	DIA	ETF	234.2	234.25	233.93	234.05	30980.0

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

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