PREVIEW / etf_1hour / 2017-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-31.parquet
  size:    285 KB
  rows:    9,388

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-31 04:00:00	SPY	ETF	256.86	257.14	256.86	257.14	4600.0
2017-10-31 05:00:00	SPY	ETF	257.11	257.2	257.11	257.17	5240.0
2017-10-31 06:00:00	SPY	ETF	257.2	257.2	257.06	257.07	4900.0
2017-10-31 07:00:00	SPY	ETF	257.08	257.26	257.03	257.25	84484.0
2017-10-31 08:00:00	SPY	ETF	257.06	257.22	257.06	257.16	155865.0
2017-10-31 09:00:00	SPY	ETF	257.19	257.25	256.88	256.94	3607597.0
2017-10-31 10:00:00	SPY	ETF	256.935	257.18	256.805	257.14	4750376.0
2017-10-31 11:00:00	SPY	ETF	257.13	257.375	257.11	257.3	3828139.0
2017-10-31 12:00:00	SPY	ETF	257.3	257.32	257.14	257.21	2671385.0
2017-10-31 13:00:00	SPY	ETF	257.22	257.29	257.15	257.27	2177421.0
2017-10-31 14:00:00	SPY	ETF	257.27	257.39	257.19	257.33	5240151.0
2017-10-31 15:00:00	SPY	ETF	257.33	257.44	256.99	257.11	17932415.0
2017-10-31 16:00:00	SPY	ETF	257.1	257.2	257.08	257.17	15123108.0
2017-10-31 17:00:00	SPY	ETF	257.15	257.3299	257.1	257.17	1452098.0
2017-10-31 18:00:00	SPY	ETF	257.19	257.29	257.07	257.13	161598.0
2017-10-31 19:00:00	SPY	ETF	257.13	257.23	257.13	257.18	861497.0
2017-10-31 04:00:00	QQQ	ETF	151.76	151.9	151.76	151.9	11000.0
2017-10-31 05:00:00	QQQ	ETF	151.9	151.95	151.9	151.95	10100.0
2017-10-31 06:00:00	QQQ	ETF	151.94	151.94	151.9	151.9	1600.0
2017-10-31 07:00:00	QQQ	ETF	151.86	152.04	151.84	152.02	12458.0
2017-10-31 08:00:00	QQQ	ETF	152.03	152.13	151.99	152.08	111465.0
2017-10-31 09:00:00	QQQ	ETF	152.08	152.14	151.63	151.77	2857693.0
2017-10-31 10:00:00	QQQ	ETF	151.76	152.04	151.67	151.96	3869859.0
2017-10-31 11:00:00	QQQ	ETF	151.95	152.165	151.94	152.13	2255501.0
2017-10-31 12:00:00	QQQ	ETF	152.14	152.15	151.885	152.075	1861575.0
2017-10-31 13:00:00	QQQ	ETF	152.075	152.14	152.0	152.14	1947118.0
2017-10-31 14:00:00	QQQ	ETF	152.14	152.37	152.12	152.1707	2475926.0
2017-10-31 15:00:00	QQQ	ETF	152.18	152.25	151.99	152.14	4905153.0
2017-10-31 16:00:00	QQQ	ETF	152.13	152.22	152.13	152.17	1037465.0
2017-10-31 17:00:00	QQQ	ETF	152.21	152.26	152.1	152.19	621666.0
2017-10-31 18:00:00	QQQ	ETF	152.18	152.28	152.1	152.21	27055.0
2017-10-31 19:00:00	QQQ	ETF	152.18	152.27	152.18	152.24	8698.0
2017-10-31 04:00:00	IWM	ETF	148.47	148.54	148.47	148.54	341.0
2017-10-31 05:00:00	IWM	ETF	148.62	148.65	148.6	148.6	5903.0
2017-10-31 06:00:00	IWM	ETF	148.63	148.68	148.61	148.64	9559.0
2017-10-31 07:00:00	IWM	ETF	148.65	148.83	148.59	148.79	24441.0
2017-10-31 08:00:00	IWM	ETF	148.66	148.81	148.66	148.74	33749.0
2017-10-31 09:00:00	IWM	ETF	148.78	149.05	148.71	148.78	2680479.0
2017-10-31 10:00:00	IWM	ETF	148.79	149.32	148.635	149.19	2431635.0
2017-10-31 11:00:00	IWM	ETF	149.19	149.39	148.975	149.15	1517256.0
2017-10-31 12:00:00	IWM	ETF	149.16	149.235	149.04	149.17	782115.0
2017-10-31 13:00:00	IWM	ETF	149.17	149.49	149.1201	149.48	1329120.0
2017-10-31 14:00:00	IWM	ETF	149.48	149.77	149.43	149.765	2503806.0
2017-10-31 15:00:00	IWM	ETF	149.765	149.83	149.25	149.28	5131222.0
2017-10-31 16:00:00	IWM	ETF	149.285	149.6	149.22	149.34	1340632.0
2017-10-31 17:00:00	IWM	ETF	149.26	149.26	149.26	149.26	342000.0
2017-10-31 18:00:00	IWM	ETF	149.38	149.44	149.28	149.28	11100.0
2017-10-31 19:00:00	IWM	ETF	149.27	149.29	149.27	149.29	4300.0
2017-10-31 06:00:00	DIA	ETF	233.52	233.82	233.52	233.82	1352.0
2017-10-31 07:00:00	DIA	ETF	233.5	233.68	233.5	233.68	3383.0

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

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