PREVIEW / etf_1hour / 2023-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-15.parquet
  size:    472 KB
  rows:    17,143

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
2023-09-15 04:00:00	SPY	ETF	445.0	449.68	445.0	449.1	41601.0
2023-09-15 05:00:00	SPY	ETF	449.11	449.44	449.06	449.44	29668.0
2023-09-15 06:00:00	SPY	ETF	449.34	449.6	449.22	449.6	30845.0
2023-09-15 07:00:00	SPY	ETF	449.59	449.6	449.06	449.09	175749.0
2023-09-15 08:00:00	SPY	ETF	449.4182	449.93	448.18	448.22	702689.0
2023-09-15 09:00:00	SPY	ETF	448.21	448.49	446.0	446.3965	9501713.0
2023-09-15 10:00:00	SPY	ETF	446.4	446.935	444.53	444.55	12759571.0
2023-09-15 11:00:00	SPY	ETF	444.551	445.32	444.28	445.095	8557416.0
2023-09-15 12:00:00	SPY	ETF	445.1	445.38	444.83	445.18	4755206.0
2023-09-15 13:00:00	SPY	ETF	445.18	445.19	443.02	443.97	8350191.0
2023-09-15 14:00:00	SPY	ETF	443.98	443.99	443.18	443.87	8167943.0
2023-09-15 15:00:00	SPY	ETF	443.875	443.99	442.92	443.29	21621686.0
2023-09-15 16:00:00	SPY	ETF	443.29	446.1295	443.0	443.47	8499911.0
2023-09-15 17:00:00	SPY	ETF	443.4	443.9	443.37	443.45	166154.0
2023-09-15 18:00:00	SPY	ETF	443.59	443.66	443.49	443.55	22471.0
2023-09-15 19:00:00	SPY	ETF	443.63	443.63	443.29	443.29	26002.0
2023-09-15 04:00:00	QQQ	ETF	377.47	377.57	376.93	376.97	54697.0
2023-09-15 05:00:00	QQQ	ETF	376.94	377.17	376.7	377.07	33995.0
2023-09-15 06:00:00	QQQ	ETF	376.96	377.32	376.91	377.31	19281.0
2023-09-15 07:00:00	QQQ	ETF	377.27	377.4	376.84	376.85	96023.0
2023-09-15 08:00:00	QQQ	ETF	377.36	378.42	376.11	376.14	441675.0
2023-09-15 09:00:00	QQQ	ETF	376.14	376.45	373.05	373.61	6177884.0
2023-09-15 10:00:00	QQQ	ETF	373.65	374.07	371.45	371.452	8037272.0
2023-09-15 11:00:00	QQQ	ETF	371.46	372.078	371.19	371.6888	6024832.0
2023-09-15 12:00:00	QQQ	ETF	371.7	372.5085	371.485	372.37	4024941.0
2023-09-15 13:00:00	QQQ	ETF	372.38	372.41	370.05	370.75	4065563.0
2023-09-15 14:00:00	QQQ	ETF	370.77	370.795	369.86	370.31	4354446.0
2023-09-15 15:00:00	QQQ	ETF	370.31	371.195	369.9159	370.66	10093629.0
2023-09-15 16:00:00	QQQ	ETF	370.665	370.9	370.48	370.52	2983303.0
2023-09-15 17:00:00	QQQ	ETF	370.5	370.81	370.5	370.7	403504.0
2023-09-15 18:00:00	QQQ	ETF	370.69	370.73	370.44	370.5	18220.0
2023-09-15 19:00:00	QQQ	ETF	370.5	370.5	370.28	370.28	20077.0
2023-09-15 04:00:00	IWM	ETF	185.98	186.02	185.65	185.71	17863.0
2023-09-15 05:00:00	IWM	ETF	185.78	185.94	185.78	185.88	4349.0
2023-09-15 06:00:00	IWM	ETF	185.85	185.98	185.84	185.95	5523.0
2023-09-15 07:00:00	IWM	ETF	185.92	185.95	185.66	185.68	17616.0
2023-09-15 08:00:00	IWM	ETF	185.6509	186.26	184.78	184.81	117825.0
2023-09-15 09:00:00	IWM	ETF	184.84	185.15	184.345	184.46	3744655.0
2023-09-15 10:00:00	IWM	ETF	184.47	184.89	183.555	183.57	3905148.0
2023-09-15 11:00:00	IWM	ETF	183.57	183.66	183.34	183.475	3044717.0
2023-09-15 12:00:00	IWM	ETF	183.48	183.555	183.31	183.4	1871562.0
2023-09-15 13:00:00	IWM	ETF	183.395	183.415	182.79	183.335	2539319.0
2023-09-15 14:00:00	IWM	ETF	183.34	183.63	183.21	183.535	2180358.0
2023-09-15 15:00:00	IWM	ETF	183.535	183.65	183.23	183.59	4745547.0
2023-09-15 16:00:00	IWM	ETF	183.61	183.96	183.5209	183.8	2675239.0
2023-09-15 17:00:00	IWM	ETF	183.79	183.93	183.73	183.86	24402.0
2023-09-15 18:00:00	IWM	ETF	183.92	183.95	183.86	183.89	4016.0
2023-09-15 19:00:00	IWM	ETF	183.88	183.88	183.71	183.88	7441.0
2023-09-15 04:00:00	DIA	ETF	349.76	349.8	349.65	349.75	3599.0
2023-09-15 05:00:00	DIA	ETF	349.94	349.95	349.94	349.95	687.0

> showing 50 of 17,143 rows — these rows as CSV

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