PREVIEW / etf_1hour / 2022-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-08.parquet
  size:    447 KB
  rows:    15,822

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-04-08 04:00:00	SPY	ETF	450.53	451.0	449.91	449.95	32901.0
2022-04-08 05:00:00	SPY	ETF	449.63	449.77	449.5	449.68	9992.0
2022-04-08 06:00:00	SPY	ETF	449.68	450.1	449.1	450.1	26380.0
2022-04-08 07:00:00	SPY	ETF	450.02	450.46	449.86	450.06	149978.0
2022-04-08 08:00:00	SPY	ETF	449.95	450.8904	448.52	448.8	339609.0
2022-04-08 09:00:00	SPY	ETF	448.77	448.77	445.97	446.1	5889791.0
2022-04-08 10:00:00	SPY	ETF	446.08	449.85	445.94	449.79	9170308.0
2022-04-08 11:00:00	SPY	ETF	449.8	450.255	448.84	449.58	6676107.0
2022-04-08 12:00:00	SPY	ETF	449.58	450.63	449.0822	450.19	5060201.0
2022-04-08 13:00:00	SPY	ETF	450.19	450.2168	448.6	448.83	4454067.0
2022-04-08 14:00:00	SPY	ETF	448.8301	449.35	447.64	448.61	5667265.0
2022-04-08 15:00:00	SPY	ETF	448.62	449.37	446.68	447.62	14675492.0
2022-04-08 16:00:00	SPY	ETF	447.61	448.04	447.2	447.41	3002316.0
2022-04-08 17:00:00	SPY	ETF	447.54	447.57	447.08	447.08	74887.0
2022-04-08 18:00:00	SPY	ETF	447.18	447.32	447.1	447.31	17640.0
2022-04-08 19:00:00	SPY	ETF	447.3	447.32	447.16	447.24	12391.0
2022-04-08 04:00:00	QQQ	ETF	356.01	356.53	355.16	355.21	69280.0
2022-04-08 05:00:00	QQQ	ETF	355.08	355.08	354.62	354.91	32862.0
2022-04-08 06:00:00	QQQ	ETF	354.9	355.2	354.1	355.15	69116.0
2022-04-08 07:00:00	QQQ	ETF	355.17	355.5	354.95	355.11	200293.0
2022-04-08 08:00:00	QQQ	ETF	355.21	356.4896	353.36	353.53	498486.0
2022-04-08 09:00:00	QQQ	ETF	353.47	353.47	348.62	348.84	7616955.0
2022-04-08 10:00:00	QQQ	ETF	348.82	352.42	348.71	352.39	8593940.0
2022-04-08 11:00:00	QQQ	ETF	352.38	353.04	350.49	351.83	6300778.0
2022-04-08 12:00:00	QQQ	ETF	351.81	353.09	351.35	352.66	4316007.0
2022-04-08 13:00:00	QQQ	ETF	352.66	352.67	350.23	350.51	3964312.0
2022-04-08 14:00:00	QQQ	ETF	350.5	351.14	349.2	350.22	6387704.0
2022-04-08 15:00:00	QQQ	ETF	350.24	351.0499	348.5	349.11	8905596.0
2022-04-08 16:00:00	QQQ	ETF	349.12	349.57	348.91	348.99	1389316.0
2022-04-08 17:00:00	QQQ	ETF	349.03	349.15	348.53	348.69	84435.0
2022-04-08 18:00:00	QQQ	ETF	348.7	348.8	348.67	348.8	11024.0
2022-04-08 19:00:00	QQQ	ETF	348.8	349.02	348.52	348.66	17886.0
2022-04-08 04:00:00	IWM	ETF	199.96	200.38	199.84	199.84	18421.0
2022-04-08 05:00:00	IWM	ETF	199.7	199.72	199.54	199.7	11277.0
2022-04-08 06:00:00	IWM	ETF	199.68	199.84	199.37	199.84	19880.0
2022-04-08 07:00:00	IWM	ETF	199.95	200.3	199.84	200.2	67449.0
2022-04-08 08:00:00	IWM	ETF	199.93	200.3	199.54	199.58	199016.0
2022-04-08 09:00:00	IWM	ETF	199.6	199.76	197.54	197.61	2951692.0
2022-04-08 10:00:00	IWM	ETF	197.6	199.99	197.5	199.96	3051288.0
2022-04-08 11:00:00	IWM	ETF	199.95	200.31	199.39	199.68	2090096.0
2022-04-08 12:00:00	IWM	ETF	199.68	200.08	199.26	199.81	1539153.0
2022-04-08 13:00:00	IWM	ETF	199.83	199.86	198.99	199.33	1269230.0
2022-04-08 14:00:00	IWM	ETF	199.31	199.65	198.66	199.17	1518977.0
2022-04-08 15:00:00	IWM	ETF	199.18	199.3901	197.71	197.98	4566293.0
2022-04-08 16:00:00	IWM	ETF	197.98	198.245	197.87	198.05	1302266.0
2022-04-08 17:00:00	IWM	ETF	198.05	198.19	197.81	197.81	155729.0
2022-04-08 18:00:00	IWM	ETF	197.73	197.97	197.73	197.97	5918.0
2022-04-08 19:00:00	IWM	ETF	198.07	198.17	197.81	198.17	8405.0
2022-04-08 04:00:00	DIA	ETF	347.33	347.33	346.97	346.97	1000.0
2022-04-08 05:00:00	DIA	ETF	346.81	346.81	346.72	346.72	300.0

> showing 50 of 15,822 rows — these rows as CSV

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