PREVIEW / etf_1hour / 2019-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-30.parquet
  size:    331 KB
  rows:    10,903

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
2019-09-30 04:00:00	SPY	ETF	296.43	296.78	296.43	296.63	16722.0
2019-09-30 05:00:00	SPY	ETF	296.67	296.75	296.42	296.75	13021.0
2019-09-30 06:00:00	SPY	ETF	296.61	296.65	296.07	296.12	31954.0
2019-09-30 07:00:00	SPY	ETF	296.12	296.35	296.07	296.21	109465.0
2019-09-30 08:00:00	SPY	ETF	296.07	296.55	295.55	295.62	384176.0
2019-09-30 09:00:00	SPY	ETF	295.63	296.71	295.57	296.49	5833870.0
2019-09-30 10:00:00	SPY	ETF	296.47	296.82	296.22	296.575	4865665.0
2019-09-30 11:00:00	SPY	ETF	296.58	297.18	296.305	297.035	3904280.0
2019-09-30 12:00:00	SPY	ETF	297.04	297.48	297.04	297.36	2960427.0
2019-09-30 13:00:00	SPY	ETF	297.37	297.55	297.21	297.305	2919066.0
2019-09-30 14:00:00	SPY	ETF	297.3	297.3655	297.06	297.07	3814135.0
2019-09-30 15:00:00	SPY	ETF	297.07	297.25	296.6	296.83	18046790.0
2019-09-30 16:00:00	SPY	ETF	296.83	297.66	296.77	297.51	7620150.0
2019-09-30 17:00:00	SPY	ETF	297.53	297.53	296.77	297.45	465774.0
2019-09-30 18:00:00	SPY	ETF	297.44	297.69	296.77	297.32	83087.0
2019-09-30 19:00:00	SPY	ETF	297.32	297.57	297.3	297.38	37492.0
2019-09-30 04:00:00	QQQ	ETF	188.03	188.5	188.01	188.2	46433.0
2019-09-30 05:00:00	QQQ	ETF	188.26	188.32	188.1	188.32	43591.0
2019-09-30 06:00:00	QQQ	ETF	188.26	188.26	187.84	187.85	16404.0
2019-09-30 07:00:00	QQQ	ETF	187.84	188.02	187.8	187.96	54360.0
2019-09-30 08:00:00	QQQ	ETF	187.9	188.14	187.41	187.51	146412.0
2019-09-30 09:00:00	QQQ	ETF	187.48	188.242	187.4	187.95	2715357.0
2019-09-30 10:00:00	QQQ	ETF	187.95	188.41	187.7666	188.13	3150852.0
2019-09-30 11:00:00	QQQ	ETF	188.15	188.54	187.92	188.45	1686182.0
2019-09-30 12:00:00	QQQ	ETF	188.45	189.11	188.43	188.97	2251632.0
2019-09-30 13:00:00	QQQ	ETF	188.9856	189.07	188.79	188.94	1363095.0
2019-09-30 14:00:00	QQQ	ETF	188.9443	189.01	188.67	188.69	1160211.0
2019-09-30 15:00:00	QQQ	ETF	188.68	188.89	188.39	188.78	6551020.0
2019-09-30 16:00:00	QQQ	ETF	188.77	189.27	187.122	189.2	1591554.0
2019-09-30 17:00:00	QQQ	ETF	189.17	189.24	188.81	189.15	16137.0
2019-09-30 18:00:00	QQQ	ETF	189.15	189.31	189.05	189.09	79951.0
2019-09-30 19:00:00	QQQ	ETF	189.1	189.25	189.07	189.14	37834.0
2019-09-30 04:00:00	IWM	ETF	151.74	152.0	151.74	151.99	1300.0
2019-09-30 05:00:00	IWM	ETF	151.87	151.87	151.87	151.87	100.0
2019-09-30 06:00:00	IWM	ETF	151.6	151.61	151.55	151.56	5255.0
2019-09-30 07:00:00	IWM	ETF	151.56	151.63	151.52	151.63	23833.0
2019-09-30 08:00:00	IWM	ETF	151.64	151.64	151.15	151.24	20477.0
2019-09-30 09:00:00	IWM	ETF	151.16	151.7	151.16	151.49	1654200.0
2019-09-30 10:00:00	IWM	ETF	151.48	151.59	150.79	151.17	1662203.0
2019-09-30 11:00:00	IWM	ETF	151.18	151.415	150.815	151.06	1555910.0
2019-09-30 12:00:00	IWM	ETF	151.085	151.83	151.085	151.75	1006293.0
2019-09-30 13:00:00	IWM	ETF	151.77	152.13	151.7	152.06	1678671.0
2019-09-30 14:00:00	IWM	ETF	152.05	152.26	151.98	152.17	1611639.0
2019-09-30 15:00:00	IWM	ETF	152.17	152.24	151.32	151.33	4250610.0
2019-09-30 16:00:00	IWM	ETF	151.34	151.81	151.32	151.72	1418679.0
2019-09-30 17:00:00	IWM	ETF	151.98	151.98	151.34	151.34	831600.0
2019-09-30 18:00:00	IWM	ETF	151.75	151.8	151.34	151.64	336800.0
2019-09-30 19:00:00	IWM	ETF	151.6	151.75	151.6	151.61	4400.0
2019-09-30 04:00:00	DIA	ETF	269.1	269.1	269.08	269.1	300.0
2019-09-30 05:00:00	DIA	ETF	269.08	269.08	269.08	269.08	1125.0

> showing 50 of 10,903 rows — these rows as CSV

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