PREVIEW / etf_1min / 2024-08-06

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-08-06.parquet
  size:    5.9 MB
  rows:    348,990

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-08-06 04:00:00	SPY	ETF	523.91	523.91	522.37	522.81	3170.0
2024-08-06 04:01:00	SPY	ETF	522.13	522.29	522.13	522.28	1784.0
2024-08-06 04:02:00	SPY	ETF	522.28	522.28	522.19	522.24	1806.0
2024-08-06 04:03:00	SPY	ETF	522.31	522.58	522.31	522.42	2476.0
2024-08-06 04:04:00	SPY	ETF	522.11	522.2	522.07	522.1	901.0
2024-08-06 04:05:00	SPY	ETF	522.01	522.13	522.0	522.13	1165.0
2024-08-06 04:06:00	SPY	ETF	522.19	522.2	521.88	521.95	3729.0
2024-08-06 04:07:00	SPY	ETF	521.99	521.99	521.99	521.99	300.0
2024-08-06 04:08:00	SPY	ETF	521.99	522.0	521.66	521.66	1887.0
2024-08-06 04:09:00	SPY	ETF	521.6	521.6	521.43	521.57	823.0
2024-08-06 04:10:00	SPY	ETF	521.55	521.77	521.54	521.77	1860.0
2024-08-06 04:11:00	SPY	ETF	521.58	521.6	521.42	521.42	452.0
2024-08-06 04:12:00	SPY	ETF	521.43	521.43	521.31	521.33	425.0
2024-08-06 04:13:00	SPY	ETF	521.58	521.58	521.19	521.19	218.0
2024-08-06 04:14:00	SPY	ETF	521.2	521.24	520.55	520.63	1305.0
2024-08-06 04:15:00	SPY	ETF	520.86	520.9	520.42	520.42	573.0
2024-08-06 04:16:00	SPY	ETF	520.67	520.83	520.67	520.76	1752.0
2024-08-06 04:17:00	SPY	ETF	520.84	520.84	520.84	520.84	245.0
2024-08-06 04:18:00	SPY	ETF	521.14	521.14	521.14	521.14	100.0
2024-08-06 04:19:00	SPY	ETF	520.82	520.89	520.59	520.59	2757.0
2024-08-06 04:21:00	SPY	ETF	520.62	520.77	520.62	520.77	547.0
2024-08-06 04:22:00	SPY	ETF	520.93	520.93	520.92	520.92	200.0
2024-08-06 04:23:00	SPY	ETF	521.14	521.14	521.14	521.14	111.0
2024-08-06 04:25:00	SPY	ETF	521.39	521.56	521.39	521.56	400.0
2024-08-06 04:26:00	SPY	ETF	521.67	521.67	521.62	521.62	457.0
2024-08-06 04:30:00	SPY	ETF	521.94	521.94	521.94	521.94	466.0
2024-08-06 04:31:00	SPY	ETF	521.95	521.95	521.95	521.95	1000.0
2024-08-06 04:32:00	SPY	ETF	521.9	521.9	521.9	521.9	100.0
2024-08-06 04:33:00	SPY	ETF	522.14	522.14	522.14	522.14	160.0
2024-08-06 04:34:00	SPY	ETF	522.05	522.05	521.74	521.79	1910.0
2024-08-06 04:35:00	SPY	ETF	521.77	521.77	521.3	521.3	1341.0
2024-08-06 04:36:00	SPY	ETF	521.31	521.35	521.31	521.35	200.0
2024-08-06 04:37:00	SPY	ETF	521.32	521.32	521.32	521.32	100.0
2024-08-06 04:38:00	SPY	ETF	521.51	521.51	521.51	521.51	298.0
2024-08-06 04:39:00	SPY	ETF	521.24	521.24	521.24	521.24	100.0
2024-08-06 04:41:00	SPY	ETF	521.26	521.26	521.26	521.26	100.0
2024-08-06 04:42:00	SPY	ETF	521.14	521.14	521.14	521.14	109.0
2024-08-06 04:44:00	SPY	ETF	521.61	521.61	521.61	521.61	100.0
2024-08-06 04:46:00	SPY	ETF	521.38	521.38	521.38	521.38	100.0
2024-08-06 04:47:00	SPY	ETF	521.16	521.34	521.16	521.34	419.0
2024-08-06 04:48:00	SPY	ETF	521.56	521.56	521.56	521.56	100.0
2024-08-06 04:49:00	SPY	ETF	521.59	521.59	521.59	521.59	214.0
2024-08-06 04:50:00	SPY	ETF	521.99	522.0	521.97	521.97	700.0
2024-08-06 04:51:00	SPY	ETF	521.97	522.03	521.88	521.91	959.0
2024-08-06 04:52:00	SPY	ETF	522.0	522.0	522.0	522.0	500.0
2024-08-06 04:54:00	SPY	ETF	522.25	522.25	522.25	522.25	100.0
2024-08-06 04:55:00	SPY	ETF	522.31	522.31	521.72	521.72	200.0
2024-08-06 04:56:00	SPY	ETF	521.81	521.82	521.81	521.81	300.0
2024-08-06 04:57:00	SPY	ETF	521.9	521.9	521.9	521.9	100.0
2024-08-06 04:58:00	SPY	ETF	521.43	521.43	521.43	521.43	100.0

> showing 50 of 348,990 rows — these rows as CSV

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