PREVIEW / etf_1min / 2023-09-27

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-09-27.parquet
  size:    4.9 MB
  rows:    277,864

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
2023-09-27 04:00:00	SPY	ETF	428.0	428.01	427.41	427.98	5583.0
2023-09-27 04:01:00	SPY	ETF	428.0	428.03	428.0	428.03	971.0
2023-09-27 04:02:00	SPY	ETF	428.02	428.03	427.99	427.99	2500.0
2023-09-27 04:03:00	SPY	ETF	428.0	428.01	428.0	428.0	2299.0
2023-09-27 04:04:00	SPY	ETF	428.04	428.07	428.03	428.03	3475.0
2023-09-27 04:05:00	SPY	ETF	428.0	428.05	428.0	428.05	600.0
2023-09-27 04:07:00	SPY	ETF	428.05	428.05	428.05	428.05	100.0
2023-09-27 04:09:00	SPY	ETF	428.03	428.03	428.03	428.03	375.0
2023-09-27 04:10:00	SPY	ETF	428.1	428.1	428.1	428.1	314.0
2023-09-27 04:12:00	SPY	ETF	427.93	427.93	427.93	427.93	178.0
2023-09-27 04:13:00	SPY	ETF	427.92	427.92	427.92	427.92	156.0
2023-09-27 04:14:00	SPY	ETF	427.9	427.9	427.88	427.88	313.0
2023-09-27 04:16:00	SPY	ETF	427.93	427.93	427.93	427.93	113.0
2023-09-27 04:17:00	SPY	ETF	427.93	427.93	427.9	427.93	500.0
2023-09-27 04:21:00	SPY	ETF	427.83	427.83	427.83	427.83	100.0
2023-09-27 04:22:00	SPY	ETF	427.85	427.94	427.85	427.94	378.0
2023-09-27 04:27:00	SPY	ETF	427.78	427.78	427.78	427.78	100.0
2023-09-27 04:30:00	SPY	ETF	427.8	427.8	427.78	427.78	1000.0
2023-09-27 04:31:00	SPY	ETF	427.82	427.82	427.82	427.82	200.0
2023-09-27 04:32:00	SPY	ETF	427.86	427.86	427.86	427.86	125.0
2023-09-27 04:33:00	SPY	ETF	427.85	427.86	427.85	427.86	739.0
2023-09-27 04:34:00	SPY	ETF	427.98	427.98	427.98	427.98	108.0
2023-09-27 04:36:00	SPY	ETF	427.85	427.85	427.85	427.85	470.0
2023-09-27 04:37:00	SPY	ETF	427.79	427.79	427.72	427.77	2101.0
2023-09-27 04:40:00	SPY	ETF	427.87	427.87	427.8	427.8	397.0
2023-09-27 04:41:00	SPY	ETF	427.79	427.79	427.79	427.79	100.0
2023-09-27 04:42:00	SPY	ETF	427.74	427.74	427.74	427.74	100.0
2023-09-27 04:43:00	SPY	ETF	427.8	427.8	427.79	427.79	300.0
2023-09-27 04:46:00	SPY	ETF	427.86	427.86	427.86	427.86	100.0
2023-09-27 04:47:00	SPY	ETF	427.9	427.9	427.9	427.9	400.0
2023-09-27 04:48:00	SPY	ETF	427.9	427.91	427.9	427.91	1000.0
2023-09-27 04:49:00	SPY	ETF	427.87	427.87	427.87	427.87	100.0
2023-09-27 04:51:00	SPY	ETF	427.87	427.87	427.87	427.87	400.0
2023-09-27 04:54:00	SPY	ETF	427.75	427.75	427.75	427.75	125.0
2023-09-27 04:55:00	SPY	ETF	427.8	427.81	427.8	427.8	1500.0
2023-09-27 04:56:00	SPY	ETF	427.81	427.81	427.81	427.81	100.0
2023-09-27 04:58:00	SPY	ETF	427.76	427.76	427.76	427.76	800.0
2023-09-27 05:00:00	SPY	ETF	427.89	427.89	427.78	427.78	1600.0
2023-09-27 05:08:00	SPY	ETF	427.71	427.74	427.71	427.74	3000.0
2023-09-27 05:09:00	SPY	ETF	427.83	427.84	427.82	427.82	3100.0
2023-09-27 05:11:00	SPY	ETF	427.69	427.69	427.69	427.69	200.0
2023-09-27 05:12:00	SPY	ETF	427.79	427.79	427.79	427.79	100.0
2023-09-27 05:14:00	SPY	ETF	427.84	427.84	427.84	427.84	140.0
2023-09-27 05:16:00	SPY	ETF	427.78	427.78	427.78	427.78	100.0
2023-09-27 05:17:00	SPY	ETF	427.78	427.78	427.78	427.78	109.0
2023-09-27 05:19:00	SPY	ETF	427.78	427.78	427.78	427.78	399.0
2023-09-27 05:20:00	SPY	ETF	427.82	427.82	427.77	427.77	850.0
2023-09-27 05:21:00	SPY	ETF	427.69	427.69	427.69	427.69	200.0
2023-09-27 05:22:00	SPY	ETF	427.72	427.74	427.72	427.72	2200.0
2023-09-27 05:23:00	SPY	ETF	427.71	427.71	427.71	427.71	850.0

> showing 50 of 277,864 rows — these rows as CSV

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