PREVIEW / etf_5min / 2023-07-14

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-14.parquet
  size:    2.0 MB
  rows:    97,291

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-07-14 04:00:00	SPY	ETF	449.51	449.54	449.41	449.43	6111.0
2023-07-14 04:05:00	SPY	ETF	449.46	449.58	449.46	449.53	1902.0
2023-07-14 04:10:00	SPY	ETF	449.58	449.61	449.48	449.5	1584.0
2023-07-14 04:15:00	SPY	ETF	449.49	449.51	449.48	449.51	914.0
2023-07-14 04:20:00	SPY	ETF	449.5	449.5	449.48	449.48	761.0
2023-07-14 04:25:00	SPY	ETF	449.42	449.44	449.4	449.44	1000.0
2023-07-14 04:30:00	SPY	ETF	449.48	449.55	449.47	449.51	2664.0
2023-07-14 04:35:00	SPY	ETF	449.46	449.59	449.46	449.59	2110.0
2023-07-14 04:40:00	SPY	ETF	449.61	449.62	449.57	449.62	1700.0
2023-07-14 04:45:00	SPY	ETF	449.63	449.63	449.51	449.52	2370.0
2023-07-14 04:50:00	SPY	ETF	449.51	449.52	449.5	449.52	574.0
2023-07-14 04:55:00	SPY	ETF	449.36	449.36	449.36	449.36	184.0
2023-07-14 05:00:00	SPY	ETF	449.39	449.39	449.31	449.35	1657.0
2023-07-14 05:05:00	SPY	ETF	449.35	449.36	449.35	449.36	448.0
2023-07-14 05:10:00	SPY	ETF	449.45	449.45	449.41	449.41	547.0
2023-07-14 05:20:00	SPY	ETF	449.43	449.43	449.39	449.39	340.0
2023-07-14 05:25:00	SPY	ETF	449.43	449.44	449.42	449.44	304.0
2023-07-14 05:30:00	SPY	ETF	449.39	449.42	449.39	449.39	1378.0
2023-07-14 05:35:00	SPY	ETF	449.42	449.43	449.39	449.41	503.0
2023-07-14 05:40:00	SPY	ETF	449.3	449.3	449.28	449.28	311.0
2023-07-14 05:45:00	SPY	ETF	449.27	449.27	449.21	449.21	270.0
2023-07-14 05:50:00	SPY	ETF	449.16	449.2	449.16	449.19	2250.0
2023-07-14 05:55:00	SPY	ETF	449.39	449.4	449.35	449.36	1400.0
2023-07-14 06:00:00	SPY	ETF	449.3	449.47	449.3	449.47	612.0
2023-07-14 06:05:00	SPY	ETF	449.5	449.52	449.47	449.5	3450.0
2023-07-14 06:10:00	SPY	ETF	449.5	449.5	449.5	449.5	425.0
2023-07-14 06:15:00	SPY	ETF	449.49	449.52	449.48	449.5	1996.0
2023-07-14 06:25:00	SPY	ETF	449.43	449.5	449.43	449.5	280.0
2023-07-14 06:30:00	SPY	ETF	449.46	449.56	449.45	449.55	3994.0
2023-07-14 06:35:00	SPY	ETF	449.59	449.59	449.55	449.55	2952.0
2023-07-14 06:40:00	SPY	ETF	449.58	449.59	449.56	449.59	4100.0
2023-07-14 06:45:00	SPY	ETF	449.54	449.91	449.54	449.73	33967.0
2023-07-14 06:50:00	SPY	ETF	449.82	449.86	449.71	449.86	3240.0
2023-07-14 06:55:00	SPY	ETF	449.93	450.02	449.92	449.92	8636.0
2023-07-14 07:00:00	SPY	ETF	449.93	450.0	449.92	449.99	21466.0
2023-07-14 07:05:00	SPY	ETF	450.0	450.07	449.97	450.05	12625.0
2023-07-14 07:10:00	SPY	ETF	450.06	450.06	450.03	450.06	2102.0
2023-07-14 07:15:00	SPY	ETF	450.01	450.09	449.94	450.07	4742.0
2023-07-14 07:20:00	SPY	ETF	450.07	450.09	450.02	450.04	14375.0
2023-07-14 07:25:00	SPY	ETF	450.07	450.2	450.07	450.15	9951.0
2023-07-14 07:30:00	SPY	ETF	450.19	450.29	450.11	450.28	13389.0
2023-07-14 07:35:00	SPY	ETF	450.29	450.33	450.19	450.19	15651.0
2023-07-14 07:40:00	SPY	ETF	450.2	450.21	450.05	450.14	11194.0
2023-07-14 07:45:00	SPY	ETF	450.12	450.24	450.11	450.22	4111.0
2023-07-14 07:50:00	SPY	ETF	450.2	450.27	450.13	450.14	15943.0
2023-07-14 07:55:00	SPY	ETF	450.19	450.2	450.12	450.17	6794.0
2023-07-14 08:00:00	SPY	ETF	450.06	450.34	449.31	450.26	42973.0
2023-07-14 08:05:00	SPY	ETF	450.28	450.4	450.28	450.4	17716.0
2023-07-14 08:10:00	SPY	ETF	450.37	450.55	450.37	450.52	21173.0
2023-07-14 08:15:00	SPY	ETF	450.5	450.5	450.3	450.39	13776.0

> showing 50 of 97,291 rows — these rows as CSV

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