PREVIEW / etf_5min / 2023-09-01

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-09-01.parquet
  size:    1.9 MB
  rows:    93,827

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-01 04:00:00	SPY	ETF	451.53	451.61	451.12	451.52	5930.0
2023-09-01 04:05:00	SPY	ETF	451.52	451.58	451.42	451.42	3154.0
2023-09-01 04:10:00	SPY	ETF	451.54	451.55	451.44	451.44	2598.0
2023-09-01 04:15:00	SPY	ETF	451.35	451.35	451.32	451.32	383.0
2023-09-01 04:20:00	SPY	ETF	451.32	451.35	451.32	451.32	1525.0
2023-09-01 04:25:00	SPY	ETF	451.45	451.45	451.45	451.45	200.0
2023-09-01 04:30:00	SPY	ETF	451.35	451.35	451.35	451.35	200.0
2023-09-01 04:40:00	SPY	ETF	451.4	451.4	451.4	451.4	721.0
2023-09-01 04:45:00	SPY	ETF	451.48	451.51	451.44	451.49	1691.0
2023-09-01 04:50:00	SPY	ETF	451.57	451.57	451.46	451.46	900.0
2023-09-01 04:55:00	SPY	ETF	451.37	451.37	451.37	451.37	135.0
2023-09-01 05:00:00	SPY	ETF	451.52	451.62	451.52	451.62	899.0
2023-09-01 05:05:00	SPY	ETF	451.62	451.69	451.62	451.65	3957.0
2023-09-01 05:10:00	SPY	ETF	451.63	451.82	451.63	451.77	5800.0
2023-09-01 05:15:00	SPY	ETF	451.86	451.89	451.85	451.89	1740.0
2023-09-01 05:20:00	SPY	ETF	451.86	451.88	451.86	451.88	5032.0
2023-09-01 05:25:00	SPY	ETF	451.94	451.95	451.94	451.95	243.0
2023-09-01 05:30:00	SPY	ETF	451.92	451.92	451.92	451.92	161.0
2023-09-01 05:35:00	SPY	ETF	451.82	451.95	451.74	451.95	1306.0
2023-09-01 05:40:00	SPY	ETF	451.89	451.89	451.8	451.8	400.0
2023-09-01 05:45:00	SPY	ETF	451.83	451.85	451.8	451.85	1200.0
2023-09-01 05:50:00	SPY	ETF	451.83	451.83	451.74	451.74	5164.0
2023-09-01 05:55:00	SPY	ETF	451.69	451.71	451.69	451.71	800.0
2023-09-01 06:00:00	SPY	ETF	451.7	451.7	451.5	451.5	2158.0
2023-09-01 06:05:00	SPY	ETF	451.54	451.64	451.49	451.64	1600.0
2023-09-01 06:10:00	SPY	ETF	451.76	451.99	451.76	451.98	3300.0
2023-09-01 06:15:00	SPY	ETF	451.98	452.0	451.88	451.9	2440.0
2023-09-01 06:20:00	SPY	ETF	451.9	452.01	451.9	452.0	2385.0
2023-09-01 06:25:00	SPY	ETF	452.03	452.03	451.91	451.94	4274.0
2023-09-01 06:30:00	SPY	ETF	451.9	452.05	451.89	452.05	1740.0
2023-09-01 06:35:00	SPY	ETF	452.09	452.15	452.07	452.1	25552.0
2023-09-01 06:40:00	SPY	ETF	452.14	452.14	452.14	452.14	100.0
2023-09-01 06:45:00	SPY	ETF	452.18	452.54	451.94	451.94	68183.0
2023-09-01 06:50:00	SPY	ETF	452.03	452.3	452.0	452.0	28253.0
2023-09-01 06:55:00	SPY	ETF	451.95	452.05	451.93	452.05	1119.0
2023-09-01 07:00:00	SPY	ETF	451.99	452.12	451.86	452.12	39750.0
2023-09-01 07:05:00	SPY	ETF	452.1	452.12	451.96	451.97	15156.0
2023-09-01 07:10:00	SPY	ETF	451.99	452.11	451.99	452.11	2482.0
2023-09-01 07:15:00	SPY	ETF	452.12	452.28	452.11	452.25	4175.0
2023-09-01 07:20:00	SPY	ETF	452.22	452.25	452.14	452.2	2934.0
2023-09-01 07:25:00	SPY	ETF	452.27	452.28	452.14	452.18	10085.0
2023-09-01 07:30:00	SPY	ETF	452.13	452.13	452.03	452.08	1408.0
2023-09-01 07:35:00	SPY	ETF	452.09	452.14	452.03	452.04	2650.0
2023-09-01 07:40:00	SPY	ETF	452.1	452.32	452.1	452.31	12033.0
2023-09-01 07:45:00	SPY	ETF	452.31	452.31	452.26	452.26	3192.0
2023-09-01 07:50:00	SPY	ETF	452.18	452.18	452.06	452.11	4316.0
2023-09-01 07:55:00	SPY	ETF	452.06	452.08	451.99	452.06	26602.0
2023-09-01 08:00:00	SPY	ETF	450.94	452.3299	450.75	452.2	48962.0
2023-09-01 08:05:00	SPY	ETF	452.19	452.37	452.19	452.33	6796.0
2023-09-01 08:10:00	SPY	ETF	452.3483	452.35	452.12	452.12	8399.0

> showing 50 of 93,827 rows — these rows as CSV

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