PREVIEW / etf_1min / 2024-05-01

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-05-01.parquet
  size:    5.3 MB
  rows:    309,551

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-05-01 04:00:00	SPY	ETF	500.76	501.0	500.65	500.73	2210.0
2024-05-01 04:01:00	SPY	ETF	500.75	500.75	500.74	500.74	788.0
2024-05-01 04:02:00	SPY	ETF	500.74	500.76	500.74	500.76	299.0
2024-05-01 04:03:00	SPY	ETF	500.74	500.74	500.74	500.74	174.0
2024-05-01 04:04:00	SPY	ETF	500.75	500.8	500.75	500.8	300.0
2024-05-01 04:05:00	SPY	ETF	501.0	501.0	501.0	501.0	100.0
2024-05-01 04:06:00	SPY	ETF	501.01	501.01	501.01	501.01	500.0
2024-05-01 04:07:00	SPY	ETF	501.09	501.09	501.04	501.07	1883.0
2024-05-01 04:10:00	SPY	ETF	500.91	500.91	500.89	500.9	1425.0
2024-05-01 04:13:00	SPY	ETF	500.85	500.85	500.85	500.85	100.0
2024-05-01 04:16:00	SPY	ETF	500.85	500.86	500.85	500.86	1812.0
2024-05-01 04:19:00	SPY	ETF	500.71	500.71	500.71	500.71	1637.0
2024-05-01 04:20:00	SPY	ETF	500.67	500.67	500.67	500.67	1000.0
2024-05-01 04:21:00	SPY	ETF	500.8	500.8	500.8	500.8	1000.0
2024-05-01 04:23:00	SPY	ETF	500.85	500.89	500.85	500.89	1846.0
2024-05-01 04:26:00	SPY	ETF	501.0	501.0	501.0	501.0	200.0
2024-05-01 04:29:00	SPY	ETF	500.86	500.86	500.86	500.86	200.0
2024-05-01 04:31:00	SPY	ETF	500.85	500.85	500.85	500.85	397.0
2024-05-01 04:33:00	SPY	ETF	500.9	500.9	500.9	500.9	100.0
2024-05-01 04:38:00	SPY	ETF	500.84	500.84	500.84	500.84	906.0
2024-05-01 04:39:00	SPY	ETF	500.84	500.84	500.84	500.84	1500.0
2024-05-01 04:43:00	SPY	ETF	500.65	500.67	500.64	500.67	805.0
2024-05-01 04:44:00	SPY	ETF	500.66	500.66	500.64	500.64	1496.0
2024-05-01 05:03:00	SPY	ETF	500.75	500.75	500.66	500.66	1645.0
2024-05-01 05:07:00	SPY	ETF	500.56	500.56	500.56	500.56	150.0
2024-05-01 05:08:00	SPY	ETF	500.32	500.32	500.17	500.17	707.0
2024-05-01 05:09:00	SPY	ETF	500.01	500.04	500.0	500.04	725.0
2024-05-01 05:10:00	SPY	ETF	500.06	500.11	500.0	500.0	900.0
2024-05-01 05:15:00	SPY	ETF	500.21	500.21	500.21	500.21	100.0
2024-05-01 05:16:00	SPY	ETF	500.23	500.23	500.23	500.23	100.0
2024-05-01 05:18:00	SPY	ETF	500.23	500.23	500.23	500.23	398.0
2024-05-01 05:19:00	SPY	ETF	500.22	500.22	500.22	500.22	150.0
2024-05-01 05:20:00	SPY	ETF	500.2	500.2	500.19	500.19	300.0
2024-05-01 05:22:00	SPY	ETF	500.09	500.09	500.09	500.09	400.0
2024-05-01 05:24:00	SPY	ETF	500.17	500.21	500.17	500.21	300.0
2024-05-01 05:28:00	SPY	ETF	500.12	500.14	500.12	500.14	1600.0
2024-05-01 05:29:00	SPY	ETF	500.12	500.12	500.0	500.0	400.0
2024-05-01 05:30:00	SPY	ETF	499.97	499.97	499.97	499.97	400.0
2024-05-01 05:31:00	SPY	ETF	499.81	499.81	499.74	499.75	1512.0
2024-05-01 05:32:00	SPY	ETF	499.64	499.64	499.64	499.64	187.0
2024-05-01 05:33:00	SPY	ETF	499.67	499.67	499.67	499.67	100.0
2024-05-01 05:34:00	SPY	ETF	499.71	499.71	499.71	499.71	108.0
2024-05-01 05:36:00	SPY	ETF	499.82	499.82	499.81	499.81	200.0
2024-05-01 05:37:00	SPY	ETF	499.8	499.8	499.8	499.8	1000.0
2024-05-01 05:38:00	SPY	ETF	499.92	499.92	499.86	499.86	300.0
2024-05-01 05:39:00	SPY	ETF	499.82	499.82	499.79	499.82	1000.0
2024-05-01 05:40:00	SPY	ETF	499.84	499.84	499.84	499.84	100.0
2024-05-01 05:41:00	SPY	ETF	499.83	499.83	499.83	499.83	100.0
2024-05-01 05:44:00	SPY	ETF	499.89	499.91	499.89	499.89	2500.0
2024-05-01 05:46:00	SPY	ETF	500.0	500.0	500.0	500.0	1350.0

> showing 50 of 309,551 rows — these rows as CSV

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