PREVIEW / etf_1hour / 2022-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-07.parquet
  size:    443 KB
  rows:    16,031

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
2022-09-07 04:00:00	SPY	ETF	391.01	391.96	390.88	391.63	56682.0
2022-09-07 05:00:00	SPY	ETF	391.62	391.65	391.0	391.51	142477.0
2022-09-07 06:00:00	SPY	ETF	391.6	391.65	390.98	391.33	44518.0
2022-09-07 07:00:00	SPY	ETF	391.3	391.53	389.93	390.44	346026.0
2022-09-07 08:00:00	SPY	ETF	391.29	391.51	389.0	390.12	502985.0
2022-09-07 09:00:00	SPY	ETF	390.06	392.75	389.85	391.73	5838242.0
2022-09-07 10:00:00	SPY	ETF	391.73	393.39	390.8	392.79	7353512.0
2022-09-07 11:00:00	SPY	ETF	392.78	394.5	392.35	393.97	5824551.0
2022-09-07 12:00:00	SPY	ETF	393.99	395.15	392.85	394.72	5204701.0
2022-09-07 13:00:00	SPY	ETF	394.69	396.58	394.55	396.45	5321864.0
2022-09-07 14:00:00	SPY	ETF	396.45	397.8899	396.17	397.78	8421988.0
2022-09-07 15:00:00	SPY	ETF	397.8	398.59	397.43	397.77	13648795.0
2022-09-07 16:00:00	SPY	ETF	397.77	397.89	397.32	397.56	5503879.0
2022-09-07 17:00:00	SPY	ETF	397.56	397.85	397.5301	397.8	58192.0
2022-09-07 18:00:00	SPY	ETF	397.8	398.21	397.66	397.88	57171.0
2022-09-07 19:00:00	SPY	ETF	397.86	398.0	397.31	397.46	74443.0
2022-09-07 04:00:00	QQQ	ETF	293.5	294.4	293.33	294.06	68160.0
2022-09-07 05:00:00	QQQ	ETF	293.62	293.98	293.4	293.89	26911.0
2022-09-07 06:00:00	QQQ	ETF	293.96	294.0	293.45	293.53	95405.0
2022-09-07 07:00:00	QQQ	ETF	293.54	293.68	292.07	292.75	362073.0
2022-09-07 08:00:00	QQQ	ETF	293.57	293.6996	291.84	292.85	491570.0
2022-09-07 09:00:00	QQQ	ETF	292.82	295.66	292.72	294.48	6077985.0
2022-09-07 10:00:00	QQQ	ETF	294.46	295.24	293.27	294.39	6142374.0
2022-09-07 11:00:00	QQQ	ETF	294.3995	296.47	294.0	296.0716	4035390.0
2022-09-07 12:00:00	QQQ	ETF	296.0699	296.76	295.01	296.39	3443987.0
2022-09-07 13:00:00	QQQ	ETF	296.38	297.81	296.16	297.66	3181446.0
2022-09-07 14:00:00	QQQ	ETF	297.66	299.3585	297.5533	299.1501	4540736.0
2022-09-07 15:00:00	QQQ	ETF	299.155	299.99	298.83	298.95	7336598.0
2022-09-07 16:00:00	QQQ	ETF	298.95	299.13	298.6	298.96	1982570.0
2022-09-07 17:00:00	QQQ	ETF	298.99	299.19	298.9	299.13	208046.0
2022-09-07 18:00:00	QQQ	ETF	299.16	299.52	299.0	299.13	68659.0
2022-09-07 19:00:00	QQQ	ETF	299.16	299.38	298.78	298.88	93290.0
2022-09-07 04:00:00	IWM	ETF	178.25	178.64	178.14	178.63	16168.0
2022-09-07 05:00:00	IWM	ETF	178.6	178.61	178.26	178.52	11618.0
2022-09-07 06:00:00	IWM	ETF	178.49	178.62	178.43	178.5	3118.0
2022-09-07 07:00:00	IWM	ETF	178.5	178.67	177.89	178.14	34794.0
2022-09-07 08:00:00	IWM	ETF	178.65	178.65	177.46	177.86	79814.0
2022-09-07 09:00:00	IWM	ETF	177.81	179.485	177.76	178.87	2255448.0
2022-09-07 10:00:00	IWM	ETF	178.87	179.88	178.45	179.52	2031985.0
2022-09-07 11:00:00	IWM	ETF	179.52	180.01	179.28	179.71	1614208.0
2022-09-07 12:00:00	IWM	ETF	179.735	180.14	179.04	180.02	1215307.0
2022-09-07 13:00:00	IWM	ETF	180.02	180.87	180.02	180.81	1511122.0
2022-09-07 14:00:00	IWM	ETF	180.82	181.86	180.725	181.83	1946471.0
2022-09-07 15:00:00	IWM	ETF	181.83	182.465	181.73	182.19	3848096.0
2022-09-07 16:00:00	IWM	ETF	182.19	182.23	181.94	181.94	1680078.0
2022-09-07 17:00:00	IWM	ETF	181.96	182.19	181.94	182.15	1078164.0
2022-09-07 18:00:00	IWM	ETF	182.14	182.22	181.81	181.97	37409.0
2022-09-07 19:00:00	IWM	ETF	181.88	182.04	181.81	181.89	33589.0
2022-09-07 04:00:00	DIA	ETF	312.18	312.19	312.18	312.19	800.0
2022-09-07 05:00:00	DIA	ETF	312.64	312.64	312.18	312.36	4437.0

> showing 50 of 16,031 rows — these rows as CSV

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