PREVIEW / etf_5min / 2024-07-15

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-07-15.parquet
  size:    2.4 MB
  rows:    117,780

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-15 04:00:00	SPY	ETF	560.93	561.6	560.93	561.58	30963.0
2024-07-15 04:05:00	SPY	ETF	561.6	561.71	561.52	561.69	3143.0
2024-07-15 04:10:00	SPY	ETF	561.68	561.77	561.56	561.59	5770.0
2024-07-15 04:15:00	SPY	ETF	561.65	561.68	561.59	561.66	2751.0
2024-07-15 04:20:00	SPY	ETF	561.79	561.8	561.68	561.8	6476.0
2024-07-15 04:25:00	SPY	ETF	561.79	561.8	561.78	561.78	1100.0
2024-07-15 04:30:00	SPY	ETF	561.85	561.85	561.85	561.85	135.0
2024-07-15 04:40:00	SPY	ETF	561.86	561.89	561.79	561.89	811.0
2024-07-15 04:45:00	SPY	ETF	561.88	561.88	561.88	561.88	400.0
2024-07-15 04:50:00	SPY	ETF	561.83	561.9	561.83	561.9	332.0
2024-07-15 04:55:00	SPY	ETF	561.82	561.83	561.82	561.83	900.0
2024-07-15 05:00:00	SPY	ETF	561.87	561.91	561.87	561.91	200.0
2024-07-15 05:05:00	SPY	ETF	561.91	561.93	561.87	561.93	3149.0
2024-07-15 05:10:00	SPY	ETF	561.93	561.93	561.93	561.93	750.0
2024-07-15 05:15:00	SPY	ETF	562.0	562.0	561.96	561.96	997.0
2024-07-15 05:20:00	SPY	ETF	562.0	562.04	561.97	562.04	800.0
2024-07-15 05:25:00	SPY	ETF	562.04	562.05	562.04	562.05	1500.0
2024-07-15 05:30:00	SPY	ETF	562.05	562.05	562.03	562.03	568.0
2024-07-15 05:35:00	SPY	ETF	562.03	562.03	561.96	561.97	6050.0
2024-07-15 05:40:00	SPY	ETF	561.96	562.02	561.96	562.02	7066.0
2024-07-15 05:45:00	SPY	ETF	562.06	562.06	562.03	562.03	500.0
2024-07-15 05:55:00	SPY	ETF	561.93	561.96	561.9	561.9	30865.0
2024-07-15 06:00:00	SPY	ETF	561.77	561.89	561.71	561.89	2896.0
2024-07-15 06:05:00	SPY	ETF	561.88	561.88	561.84	561.84	390.0
2024-07-15 06:10:00	SPY	ETF	561.91	561.91	561.86	561.87	1449.0
2024-07-15 06:20:00	SPY	ETF	561.82	561.91	561.82	561.91	371.0
2024-07-15 06:25:00	SPY	ETF	561.89	561.89	561.89	561.89	100.0
2024-07-15 06:30:00	SPY	ETF	561.9	561.91	561.86	561.86	5178.0
2024-07-15 06:35:00	SPY	ETF	561.85	561.85	561.82	561.82	606.0
2024-07-15 06:40:00	SPY	ETF	561.9	561.93	561.88	561.88	5590.0
2024-07-15 06:45:00	SPY	ETF	561.9	561.93	561.9	561.93	297.0
2024-07-15 06:50:00	SPY	ETF	561.94	561.94	561.94	561.94	542.0
2024-07-15 06:55:00	SPY	ETF	561.9	561.95	561.9	561.95	24663.0
2024-07-15 07:00:00	SPY	ETF	561.94	562.04	561.79	561.99	47514.0
2024-07-15 07:05:00	SPY	ETF	562.05	562.08	561.9	562.0	37407.0
2024-07-15 07:10:00	SPY	ETF	562.0	562.11	562.0	562.01	9780.0
2024-07-15 07:15:00	SPY	ETF	562.0	562.14	562.0	562.14	9349.0
2024-07-15 07:20:00	SPY	ETF	562.17	562.19	562.05	562.11	14197.0
2024-07-15 07:25:00	SPY	ETF	562.2	562.34	562.2	562.31	27498.0
2024-07-15 07:30:00	SPY	ETF	562.3	562.51	562.3	562.36	7121.0
2024-07-15 07:35:00	SPY	ETF	562.31	562.31	562.08	562.08	7614.0
2024-07-15 07:40:00	SPY	ETF	562.02	562.02	561.79	561.86	10068.0
2024-07-15 07:45:00	SPY	ETF	561.94	562.12	561.94	562.05	19310.0
2024-07-15 07:50:00	SPY	ETF	562.08	562.09	561.95	562.04	25928.0
2024-07-15 07:55:00	SPY	ETF	561.98	561.98	561.849	561.85	4411.0
2024-07-15 08:00:00	SPY	ETF	561.9417	562.4982	560.41	561.16	51356.0
2024-07-15 08:05:00	SPY	ETF	561.75	561.89	560.65	561.89	7459.0
2024-07-15 08:10:00	SPY	ETF	561.83	562.06	561.83	562.04	25532.0
2024-07-15 08:15:00	SPY	ETF	562.04	562.04	561.9	561.91	4129.0
2024-07-15 08:20:00	SPY	ETF	561.94	562.0003	561.85	561.87	23446.0

> showing 50 of 117,780 rows — these rows as CSV

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