PREVIEW / etf_5min / 2023-08-03

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-08-03.parquet
  size:    2.0 MB
  rows:    100,123

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-08-03 04:00:00	SPY	ETF	447.91	450.13	447.87	448.32	10721.0
2023-08-03 04:05:00	SPY	ETF	448.3	448.53	448.21	448.37	4025.0
2023-08-03 04:10:00	SPY	ETF	448.33	448.44	448.26	448.44	1316.0
2023-08-03 04:15:00	SPY	ETF	448.31	448.45	448.31	448.45	1250.0
2023-08-03 04:20:00	SPY	ETF	448.59	449.01	448.59	448.93	9129.0
2023-08-03 04:25:00	SPY	ETF	448.97	448.97	448.68	448.68	4834.0
2023-08-03 04:30:00	SPY	ETF	448.59	448.67	448.37	448.37	2015.0
2023-08-03 04:35:00	SPY	ETF	448.32	448.32	448.21	448.3	5967.0
2023-08-03 04:40:00	SPY	ETF	448.3	448.3	447.96	448.01	1902.0
2023-08-03 04:45:00	SPY	ETF	448.14	448.26	448.14	448.24	609.0
2023-08-03 04:50:00	SPY	ETF	448.38	448.38	448.15	448.19	2860.0
2023-08-03 04:55:00	SPY	ETF	448.22	448.74	448.22	448.74	1000.0
2023-08-03 05:00:00	SPY	ETF	448.74	448.89	448.74	448.89	1549.0
2023-08-03 05:05:00	SPY	ETF	448.84	449.26	448.84	449.26	3014.0
2023-08-03 05:10:00	SPY	ETF	449.3	449.36	449.0	449.0	7047.0
2023-08-03 05:15:00	SPY	ETF	448.96	449.25	448.96	449.25	6455.0
2023-08-03 05:20:00	SPY	ETF	449.32	449.32	449.1	449.1	9442.0
2023-08-03 05:25:00	SPY	ETF	449.25	449.25	449.03	449.07	1500.0
2023-08-03 05:30:00	SPY	ETF	449.09	449.21	449.09	449.21	500.0
2023-08-03 05:35:00	SPY	ETF	449.07	449.11	449.07	449.11	200.0
2023-08-03 05:40:00	SPY	ETF	449.35	449.38	449.35	449.38	900.0
2023-08-03 05:45:00	SPY	ETF	449.25	449.35	449.25	449.31	5000.0
2023-08-03 05:50:00	SPY	ETF	449.28	449.28	449.2	449.22	4102.0
2023-08-03 05:55:00	SPY	ETF	449.39	449.4	449.39	449.39	389.0
2023-08-03 06:00:00	SPY	ETF	449.34	449.7	449.34	449.7	7312.0
2023-08-03 06:05:00	SPY	ETF	449.75	449.8	449.6	449.6	24488.0
2023-08-03 06:10:00	SPY	ETF	449.56	449.56	449.54	449.55	2600.0
2023-08-03 06:15:00	SPY	ETF	449.64	449.65	449.63	449.63	721.0
2023-08-03 06:20:00	SPY	ETF	449.59	449.61	449.28	449.4	3203.0
2023-08-03 06:25:00	SPY	ETF	449.39	449.42	449.35	449.35	4577.0
2023-08-03 06:30:00	SPY	ETF	449.4	449.6	449.36	449.6	4946.0
2023-08-03 06:35:00	SPY	ETF	449.43	449.49	449.41	449.45	1275.0
2023-08-03 06:40:00	SPY	ETF	449.4	449.5	449.4	449.49	1674.0
2023-08-03 06:45:00	SPY	ETF	449.49	449.54	449.45	449.48	2864.0
2023-08-03 06:50:00	SPY	ETF	449.47	449.55	449.23	449.25	2598.0
2023-08-03 06:55:00	SPY	ETF	449.31	449.33	449.2	449.3	2821.0
2023-08-03 07:00:00	SPY	ETF	449.31	449.9	449.31	449.55	14741.0
2023-08-03 07:05:00	SPY	ETF	449.39	449.42	449.18	449.3	18541.0
2023-08-03 07:10:00	SPY	ETF	449.24	449.43	449.24	449.41	5442.0
2023-08-03 07:15:00	SPY	ETF	449.44	449.61	449.44	449.54	7553.0
2023-08-03 07:20:00	SPY	ETF	449.6	449.6	449.12	449.17	11092.0
2023-08-03 07:25:00	SPY	ETF	449.16	449.16	449.0	449.1	16587.0
2023-08-03 07:30:00	SPY	ETF	449.18	449.55	449.18	449.4	5446.0
2023-08-03 07:35:00	SPY	ETF	449.41	449.53	449.41	449.41	5928.0
2023-08-03 07:40:00	SPY	ETF	449.36	449.41	449.07	449.1	3428.0
2023-08-03 07:45:00	SPY	ETF	449.13	449.16	448.97	448.99	2788.0
2023-08-03 07:50:00	SPY	ETF	449.06	449.24	449.05	449.21	20363.0
2023-08-03 07:55:00	SPY	ETF	449.22	449.27	449.16	449.23	9721.0
2023-08-03 08:00:00	SPY	ETF	449.68	450.9	448.0	449.18	49647.0
2023-08-03 08:05:00	SPY	ETF	449.21	449.24	448.93	449.23	42135.0

> showing 50 of 100,123 rows — these rows as CSV

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