PREVIEW / etf_1hour / 2017-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-02.parquet
  size:    285 KB
  rows:    9,346

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-11-02 04:00:00	SPY	ETF	257.1	257.25	257.02	257.15	1100.0
2017-11-02 05:00:00	SPY	ETF	257.0	257.19	256.9	257.14	5000.0
2017-11-02 06:00:00	SPY	ETF	257.17	257.17	257.04	257.12	19900.0
2017-11-02 07:00:00	SPY	ETF	257.14	257.34	257.14	257.28	59085.0
2017-11-02 08:00:00	SPY	ETF	257.29	257.54	257.17	257.51	224098.0
2017-11-02 09:00:00	SPY	ETF	257.49	257.53	257.25	257.37	4354399.0
2017-11-02 10:00:00	SPY	ETF	257.37	257.39	256.19	256.93	12377187.0
2017-11-02 11:00:00	SPY	ETF	256.93	257.27	256.63	257.03	6309320.0
2017-11-02 12:00:00	SPY	ETF	257.035	257.46	256.97	257.35	5865196.0
2017-11-02 13:00:00	SPY	ETF	257.35	257.4	257.11	257.18	3253496.0
2017-11-02 14:00:00	SPY	ETF	257.18	257.44	257.05	257.055	3772558.0
2017-11-02 15:00:00	SPY	ETF	257.055	257.75	257.05	257.61	11817340.0
2017-11-02 16:00:00	SPY	ETF	257.62	257.77	257.4104	257.4104	6532162.0
2017-11-02 17:00:00	SPY	ETF	257.67	257.75	257.59	257.67	670118.0
2017-11-02 18:00:00	SPY	ETF	257.64	257.74	257.6	257.71	166319.0
2017-11-02 19:00:00	SPY	ETF	257.71	257.8	257.6168	257.79	21117.0
2017-11-02 04:00:00	QQQ	ETF	151.76	151.76	151.76	151.76	2500.0
2017-11-02 05:00:00	QQQ	ETF	151.78	151.78	151.77	151.77	31152.0
2017-11-02 06:00:00	QQQ	ETF	151.79	151.79	151.73	151.74	3200.0
2017-11-02 07:00:00	QQQ	ETF	151.91	151.93	151.83	151.9	18625.0
2017-11-02 08:00:00	QQQ	ETF	151.9	152.1	151.85	152.09	79057.0
2017-11-02 09:00:00	QQQ	ETF	152.06	152.06	151.57	151.82	2846387.0
2017-11-02 10:00:00	QQQ	ETF	151.83	151.83	151.13	151.455	4737424.0
2017-11-02 11:00:00	QQQ	ETF	151.46	151.74	150.77	151.3	3831630.0
2017-11-02 12:00:00	QQQ	ETF	151.3	151.66	151.23	151.555	2066577.0
2017-11-02 13:00:00	QQQ	ETF	151.56	151.68	151.37	151.42	1243205.0
2017-11-02 14:00:00	QQQ	ETF	151.42	151.87	151.405	151.69	2469090.0
2017-11-02 15:00:00	QQQ	ETF	151.7	151.95	151.6401	151.81	3340167.0
2017-11-02 16:00:00	QQQ	ETF	151.8	152.53	151.4395	151.6039	1655033.0
2017-11-02 17:00:00	QQQ	ETF	152.44	152.44	152.1	152.2	145777.0
2017-11-02 18:00:00	QQQ	ETF	152.22	152.29	152.16	152.25	29336.0
2017-11-02 19:00:00	QQQ	ETF	152.25	152.31	152.25	152.31	18317.0
2017-11-02 04:00:00	IWM	ETF	148.05	148.05	147.9	147.9	6000.0
2017-11-02 05:00:00	IWM	ETF	147.89	147.97	147.82	147.97	4100.0
2017-11-02 06:00:00	IWM	ETF	147.98	147.98	147.9	147.96	3175.0
2017-11-02 07:00:00	IWM	ETF	148.06	148.1	148.0	148.07	60031.0
2017-11-02 08:00:00	IWM	ETF	148.06	148.44	147.97	148.38	172859.0
2017-11-02 09:00:00	IWM	ETF	148.4	148.49	148.03	148.3225	2491724.0
2017-11-02 10:00:00	IWM	ETF	148.3341	148.92	147.72	148.53	5185450.0
2017-11-02 11:00:00	IWM	ETF	148.55	148.74	148.25	148.69	1911157.0
2017-11-02 12:00:00	IWM	ETF	148.68	149.23	148.52	148.86	3059511.0
2017-11-02 13:00:00	IWM	ETF	148.85	148.88	148.425	148.49	2463807.0
2017-11-02 14:00:00	IWM	ETF	148.49	148.78	148.35	148.42	3070936.0
2017-11-02 15:00:00	IWM	ETF	148.41	148.96	148.36	148.73	4087865.0
2017-11-02 16:00:00	IWM	ETF	148.71	148.83	148.5381	148.7157	1842813.0
2017-11-02 17:00:00	IWM	ETF	148.71	148.71	148.61	148.67	800.0
2017-11-02 18:00:00	IWM	ETF	148.65	148.65	148.54	148.56	16309.0
2017-11-02 19:00:00	IWM	ETF	148.54	148.66	148.51	148.66	1810.0
2017-11-02 08:00:00	DIA	ETF	234.06	234.1	234.06	234.1	800.0
2017-11-02 09:00:00	DIA	ETF	234.25	234.44	234.13	234.17	499469.0

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

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