PREVIEW / etf_1hour / 2017-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-02.parquet
  size:    287 KB
  rows:    9,469

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-02 04:00:00	SPY	ETF	251.44	251.48	251.41	251.45	18270.0
2017-10-02 05:00:00	SPY	ETF	251.45	251.57	251.45	251.55	8171.0
2017-10-02 06:00:00	SPY	ETF	251.53	251.69	251.49	251.68	20581.0
2017-10-02 07:00:00	SPY	ETF	251.68	251.76	251.58	251.73	144227.0
2017-10-02 08:00:00	SPY	ETF	251.72	251.76	251.5	251.51	299659.0
2017-10-02 09:00:00	SPY	ETF	251.52	251.88	251.4	251.85	5527473.0
2017-10-02 10:00:00	SPY	ETF	251.87	252.195	251.76	251.87	8552616.0
2017-10-02 11:00:00	SPY	ETF	251.87	251.95	251.61	251.615	4035882.0
2017-10-02 12:00:00	SPY	ETF	251.615	252.04	251.525	252.0	4307688.0
2017-10-02 13:00:00	SPY	ETF	252.01	252.1	251.93	252.08	2935744.0
2017-10-02 14:00:00	SPY	ETF	252.085	252.14	251.97	252.11	3337791.0
2017-10-02 15:00:00	SPY	ETF	252.11	252.3	251.2926	252.29	13119072.0
2017-10-02 16:00:00	SPY	ETF	252.28	252.44	251.9313	252.41	10672562.0
2017-10-02 17:00:00	SPY	ETF	252.42	252.43	252.37	252.37	2211089.0
2017-10-02 18:00:00	SPY	ETF	252.36	252.39	252.28	252.3	99245.0
2017-10-02 19:00:00	SPY	ETF	252.29	252.3	252.23	252.23	75246.0
2017-10-02 04:00:00	QQQ	ETF	145.62	145.62	145.55	145.57	2500.0
2017-10-02 05:00:00	QQQ	ETF	145.59	145.7	145.59	145.7	400.0
2017-10-02 06:00:00	QQQ	ETF	145.8	145.8	145.79	145.79	11800.0
2017-10-02 07:00:00	QQQ	ETF	145.79	145.89	145.75	145.85	7872.0
2017-10-02 08:00:00	QQQ	ETF	145.86	145.86	145.63	145.7	98020.0
2017-10-02 09:00:00	QQQ	ETF	145.71	146.05	145.63	146.04	4068920.0
2017-10-02 10:00:00	QQQ	ETF	146.02	146.17	145.86	145.94	3539208.0
2017-10-02 11:00:00	QQQ	ETF	145.94	146.04	145.12	145.12	4561967.0
2017-10-02 12:00:00	QQQ	ETF	145.12	145.475	144.93	145.46	3518215.0
2017-10-02 13:00:00	QQQ	ETF	145.465	145.54	145.34	145.4664	1988801.0
2017-10-02 14:00:00	QQQ	ETF	145.465	145.67	145.37	145.505	1827988.0
2017-10-02 15:00:00	QQQ	ETF	145.505	145.62	145.38	145.59	3708261.0
2017-10-02 16:00:00	QQQ	ETF	145.58	145.9344	145.46	145.59	1160313.0
2017-10-02 17:00:00	QQQ	ETF	145.6	145.6	145.56	145.6	1928.0
2017-10-02 18:00:00	QQQ	ETF	145.6	145.6	145.52	145.53	6562.0
2017-10-02 19:00:00	QQQ	ETF	145.55	145.56	145.52	145.53	10380.0
2017-10-02 07:00:00	IWM	ETF	148.26	148.41	148.25	148.41	23383.0
2017-10-02 08:00:00	IWM	ETF	148.39	148.41	148.16	148.16	89535.0
2017-10-02 09:00:00	IWM	ETF	148.21	148.81	148.08	148.76	2911715.0
2017-10-02 10:00:00	IWM	ETF	148.77	149.17	148.5866	148.65	4535533.0
2017-10-02 11:00:00	IWM	ETF	148.63	148.97	148.485	148.72	2662498.0
2017-10-02 12:00:00	IWM	ETF	148.71	149.31	148.56	149.29	2878772.0
2017-10-02 13:00:00	IWM	ETF	149.28	149.58	149.15	149.56	3191108.0
2017-10-02 14:00:00	IWM	ETF	149.56	149.58	149.38	149.47	2572822.0
2017-10-02 15:00:00	IWM	ETF	149.48	149.99	149.41	149.98	5488939.0
2017-10-02 16:00:00	IWM	ETF	150.0	150.2	148.874	150.14	2178995.0
2017-10-02 17:00:00	IWM	ETF	150.15	150.15	150.12	150.12	6455.0
2017-10-02 18:00:00	IWM	ETF	150.12	150.13	150.08	150.11	12113.0
2017-10-02 19:00:00	IWM	ETF	150.11	150.12	150.05	150.05	16154.0
2017-10-02 04:00:00	DIA	ETF	224.0	224.0	224.0	224.0	200.0
2017-10-02 06:00:00	DIA	ETF	224.08	224.08	224.08	224.08	200.0
2017-10-02 07:00:00	DIA	ETF	224.18	224.38	224.18	224.38	3500.0
2017-10-02 08:00:00	DIA	ETF	224.38	224.38	224.34	224.34	1100.0
2017-10-02 09:00:00	DIA	ETF	224.17	224.54	224.02	224.52	350657.0

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

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