PREVIEW / etf_1hour / 2020-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-25.parquet
  size:    395 KB
  rows:    13,369

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
2020-11-25 04:00:00	SPY	ETF	363.26	363.6	362.65	363.22	37826.0
2020-11-25 05:00:00	SPY	ETF	363.22	363.32	362.45	362.65	29088.0
2020-11-25 06:00:00	SPY	ETF	362.7	363.1	362.55	363.01	20542.0
2020-11-25 07:00:00	SPY	ETF	362.99	363.57	362.6	362.84	178200.0
2020-11-25 08:00:00	SPY	ETF	363.3299	364.1	362.51	362.93	392288.0
2020-11-25 09:00:00	SPY	ETF	362.93	363.26	361.83	362.16	5280410.0
2020-11-25 10:00:00	SPY	ETF	362.16	362.49	361.48	362.045	6815580.0
2020-11-25 11:00:00	SPY	ETF	362.05	362.45	361.63	362.15	4826583.0
2020-11-25 12:00:00	SPY	ETF	362.17	362.72	361.99	362.6936	3589113.0
2020-11-25 13:00:00	SPY	ETF	362.7	362.9	362.17	362.6999	2432895.0
2020-11-25 14:00:00	SPY	ETF	362.7	362.7019	361.93	362.459	4211597.0
2020-11-25 15:00:00	SPY	ETF	362.45	363.16	362.37	362.65	8261026.0
2020-11-25 16:00:00	SPY	ETF	362.66	362.95	362.4	362.82	6726314.0
2020-11-25 17:00:00	SPY	ETF	362.94	362.98	362.72	362.9	25080.0
2020-11-25 18:00:00	SPY	ETF	363.0	363.18	362.66	363.12	62508.0
2020-11-25 19:00:00	SPY	ETF	363.1	363.4	362.6	363.1799	63559.0
2020-11-25 04:00:00	QQQ	ETF	295.52	295.59	294.99	295.5	45386.0
2020-11-25 05:00:00	QQQ	ETF	295.52	295.53	294.92	295.11	22504.0
2020-11-25 06:00:00	QQQ	ETF	295.16	295.41	294.97	295.28	77973.0
2020-11-25 07:00:00	QQQ	ETF	295.27	295.72	294.97	295.11	159777.0
2020-11-25 08:00:00	QQQ	ETF	295.1001	296.09	294.66	295.26	228332.0
2020-11-25 09:00:00	QQQ	ETF	295.261	296.22	295.13	295.74	2820963.0
2020-11-25 10:00:00	QQQ	ETF	295.72	295.82	294.59	295.49	2685172.0
2020-11-25 11:00:00	QQQ	ETF	295.49	295.96	294.82	295.14	2056883.0
2020-11-25 12:00:00	QQQ	ETF	295.14	296.13	294.959	296.03	1372867.0
2020-11-25 13:00:00	QQQ	ETF	296.03	296.389	295.6	296.13	1049703.0
2020-11-25 14:00:00	QQQ	ETF	296.114	296.36	295.53	296.31	1418368.0
2020-11-25 15:00:00	QQQ	ETF	296.31	296.94	296.09	296.42	4504271.0
2020-11-25 16:00:00	QQQ	ETF	296.44	296.99	296.28	296.79	1432654.0
2020-11-25 17:00:00	QQQ	ETF	296.8	296.9	296.75	296.82	18719.0
2020-11-25 18:00:00	QQQ	ETF	296.83	297.18	296.82	296.99	50895.0
2020-11-25 19:00:00	QQQ	ETF	297.1	297.12	296.75	297.06	42582.0
2020-11-25 04:00:00	IWM	ETF	184.47	184.8	183.7	183.87	27213.0
2020-11-25 05:00:00	IWM	ETF	183.9	184.02	183.47	183.47	15254.0
2020-11-25 06:00:00	IWM	ETF	183.47	183.88	183.46	183.61	72811.0
2020-11-25 07:00:00	IWM	ETF	183.62	184.05	183.58	183.7	95226.0
2020-11-25 08:00:00	IWM	ETF	183.66	184.01	183.51	183.87	66083.0
2020-11-25 09:00:00	IWM	ETF	183.87	184.04	182.21	182.44	3343954.0
2020-11-25 10:00:00	IWM	ETF	182.47	182.959	181.89	182.48	3752883.0
2020-11-25 11:00:00	IWM	ETF	182.48	183.65	182.43	183.64	1734215.0
2020-11-25 12:00:00	IWM	ETF	183.65	183.88	183.0	183.5452	1483465.0
2020-11-25 13:00:00	IWM	ETF	183.54	184.0217	183.5	183.86	996055.0
2020-11-25 14:00:00	IWM	ETF	183.86	183.97	183.27	183.915	1600610.0
2020-11-25 15:00:00	IWM	ETF	183.92	184.08	183.35	183.55	2703691.0
2020-11-25 16:00:00	IWM	ETF	183.56	184.3105	183.41	183.9	1600613.0
2020-11-25 17:00:00	IWM	ETF	183.85	184.16	183.85	184.15	54506.0
2020-11-25 18:00:00	IWM	ETF	184.0	184.33	183.91	184.0	25294.0
2020-11-25 19:00:00	IWM	ETF	184.02	184.37	183.82	184.22	17387.0
2020-11-25 04:00:00	DIA	ETF	299.0	300.33	299.0	300.15	15977.0
2020-11-25 05:00:00	DIA	ETF	299.99	300.09	299.84	299.85	600.0

> showing 50 of 13,369 rows — these rows as CSV

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