PREVIEW / etf_1min / 2024-07-15

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-07-15.parquet
  size:    5.4 MB
  rows:    307,789

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.51	560.93	561.45	9042.0
2024-07-15 04:01:00	SPY	ETF	561.58	561.6	561.52	561.52	7726.0
2024-07-15 04:02:00	SPY	ETF	561.55	561.56	561.48	561.5	12893.0
2024-07-15 04:03:00	SPY	ETF	561.49	561.53	561.49	561.53	1100.0
2024-07-15 04:04:00	SPY	ETF	561.58	561.58	561.58	561.58	202.0
2024-07-15 04:05:00	SPY	ETF	561.6	561.6	561.54	561.54	258.0
2024-07-15 04:06:00	SPY	ETF	561.55	561.55	561.52	561.52	385.0
2024-07-15 04:07:00	SPY	ETF	561.54	561.55	561.54	561.55	1000.0
2024-07-15 04:08:00	SPY	ETF	561.64	561.69	561.64	561.69	700.0
2024-07-15 04:09:00	SPY	ETF	561.68	561.71	561.68	561.69	800.0
2024-07-15 04:10:00	SPY	ETF	561.68	561.77	561.68	561.7	1172.0
2024-07-15 04:11:00	SPY	ETF	561.71	561.72	561.65	561.66	900.0
2024-07-15 04:12:00	SPY	ETF	561.67	561.67	561.65	561.65	1200.0
2024-07-15 04:13:00	SPY	ETF	561.61	561.61	561.58	561.58	1798.0
2024-07-15 04:14:00	SPY	ETF	561.56	561.59	561.56	561.59	700.0
2024-07-15 04:15:00	SPY	ETF	561.65	561.65	561.61	561.61	400.0
2024-07-15 04:16:00	SPY	ETF	561.59	561.59	561.59	561.59	1400.0
2024-07-15 04:17:00	SPY	ETF	561.59	561.68	561.59	561.68	750.0
2024-07-15 04:18:00	SPY	ETF	561.66	561.66	561.66	561.66	201.0
2024-07-15 04:20:00	SPY	ETF	561.79	561.79	561.79	561.79	900.0
2024-07-15 04:21:00	SPY	ETF	561.73	561.73	561.73	561.73	101.0
2024-07-15 04:22:00	SPY	ETF	561.68	561.68	561.68	561.68	1975.0
2024-07-15 04:23:00	SPY	ETF	561.76	561.8	561.74	561.8	3500.0
2024-07-15 04:25:00	SPY	ETF	561.79	561.8	561.79	561.8	700.0
2024-07-15 04:26:00	SPY	ETF	561.78	561.78	561.78	561.78	400.0
2024-07-15 04:32:00	SPY	ETF	561.85	561.85	561.85	561.85	135.0
2024-07-15 04:40:00	SPY	ETF	561.86	561.86	561.86	561.86	500.0
2024-07-15 04:41:00	SPY	ETF	561.79	561.79	561.79	561.79	100.0
2024-07-15 04:42:00	SPY	ETF	561.87	561.87	561.87	561.87	101.0
2024-07-15 04:44:00	SPY	ETF	561.89	561.89	561.89	561.89	110.0
2024-07-15 04:46:00	SPY	ETF	561.88	561.88	561.88	561.88	400.0
2024-07-15 04:51:00	SPY	ETF	561.83	561.83	561.83	561.83	132.0
2024-07-15 04:52:00	SPY	ETF	561.9	561.9	561.9	561.9	200.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:07:00	SPY	ETF	561.91	561.91	561.91	561.91	700.0
2024-07-15 05:08:00	SPY	ETF	561.9	561.9	561.9	561.9	150.0
2024-07-15 05:09:00	SPY	ETF	561.88	561.93	561.87	561.93	2299.0
2024-07-15 05:12:00	SPY	ETF	561.93	561.93	561.93	561.93	750.0
2024-07-15 05:18:00	SPY	ETF	562.0	562.0	562.0	562.0	107.0
2024-07-15 05:19:00	SPY	ETF	562.0	562.0	561.96	561.96	890.0
2024-07-15 05:20:00	SPY	ETF	562.0	562.0	561.97	561.97	400.0
2024-07-15 05:23:00	SPY	ETF	562.04	562.04	562.04	562.04	400.0
2024-07-15 05:25:00	SPY	ETF	562.04	562.05	562.04	562.05	1500.0
2024-07-15 05:32:00	SPY	ETF	562.05	562.05	562.05	562.05	168.0
2024-07-15 05:34:00	SPY	ETF	562.03	562.03	562.03	562.03	400.0
2024-07-15 05:35:00	SPY	ETF	562.03	562.03	562.03	562.03	150.0
2024-07-15 05:39:00	SPY	ETF	561.96	561.98	561.96	561.97	5900.0
2024-07-15 05:40:00	SPY	ETF	561.96	561.99	561.96	561.99	6000.0
2024-07-15 05:41:00	SPY	ETF	561.96	561.96	561.96	561.96	266.0

> showing 50 of 307,789 rows — these rows as CSV

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