PREVIEW / etf_1hour / 2016-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-02.parquet
  size:    253 KB
  rows:    8,157

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
2016-09-02 04:00:00	SPY	ETF	217.25	217.33	217.18	217.24	8938.0
2016-09-02 05:00:00	SPY	ETF	217.27	217.45	217.27	217.38	17819.0
2016-09-02 06:00:00	SPY	ETF	217.37	217.44	217.27	217.4	7041.0
2016-09-02 07:00:00	SPY	ETF	217.39	217.44	217.15	217.21	124755.0
2016-09-02 08:00:00	SPY	ETF	217.21	218.03	216.97	217.97	2935050.0
2016-09-02 09:00:00	SPY	ETF	217.97	218.85	217.91	218.73	13882744.0
2016-09-02 10:00:00	SPY	ETF	218.74	218.87	218.291	218.37	12260112.0
2016-09-02 11:00:00	SPY	ETF	218.38	218.64	218.17	218.35	7946959.0
2016-09-02 12:00:00	SPY	ETF	218.35	218.39	217.8	218.08	6777743.0
2016-09-02 13:00:00	SPY	ETF	218.07	218.17	217.7	217.85	5841642.0
2016-09-02 14:00:00	SPY	ETF	217.85	218.28	217.82	218.27	6957278.0
2016-09-02 15:00:00	SPY	ETF	218.26	218.45	218.19	218.37	16766126.0
2016-09-02 16:00:00	SPY	ETF	218.37	218.43	218.3	218.43	4127853.0
2016-09-02 17:00:00	SPY	ETF	218.42	218.54	218.33	218.54	241616.0
2016-09-02 18:00:00	SPY	ETF	218.52	218.52	218.39	218.39	72339.0
2016-09-02 19:00:00	SPY	ETF	218.4	218.43	218.33	218.34	39275.0
2016-09-02 04:00:00	QQQ	ETF	116.74	116.8	116.74	116.8	11300.0
2016-09-02 05:00:00	QQQ	ETF	116.8	116.8	116.79	116.79	10100.0
2016-09-02 07:00:00	QQQ	ETF	116.78	116.81	116.75	116.75	3400.0
2016-09-02 08:00:00	QQQ	ETF	116.78	117.15	116.61	117.12	638680.0
2016-09-02 09:00:00	QQQ	ETF	117.14	117.5	117.07	117.46	3513689.0
2016-09-02 10:00:00	QQQ	ETF	117.47	117.56	117.28	117.3	3123940.0
2016-09-02 11:00:00	QQQ	ETF	117.31	117.42	117.08	117.17	1879292.0
2016-09-02 12:00:00	QQQ	ETF	117.17	117.19	116.81	116.93	1884811.0
2016-09-02 13:00:00	QQQ	ETF	116.93	116.96	116.68	116.76	1564165.0
2016-09-02 14:00:00	QQQ	ETF	116.76	117.02	116.74	117.0	1174403.0
2016-09-02 15:00:00	QQQ	ETF	117.0	117.14	116.98	117.0901	2943615.0
2016-09-02 16:00:00	QQQ	ETF	117.1	117.13	117.03	117.12	623719.0
2016-09-02 17:00:00	QQQ	ETF	117.12	117.12	117.12	117.12	760.0
2016-09-02 18:00:00	QQQ	ETF	117.12	117.14	117.12	117.14	3250.0
2016-09-02 19:00:00	QQQ	ETF	117.07	117.14	117.07	117.07	1271.0
2016-09-02 20:00:00	QQQ	ETF	117.117	117.117	117.117	117.117	330000.0
2016-09-02 05:00:00	IWM	ETF	123.37	123.37	123.37	123.37	156.0
2016-09-02 07:00:00	IWM	ETF	123.35	123.42	123.32	123.33	11230.0
2016-09-02 08:00:00	IWM	ETF	123.34	123.85	123.17	123.77	429089.0
2016-09-02 09:00:00	IWM	ETF	123.8	124.46	123.63	124.33	5002078.0
2016-09-02 10:00:00	IWM	ETF	124.34	124.53	124.01	124.145	3877817.0
2016-09-02 11:00:00	IWM	ETF	124.14	124.33	124.02	124.27	1431272.0
2016-09-02 12:00:00	IWM	ETF	124.27	124.34	123.94	124.16	1454399.0
2016-09-02 13:00:00	IWM	ETF	124.15	124.2	123.85	123.91	1232377.0
2016-09-02 14:00:00	IWM	ETF	123.92	124.225	123.89	124.17	1821110.0
2016-09-02 15:00:00	IWM	ETF	124.175	124.52	124.13	124.52	3517807.0
2016-09-02 16:00:00	IWM	ETF	124.5	124.6	124.5	124.58	1277435.0
2016-09-02 17:00:00	IWM	ETF	124.54	124.67	124.54	124.61	31400.0
2016-09-02 18:00:00	IWM	ETF	124.62	124.62	124.62	124.62	905.0
2016-09-02 19:00:00	IWM	ETF	124.58	124.58	124.55	124.55	600.0
2016-09-02 20:00:00	IWM	ETF	124.4809	124.4809	124.4809	124.4809	290000.0
2016-09-02 08:00:00	DIA	ETF	184.25	184.62	184.25	184.62	17258.0
2016-09-02 09:00:00	DIA	ETF	184.8	185.42	184.8	185.23	668889.0
2016-09-02 10:00:00	DIA	ETF	185.24	185.32	184.88	184.97	410699.0

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

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