PREVIEW / etf_1hour / 2020-09-28

all etf 1-hour files

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

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-28 04:00:00	SPY	ETF	331.17	331.74	330.87	331.19	46279.0
2020-09-28 05:00:00	SPY	ETF	331.2	331.72	331.2	331.67	37478.0
2020-09-28 06:00:00	SPY	ETF	331.95	333.22	331.95	333.01	46447.0
2020-09-28 07:00:00	SPY	ETF	332.95	333.17	332.61	333.08	269176.0
2020-09-28 08:00:00	SPY	ETF	332.8301	333.59	329.85	333.33	411612.0
2020-09-28 09:00:00	SPY	ETF	333.33	333.85	332.15	332.76	7558383.0
2020-09-28 10:00:00	SPY	ETF	332.77	334.59	332.315	333.1	9914749.0
2020-09-28 11:00:00	SPY	ETF	333.1	334.26	333.0	333.7	5801771.0
2020-09-28 12:00:00	SPY	ETF	333.7	334.225	333.11	334.19	4919165.0
2020-09-28 13:00:00	SPY	ETF	334.2	334.81	333.815	334.63	5441134.0
2020-09-28 14:00:00	SPY	ETF	334.63	334.96	334.175	334.7336	5783323.0
2020-09-28 15:00:00	SPY	ETF	334.72	334.78	333.54	334.2	16577896.0
2020-09-28 16:00:00	SPY	ETF	334.19	334.98	333.9	334.73	5757500.0
2020-09-28 17:00:00	SPY	ETF	334.72	334.8	334.19	334.75	111075.0
2020-09-28 18:00:00	SPY	ETF	334.75	335.21	334.62	335.03	167154.0
2020-09-28 19:00:00	SPY	ETF	335.05	335.46	335.01	335.37	72741.0
2020-09-28 04:00:00	QQQ	ETF	274.0	274.95	273.8	274.44	32137.0
2020-09-28 05:00:00	QQQ	ETF	274.53	275.1	274.53	274.91	21815.0
2020-09-28 06:00:00	QQQ	ETF	275.0	276.58	274.88	276.15	70709.0
2020-09-28 07:00:00	QQQ	ETF	276.17	276.68	275.73	276.62	408958.0
2020-09-28 08:00:00	QQQ	ETF	276.2699	277.19	272.65	276.67	533318.0
2020-09-28 09:00:00	QQQ	ETF	276.7	276.8698	274.47	274.995	5913601.0
2020-09-28 10:00:00	QQQ	ETF	275.01	276.02	274.06	274.21	6359728.0
2020-09-28 11:00:00	QQQ	ETF	274.202	275.75	274.125	274.795	4305664.0
2020-09-28 12:00:00	QQQ	ETF	274.81	275.3	273.8548	275.3	2636025.0
2020-09-28 13:00:00	QQQ	ETF	275.29	276.37	274.78	276.2	3383524.0
2020-09-28 14:00:00	QQQ	ETF	276.2	276.57	275.5107	276.48	3678738.0
2020-09-28 15:00:00	QQQ	ETF	276.46	277.04	275.77	277.03	11478987.0
2020-09-28 16:00:00	QQQ	ETF	277.05	278.07	271.674	277.87	1501073.0
2020-09-28 17:00:00	QQQ	ETF	277.87	277.94	277.6	277.7	53795.0
2020-09-28 18:00:00	QQQ	ETF	277.7	278.35	277.68	277.97	81015.0
2020-09-28 19:00:00	QQQ	ETF	277.97	278.54	277.97	278.46	103423.0
2020-09-28 04:00:00	IWM	ETF	147.65	148.06	147.6	147.84	17150.0
2020-09-28 05:00:00	IWM	ETF	147.56	147.79	147.56	147.75	3550.0
2020-09-28 06:00:00	IWM	ETF	147.75	148.53	147.75	148.3	23272.0
2020-09-28 07:00:00	IWM	ETF	148.241	148.36	148.13	148.26	54019.0
2020-09-28 08:00:00	IWM	ETF	148.1699	148.46	147.31	148.41	39452.0
2020-09-28 09:00:00	IWM	ETF	148.41	149.31	148.2	148.74	2249434.0
2020-09-28 10:00:00	IWM	ETF	148.75	149.97	148.44	149.95	2650581.0
2020-09-28 11:00:00	IWM	ETF	149.98	150.29	148.62	149.77	1978007.0
2020-09-28 12:00:00	IWM	ETF	149.77	150.26	149.65	149.85	1122311.0
2020-09-28 13:00:00	IWM	ETF	149.87	149.9	149.54	149.66	938344.0
2020-09-28 14:00:00	IWM	ETF	149.66	150.3	149.53	150.29	953944.0
2020-09-28 15:00:00	IWM	ETF	150.28	150.44	149.7	150.06	3500201.0
2020-09-28 16:00:00	IWM	ETF	150.02	150.3	149.85	150.22	1189302.0
2020-09-28 17:00:00	IWM	ETF	150.12	150.49	150.1	150.1	10660.0
2020-09-28 18:00:00	IWM	ETF	150.07	150.33	150.07	150.31	12426.0
2020-09-28 19:00:00	IWM	ETF	150.34	150.4	150.26	150.32	17372.0
2020-09-28 04:00:00	DIA	ETF	273.86	274.16	273.56	274.03	2314.0
2020-09-28 06:00:00	DIA	ETF	275.09	275.44	275.05	275.29	3382.0

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

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