PREVIEW / etf_1hour / 2017-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-07.parquet
  size:    293 KB
  rows:    9,640

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-07 04:00:00	SPY	ETF	258.93	259.04	258.83	258.95	25432.0
2017-11-07 05:00:00	SPY	ETF	258.92	258.92	258.8	258.8	900.0
2017-11-07 06:00:00	SPY	ETF	258.9	258.9	258.78	258.79	12820.0
2017-11-07 07:00:00	SPY	ETF	258.82	258.85	258.66	258.71	80581.0
2017-11-07 08:00:00	SPY	ETF	258.69	258.94	258.69	258.92	224488.0
2017-11-07 09:00:00	SPY	ETF	258.9	259.35	258.81	259.2	5043448.0
2017-11-07 10:00:00	SPY	ETF	259.2	259.27	258.56	258.735	9010078.0
2017-11-07 11:00:00	SPY	ETF	258.74	258.935	258.21	258.26	9054008.0
2017-11-07 12:00:00	SPY	ETF	258.26	258.52	258.09	258.4238	6116554.0
2017-11-07 13:00:00	SPY	ETF	258.42	258.66	258.4	258.49	3279873.0
2017-11-07 14:00:00	SPY	ETF	258.4868	258.5621	258.3	258.33	7215917.0
2017-11-07 15:00:00	SPY	ETF	258.33	258.72	258.23	258.7	11137756.0
2017-11-07 16:00:00	SPY	ETF	258.69	258.7645	258.4929	258.56	4645408.0
2017-11-07 17:00:00	SPY	ETF	258.57	258.62	258.36	258.37	235674.0
2017-11-07 18:00:00	SPY	ETF	258.4	258.4	257.98	258.08	169705.0
2017-11-07 19:00:00	SPY	ETF	258.08	258.3	258.04	258.13	47978.0
2017-11-07 04:00:00	QQQ	ETF	153.84	153.86	153.69	153.69	3963.0
2017-11-07 05:00:00	QQQ	ETF	153.73	153.73	153.61	153.71	20320.0
2017-11-07 06:00:00	QQQ	ETF	153.74	153.76	153.7	153.76	20700.0
2017-11-07 07:00:00	QQQ	ETF	153.74	153.74	153.56	153.58	22718.0
2017-11-07 08:00:00	QQQ	ETF	153.62	153.77	153.61	153.74	80727.0
2017-11-07 09:00:00	QQQ	ETF	153.68	154.0823	153.6	153.92	2399854.0
2017-11-07 10:00:00	QQQ	ETF	153.91	153.94	153.5	153.64	3136399.0
2017-11-07 11:00:00	QQQ	ETF	153.65	153.8601	153.4	153.45	2693160.0
2017-11-07 12:00:00	QQQ	ETF	153.45	153.81	153.34	153.73	2664868.0
2017-11-07 13:00:00	QQQ	ETF	153.73	153.84	153.7	153.73	1307253.0
2017-11-07 14:00:00	QQQ	ETF	153.72	153.75	153.58	153.67	1133682.0
2017-11-07 15:00:00	QQQ	ETF	153.67	153.87	153.53	153.87	2882354.0
2017-11-07 16:00:00	QQQ	ETF	153.88	153.8985	153.76	153.8	621051.0
2017-11-07 17:00:00	QQQ	ETF	153.8	153.8	153.69	153.69	12792.0
2017-11-07 18:00:00	QQQ	ETF	153.69	153.69	153.48	153.52	33363.0
2017-11-07 19:00:00	QQQ	ETF	153.57	153.66	153.57	153.62	4650.0
2017-11-07 04:00:00	IWM	ETF	148.9	149.02	148.83	148.86	11233.0
2017-11-07 05:00:00	IWM	ETF	148.78	148.78	148.76	148.76	1006.0
2017-11-07 06:00:00	IWM	ETF	148.85	148.85	148.73	148.82	6585.0
2017-11-07 07:00:00	IWM	ETF	148.75	148.75	148.61	148.65	4474.0
2017-11-07 08:00:00	IWM	ETF	148.68	148.76	148.64	148.76	41066.0
2017-11-07 09:00:00	IWM	ETF	148.69	148.85	148.58	148.66	1639368.0
2017-11-07 10:00:00	IWM	ETF	148.65	148.67	147.36	147.64	5397618.0
2017-11-07 11:00:00	IWM	ETF	147.65	147.96	146.54	146.6193	3954403.0
2017-11-07 12:00:00	IWM	ETF	146.605	147.15	146.54	146.87	3507740.0
2017-11-07 13:00:00	IWM	ETF	146.87	147.32	146.85	147.21	2023332.0
2017-11-07 14:00:00	IWM	ETF	147.21	147.45	147.0	147.0147	1351172.0
2017-11-07 15:00:00	IWM	ETF	147.02	147.03	146.71	147.03	4104069.0
2017-11-07 16:00:00	IWM	ETF	147.03	147.0343	146.79	146.87	2326272.0
2017-11-07 17:00:00	IWM	ETF	146.87	147.0	146.76	146.76	14801.0
2017-11-07 18:00:00	IWM	ETF	146.73	147.0	146.48	146.48	12905.0
2017-11-07 19:00:00	IWM	ETF	146.54	146.7	146.54	146.58	2733.0
2017-11-07 04:00:00	DIA	ETF	235.75	235.75	235.75	235.75	500.0
2017-11-07 05:00:00	DIA	ETF	235.65	235.65	235.65	235.65	500.0

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

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