PREVIEW / etf_1hour / 2020-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-30.parquet
  size:    373 KB
  rows:    12,696

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-09-30 04:00:00	SPY	ETF	330.55	331.01	330.35	330.74	75327.0
2020-09-30 05:00:00	SPY	ETF	330.81	330.81	329.6	330.8	77337.0
2020-09-30 06:00:00	SPY	ETF	330.71	332.49	330.0	331.77	130163.0
2020-09-30 07:00:00	SPY	ETF	331.75	332.0	331.21	331.32	315986.0
2020-09-30 08:00:00	SPY	ETF	331.7401	333.24	330.0	332.93	613544.0
2020-09-30 09:00:00	SPY	ETF	332.9	335.22	332.78	335.07	5267775.0
2020-09-30 10:00:00	SPY	ETF	335.06	336.6	335.01	335.88	9336435.0
2020-09-30 11:00:00	SPY	ETF	335.875	337.12	335.665	336.86	7715276.0
2020-09-30 12:00:00	SPY	ETF	336.81	337.59	336.773	337.07	4655143.0
2020-09-30 13:00:00	SPY	ETF	337.08	337.53	336.22	337.505	7206051.0
2020-09-30 14:00:00	SPY	ETF	337.52	338.29	334.21	335.88	16068342.0
2020-09-30 15:00:00	SPY	ETF	335.885	336.33	332.88	334.9	29594980.0
2020-09-30 16:00:00	SPY	ETF	334.9	337.35	333.38	333.85	17840706.0
2020-09-30 17:00:00	SPY	ETF	333.86	334.89	333.8	334.36	758345.0
2020-09-30 18:00:00	SPY	ETF	334.4	335.75	334.4	335.69	332139.0
2020-09-30 19:00:00	SPY	ETF	335.71	336.11	335.67	336.1	318907.0
2020-09-30 04:00:00	QQQ	ETF	273.54	274.21	273.43	274.02	89952.0
2020-09-30 05:00:00	QQQ	ETF	273.89	274.09	272.84	274.07	97695.0
2020-09-30 06:00:00	QQQ	ETF	274.03	275.54	273.5	275.0	134875.0
2020-09-30 07:00:00	QQQ	ETF	274.98	275.249	274.57	274.68	109204.0
2020-09-30 08:00:00	QQQ	ETF	275.0501	276.22	272.77	275.91	379298.0
2020-09-30 09:00:00	QQQ	ETF	275.9502	278.5499	275.85	278.52	3125662.0
2020-09-30 10:00:00	QQQ	ETF	278.52	279.98	278.171	278.96	5306286.0
2020-09-30 11:00:00	QQQ	ETF	278.95	280.48	278.67	280.24	3611069.0
2020-09-30 12:00:00	QQQ	ETF	280.225	280.63	279.23	279.53	3581352.0
2020-09-30 13:00:00	QQQ	ETF	279.55	280.44	278.6	280.41	3883862.0
2020-09-30 14:00:00	QQQ	ETF	280.41	281.09	277.61	279.07	8152072.0
2020-09-30 15:00:00	QQQ	ETF	279.07	279.57	276.48	278.1	10548061.0
2020-09-30 16:00:00	QQQ	ETF	278.09	278.47	276.77	277.0	1776661.0
2020-09-30 17:00:00	QQQ	ETF	277.0	277.84	276.91	277.18	249619.0
2020-09-30 18:00:00	QQQ	ETF	277.25	278.7	277.18	278.64	319875.0
2020-09-30 19:00:00	QQQ	ETF	278.66	279.09	278.6	279.08	150233.0
2020-09-30 04:00:00	IWM	ETF	148.63	148.8	148.48	148.8	13942.0
2020-09-30 05:00:00	IWM	ETF	148.72	148.72	148.19	148.6	13821.0
2020-09-30 06:00:00	IWM	ETF	148.6	149.69	148.5	149.25	8880.0
2020-09-30 07:00:00	IWM	ETF	149.06	149.4	149.04	149.08	32762.0
2020-09-30 08:00:00	IWM	ETF	149.06	150.11	148.39	149.86	134582.0
2020-09-30 09:00:00	IWM	ETF	149.8	151.18	149.74	151.05	2108515.0
2020-09-30 10:00:00	IWM	ETF	151.06	151.97	150.755	151.17	2642041.0
2020-09-30 11:00:00	IWM	ETF	151.17	151.44	150.92	151.23	2557359.0
2020-09-30 12:00:00	IWM	ETF	151.23	151.735	151.085	151.425	1255686.0
2020-09-30 13:00:00	IWM	ETF	151.42	151.44	150.87	151.02	1488777.0
2020-09-30 14:00:00	IWM	ETF	151.005	151.5163	148.9699	149.8851	4965991.0
2020-09-30 15:00:00	IWM	ETF	149.86	150.02	148.49	149.82	5849162.0
2020-09-30 16:00:00	IWM	ETF	149.83	149.95	148.9	149.05	1274344.0
2020-09-30 17:00:00	IWM	ETF	149.06	149.39	148.93	149.15	60048.0
2020-09-30 18:00:00	IWM	ETF	149.34	150.05	149.34	150.05	62180.0
2020-09-30 19:00:00	IWM	ETF	150.05	150.2	150.01	150.11	12198.0
2020-09-30 04:00:00	DIA	ETF	273.15	273.16	272.58	272.99	1600.0
2020-09-30 05:00:00	DIA	ETF	272.2	272.85	272.2	272.77	2433.0

> showing 50 of 12,696 rows — these rows as CSV

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