PREVIEW / etf_1hour / 2021-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-15.parquet
  size:    427 KB
  rows:    14,917

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
2021-10-15 04:00:00	SPY	ETF	443.57	444.14	443.57	443.76	16154.0
2021-10-15 05:00:00	SPY	ETF	443.71	443.93	443.4	443.84	28422.0
2021-10-15 06:00:00	SPY	ETF	443.91	444.25	443.77	443.81	79299.0
2021-10-15 07:00:00	SPY	ETF	443.82	444.37	443.8	444.11	368286.0
2021-10-15 08:00:00	SPY	ETF	443.94	444.88	442.831	444.4504	1013703.0
2021-10-15 09:00:00	SPY	ETF	444.45	445.2575	444.09	445.2575	7467690.0
2021-10-15 10:00:00	SPY	ETF	445.25	445.7	444.34	445.4384	7433458.0
2021-10-15 11:00:00	SPY	ETF	445.43	445.54	444.59	444.8	4039898.0
2021-10-15 12:00:00	SPY	ETF	444.79	445.4	444.78	445.32	2694403.0
2021-10-15 13:00:00	SPY	ETF	445.31	445.7064	444.98	445.58	2710035.0
2021-10-15 14:00:00	SPY	ETF	445.5972	446.26	445.59	446.04	6620956.0
2021-10-15 15:00:00	SPY	ETF	446.03	446.1199	445.36	445.83	11785243.0
2021-10-15 16:00:00	SPY	ETF	445.83	446.05	445.66	446.01	3302280.0
2021-10-15 17:00:00	SPY	ETF	445.87	445.99	445.8	445.87	76064.0
2021-10-15 18:00:00	SPY	ETF	445.85	445.97	445.8	445.9	19703.0
2021-10-15 19:00:00	SPY	ETF	445.94	445.97	445.87	445.87	10012.0
2021-10-15 04:00:00	QQQ	ETF	367.13	367.81	367.13	367.52	32912.0
2021-10-15 05:00:00	QQQ	ETF	367.54	367.65	367.15	367.59	23274.0
2021-10-15 06:00:00	QQQ	ETF	367.6	367.91	367.49	367.55	20987.0
2021-10-15 07:00:00	QQQ	ETF	367.56	368.07	367.5	367.89	166527.0
2021-10-15 08:00:00	QQQ	ETF	367.6596	368.49	366.81	367.76	232242.0
2021-10-15 09:00:00	QQQ	ETF	367.77	368.16	366.91	367.6	4015286.0
2021-10-15 10:00:00	QQQ	ETF	367.6	368.4	366.82	368.385	3672395.0
2021-10-15 11:00:00	QQQ	ETF	368.3899	368.63	367.125	367.21	3833600.0
2021-10-15 12:00:00	QQQ	ETF	367.21	368.14	367.21	368.06	2058912.0
2021-10-15 13:00:00	QQQ	ETF	368.07	368.185	367.58	368.1	1759347.0
2021-10-15 14:00:00	QQQ	ETF	368.11	368.59	368.09	368.5	2120694.0
2021-10-15 15:00:00	QQQ	ETF	368.5	369.06	367.9	368.99	4638726.0
2021-10-15 16:00:00	QQQ	ETF	368.99	369.17	368.1816	369.17	3619967.0
2021-10-15 17:00:00	QQQ	ETF	369.17	369.17	368.94	369.0	153973.0
2021-10-15 18:00:00	QQQ	ETF	369.02	369.08	369.0	369.08	10711.0
2021-10-15 19:00:00	QQQ	ETF	369.09	369.29	369.05	369.29	13318.0
2021-10-15 04:00:00	IWM	ETF	226.55	226.7	226.53	226.63	5635.0
2021-10-15 05:00:00	IWM	ETF	226.48	226.58	226.38	226.57	9158.0
2021-10-15 06:00:00	IWM	ETF	226.58	226.75	226.49	226.61	11528.0
2021-10-15 07:00:00	IWM	ETF	226.51	227.05	226.49	226.96	31608.0
2021-10-15 08:00:00	IWM	ETF	226.6099	227.88	226.48	227.47	177709.0
2021-10-15 09:00:00	IWM	ETF	227.52	228.4062	227.43	228.1725	3166020.0
2021-10-15 10:00:00	IWM	ETF	228.18	228.22	226.93	227.71	2473817.0
2021-10-15 11:00:00	IWM	ETF	227.71	227.82	227.06	227.06	1598633.0
2021-10-15 12:00:00	IWM	ETF	227.05	227.31	226.64	226.87	1108131.0
2021-10-15 13:00:00	IWM	ETF	226.86	227.077	226.3	226.87	1327843.0
2021-10-15 14:00:00	IWM	ETF	226.89	227.24	226.72	226.84	1376387.0
2021-10-15 15:00:00	IWM	ETF	226.83	226.9198	225.06	225.12	5232980.0
2021-10-15 16:00:00	IWM	ETF	225.16	226.0006	224.86	225.02	2723378.0
2021-10-15 17:00:00	IWM	ETF	225.01	225.16	224.9	225.02	91801.0
2021-10-15 18:00:00	IWM	ETF	225.02	225.08	224.87	225.05	2656.0
2021-10-15 19:00:00	IWM	ETF	224.92	225.12	224.87	225.05	10254.0
2021-10-15 04:00:00	DIA	ETF	350.5	350.5	350.21	350.21	1448.0
2021-10-15 05:00:00	DIA	ETF	350.35	350.35	350.35	350.35	200.0

> showing 50 of 14,917 rows — these rows as CSV

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