PREVIEW / etf_5min / 2024-07-02

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-07-02.parquet
  size:    2.3 MB
  rows:    112,358

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
2024-07-02 04:00:00	SPY	ETF	543.98	544.28	543.3	543.37	6676.0
2024-07-02 04:05:00	SPY	ETF	543.39	543.59	543.39	543.49	1325.0
2024-07-02 04:10:00	SPY	ETF	543.52	543.58	543.49	543.55	880.0
2024-07-02 04:15:00	SPY	ETF	543.51	543.68	543.49	543.68	1493.0
2024-07-02 04:20:00	SPY	ETF	543.58	543.58	543.38	543.39	1172.0
2024-07-02 04:25:00	SPY	ETF	543.34	543.34	543.24	543.24	785.0
2024-07-02 04:30:00	SPY	ETF	543.0	543.25	542.97	543.23	1400.0
2024-07-02 04:35:00	SPY	ETF	543.33	543.33	543.19	543.21	981.0
2024-07-02 04:40:00	SPY	ETF	543.2	543.2	543.09	543.1	943.0
2024-07-02 04:45:00	SPY	ETF	543.19	543.19	543.19	543.19	100.0
2024-07-02 04:50:00	SPY	ETF	543.2	543.48	543.2	543.42	1500.0
2024-07-02 04:55:00	SPY	ETF	543.47	543.5	543.47	543.49	1100.0
2024-07-02 05:00:00	SPY	ETF	543.48	543.48	543.48	543.48	100.0
2024-07-02 05:10:00	SPY	ETF	543.67	543.67	543.51	543.51	1100.0
2024-07-02 05:15:00	SPY	ETF	543.51	543.6	543.51	543.56	500.0
2024-07-02 05:20:00	SPY	ETF	543.29	543.29	543.09	543.09	800.0
2024-07-02 05:25:00	SPY	ETF	543.27	543.27	543.27	543.27	300.0
2024-07-02 05:30:00	SPY	ETF	543.3	543.3	543.15	543.15	400.0
2024-07-02 05:35:00	SPY	ETF	543.1	543.25	543.1	543.25	700.0
2024-07-02 05:40:00	SPY	ETF	543.05	543.05	543.05	543.05	400.0
2024-07-02 05:45:00	SPY	ETF	543.22	543.25	543.22	543.25	300.0
2024-07-02 05:50:00	SPY	ETF	543.37	543.45	543.37	543.45	600.0
2024-07-02 05:55:00	SPY	ETF	543.46	543.46	543.34	543.34	1185.0
2024-07-02 06:00:00	SPY	ETF	543.35	543.35	543.35	543.35	170.0
2024-07-02 06:05:00	SPY	ETF	543.25	543.26	543.25	543.26	600.0
2024-07-02 06:10:00	SPY	ETF	543.36	543.36	543.36	543.36	400.0
2024-07-02 06:20:00	SPY	ETF	543.34	543.34	543.34	543.34	100.0
2024-07-02 06:25:00	SPY	ETF	543.34	543.34	543.33	543.33	473.0
2024-07-02 06:30:00	SPY	ETF	543.36	543.36	543.36	543.36	400.0
2024-07-02 06:35:00	SPY	ETF	543.27	543.33	543.26	543.33	849.0
2024-07-02 06:40:00	SPY	ETF	543.38	543.62	543.38	543.62	12900.0
2024-07-02 06:45:00	SPY	ETF	543.63	543.63	543.52	543.54	600.0
2024-07-02 06:50:00	SPY	ETF	543.48	543.48	543.47	543.47	200.0
2024-07-02 06:55:00	SPY	ETF	543.47	543.48	543.42	543.42	1151.0
2024-07-02 07:00:00	SPY	ETF	543.46	543.48	543.26	543.29	4106.0
2024-07-02 07:05:00	SPY	ETF	543.25	543.29	543.05	543.05	5460.0
2024-07-02 07:10:00	SPY	ETF	543.06	543.14	542.86	542.97	17651.0
2024-07-02 07:15:00	SPY	ETF	542.99	542.99	542.84	542.89	9992.0
2024-07-02 07:20:00	SPY	ETF	542.86	543.0	542.75	542.94	31778.0
2024-07-02 07:25:00	SPY	ETF	542.97	542.99	542.89	542.9	17693.0
2024-07-02 07:30:00	SPY	ETF	542.88	542.98	542.82	542.98	8471.0
2024-07-02 07:35:00	SPY	ETF	542.92	543.07	542.92	542.95	9346.0
2024-07-02 07:40:00	SPY	ETF	543.0	543.0	542.75	542.75	22560.0
2024-07-02 07:45:00	SPY	ETF	542.74	542.85	542.74	542.81	45842.0
2024-07-02 07:50:00	SPY	ETF	542.79	542.79	542.44	542.64	22466.0
2024-07-02 07:55:00	SPY	ETF	542.86	543.0	542.8	542.97	14034.0
2024-07-02 08:00:00	SPY	ETF	542.93	544.8	542.5097	542.99	31471.0
2024-07-02 08:05:00	SPY	ETF	542.99	543.17	542.84	543.14	20318.0
2024-07-02 08:10:00	SPY	ETF	543.17	543.26	543.09	543.25	6475.0
2024-07-02 08:15:00	SPY	ETF	543.26	543.31	543.24	543.3	4429.0

> showing 50 of 112,358 rows — these rows as CSV

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