PREVIEW / etf_1hour / 2020-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-03.parquet
  size:    385 KB
  rows:    13,332

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-03 04:00:00	SPY	ETF	333.61	334.94	333.31	334.65	86405.0
2020-11-03 05:00:00	SPY	ETF	334.76	334.93	334.01	334.05	70661.0
2020-11-03 06:00:00	SPY	ETF	334.13	334.68	333.73	334.4	269779.0
2020-11-03 07:00:00	SPY	ETF	334.31	334.5	333.83	333.87	337273.0
2020-11-03 08:00:00	SPY	ETF	334.3999	334.5	331.4	333.67	487665.0
2020-11-03 09:00:00	SPY	ETF	333.7	335.56	333.17	335.38	6715981.0
2020-11-03 10:00:00	SPY	ETF	335.38	338.035	335.23	337.88	13303832.0
2020-11-03 11:00:00	SPY	ETF	337.88	338.25	336.8	336.91	8932931.0
2020-11-03 12:00:00	SPY	ETF	336.91	337.23	336.105	336.27	7458304.0
2020-11-03 13:00:00	SPY	ETF	336.28	336.82	334.84	335.03	7127994.0
2020-11-03 14:00:00	SPY	ETF	335.03	336.74	334.89	336.35	8967006.0
2020-11-03 15:00:00	SPY	ETF	336.34	338.0899	335.39	335.97	26465929.0
2020-11-03 16:00:00	SPY	ETF	335.94	336.1642	334.71	335.95	8748227.0
2020-11-03 17:00:00	SPY	ETF	335.9	336.19	335.65	336.07	233836.0
2020-11-03 18:00:00	SPY	ETF	336.11	339.42	335.63	338.27	945160.0
2020-11-03 19:00:00	SPY	ETF	338.22	339.6	333.74	333.89	1142364.0
2020-11-03 04:00:00	QQQ	ETF	272.16	272.55	271.83	272.28	62014.0
2020-11-03 05:00:00	QQQ	ETF	272.21	272.7	271.8	271.82	57883.0
2020-11-03 06:00:00	QQQ	ETF	271.9	272.1	271.0	271.55	151307.0
2020-11-03 07:00:00	QQQ	ETF	271.6	271.95	271.36	271.44	175547.0
2020-11-03 08:00:00	QQQ	ETF	271.65	272.23	270.21	271.61	342584.0
2020-11-03 09:00:00	QQQ	ETF	271.6	273.26	270.84	273.2139	4005047.0
2020-11-03 10:00:00	QQQ	ETF	273.25	276.52	273.1579	276.47	5335373.0
2020-11-03 11:00:00	QQQ	ETF	276.51	276.82	275.34	275.54	2851065.0
2020-11-03 12:00:00	QQQ	ETF	275.55	276.29	275.04	275.5471	2288110.0
2020-11-03 13:00:00	QQQ	ETF	275.56	276.06	273.62	273.83	3758047.0
2020-11-03 14:00:00	QQQ	ETF	273.82	275.28	273.72	275.03	4495484.0
2020-11-03 15:00:00	QQQ	ETF	275.05	276.5199	274.1	274.63	7575739.0
2020-11-03 16:00:00	QQQ	ETF	274.62	275.0675	273.61	274.35	2470455.0
2020-11-03 17:00:00	QQQ	ETF	274.48	274.83	274.17	274.78	109347.0
2020-11-03 18:00:00	QQQ	ETF	274.8	276.76	274.4	276.05	367599.0
2020-11-03 19:00:00	QQQ	ETF	276.04	276.72	274.03	274.03	320253.0
2020-11-03 04:00:00	IWM	ETF	157.88	159.11	157.72	158.78	39329.0
2020-11-03 05:00:00	IWM	ETF	158.81	159.0	158.41	158.41	16440.0
2020-11-03 06:00:00	IWM	ETF	158.46	158.88	158.36	158.88	137547.0
2020-11-03 07:00:00	IWM	ETF	158.85	158.85	158.46	158.55	171901.0
2020-11-03 08:00:00	IWM	ETF	158.55	158.82	157.7	158.16	250141.0
2020-11-03 09:00:00	IWM	ETF	158.15	159.85	158.06	159.77	3955148.0
2020-11-03 10:00:00	IWM	ETF	159.76	160.07	158.535	159.16	3639772.0
2020-11-03 11:00:00	IWM	ETF	159.2	159.6	158.99	159.33	1858888.0
2020-11-03 12:00:00	IWM	ETF	159.33	159.54	158.99	159.03	1099805.0
2020-11-03 13:00:00	IWM	ETF	159.04	159.5	158.99	159.18	1274998.0
2020-11-03 14:00:00	IWM	ETF	159.18	160.31	159.12	160.21	2785086.0
2020-11-03 15:00:00	IWM	ETF	160.215	161.2301	159.6	160.26	6283567.0
2020-11-03 16:00:00	IWM	ETF	160.26	160.88	159.8	160.8	2284633.0
2020-11-03 17:00:00	IWM	ETF	160.86	160.86	160.67	160.8	15545.0
2020-11-03 18:00:00	IWM	ETF	160.84	163.08	160.24	162.12	125279.0
2020-11-03 19:00:00	IWM	ETF	162.12	163.11	159.38	159.46	134919.0
2020-11-03 04:00:00	DIA	ETF	272.19	273.39	272.16	273.31	2800.0
2020-11-03 05:00:00	DIA	ETF	273.32	273.68	272.96	273.02	2750.0

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

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