PREVIEW / etf_5min / 2024-01-25

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-01-25.parquet
  size:    2.3 MB
  rows:    110,829

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-01-25 04:00:00	SPY	ETF	485.79	485.87	485.76	485.76	1339.0
2024-01-25 04:05:00	SPY	ETF	485.77	485.77	485.63	485.73	2313.0
2024-01-25 04:10:00	SPY	ETF	485.82	485.82	485.75	485.75	702.0
2024-01-25 04:15:00	SPY	ETF	485.68	485.89	485.68	485.77	3484.0
2024-01-25 04:20:00	SPY	ETF	485.83	485.83	485.83	485.83	250.0
2024-01-25 04:25:00	SPY	ETF	485.8	485.8	485.78	485.8	1200.0
2024-01-25 04:30:00	SPY	ETF	485.9	485.9	485.9	485.9	107.0
2024-01-25 04:35:00	SPY	ETF	486.0	486.0	486.0	486.0	237.0
2024-01-25 04:40:00	SPY	ETF	485.99	486.09	485.99	486.09	1600.0
2024-01-25 04:45:00	SPY	ETF	486.05	486.07	486.05	486.07	894.0
2024-01-25 04:55:00	SPY	ETF	485.97	485.97	485.96	485.96	1800.0
2024-01-25 05:00:00	SPY	ETF	485.85	485.85	485.8	485.8	1609.0
2024-01-25 05:05:00	SPY	ETF	485.75	485.75	485.72	485.72	809.0
2024-01-25 05:20:00	SPY	ETF	485.72	485.72	485.72	485.72	123.0
2024-01-25 05:25:00	SPY	ETF	485.69	485.69	485.69	485.69	108.0
2024-01-25 05:30:00	SPY	ETF	485.66	485.66	485.66	485.66	500.0
2024-01-25 05:35:00	SPY	ETF	485.9	485.9	485.89	485.89	200.0
2024-01-25 05:45:00	SPY	ETF	485.84	485.84	485.84	485.84	102.0
2024-01-25 05:50:00	SPY	ETF	485.77	485.77	485.77	485.77	900.0
2024-01-25 06:15:00	SPY	ETF	485.77	485.77	485.77	485.77	498.0
2024-01-25 06:20:00	SPY	ETF	485.94	485.97	485.94	485.97	550.0
2024-01-25 06:30:00	SPY	ETF	485.66	485.7	485.64	485.7	786.0
2024-01-25 06:35:00	SPY	ETF	485.65	485.81	485.65	485.81	405.0
2024-01-25 06:40:00	SPY	ETF	485.85	485.85	485.82	485.83	700.0
2024-01-25 06:45:00	SPY	ETF	485.62	485.87	485.62	485.87	697.0
2024-01-25 06:50:00	SPY	ETF	485.83	485.84	485.82	485.84	2594.0
2024-01-25 06:55:00	SPY	ETF	485.86	486.0	485.85	485.99	4423.0
2024-01-25 07:00:00	SPY	ETF	486.0	486.1	485.97	486.05	9461.0
2024-01-25 07:05:00	SPY	ETF	486.08	486.13	486.08	486.12	4809.0
2024-01-25 07:10:00	SPY	ETF	486.12	486.12	486.08	486.1	1805.0
2024-01-25 07:15:00	SPY	ETF	485.86	485.87	485.82	485.82	2881.0
2024-01-25 07:20:00	SPY	ETF	485.74	485.81	485.71	485.71	2546.0
2024-01-25 07:25:00	SPY	ETF	485.72	485.9	485.69	485.9	3513.0
2024-01-25 07:30:00	SPY	ETF	485.85	485.85	485.82	485.84	800.0
2024-01-25 07:35:00	SPY	ETF	485.8	485.86	485.77	485.86	3229.0
2024-01-25 07:40:00	SPY	ETF	485.81	485.98	485.81	485.98	2348.0
2024-01-25 07:45:00	SPY	ETF	486.01	486.02	485.84	485.89	5002.0
2024-01-25 07:50:00	SPY	ETF	485.84	485.84	485.66	485.66	1420.0
2024-01-25 07:55:00	SPY	ETF	485.58	485.61	485.411	485.411	13480.0
2024-01-25 08:00:00	SPY	ETF	486.04	486.13	485.39	485.7	30677.0
2024-01-25 08:05:00	SPY	ETF	485.55	485.76	485.49	485.58	12049.0
2024-01-25 08:10:00	SPY	ETF	485.6	485.66	485.49	485.66	15955.0
2024-01-25 08:15:00	SPY	ETF	485.66	486.03	485.61	486.03	24845.0
2024-01-25 08:20:00	SPY	ETF	485.91	486.0	485.77	485.97	15659.0
2024-01-25 08:25:00	SPY	ETF	485.96	486.0	485.73	485.94	15014.0
2024-01-25 08:30:00	SPY	ETF	485.97	486.84	485.53	486.84	138851.0
2024-01-25 08:35:00	SPY	ETF	486.81	487.3	486.79	487.06	180635.0
2024-01-25 08:40:00	SPY	ETF	487.09	487.09	486.76	487.08	126802.0
2024-01-25 08:45:00	SPY	ETF	487.1	487.36	487.02	487.2999	51453.0
2024-01-25 08:50:00	SPY	ETF	487.2103	487.4	487.09	487.37	25792.0

> showing 50 of 110,829 rows — these rows as CSV

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