PREVIEW / etf_1min / 2023-08-24

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-08-24.parquet
  size:    4.6 MB
  rows:    257,453

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-08-24 04:00:00	SPY	ETF	445.8	445.85	445.78	445.85	1200.0
2023-08-24 04:01:00	SPY	ETF	445.9	445.96	445.86	445.96	1450.0
2023-08-24 04:02:00	SPY	ETF	446.0	446.0	446.0	446.0	227.0
2023-08-24 04:03:00	SPY	ETF	446.08	446.23	446.08	446.22	2013.0
2023-08-24 04:04:00	SPY	ETF	446.27	446.32	446.24	446.24	1264.0
2023-08-24 04:05:00	SPY	ETF	446.33	446.34	446.32	446.34	1234.0
2023-08-24 04:06:00	SPY	ETF	446.32	446.36	446.26	446.36	1112.0
2023-08-24 04:07:00	SPY	ETF	446.3	446.3	446.3	446.3	131.0
2023-08-24 04:08:00	SPY	ETF	446.23	446.24	446.23	446.24	519.0
2023-08-24 04:09:00	SPY	ETF	446.02	446.02	446.02	446.02	123.0
2023-08-24 04:10:00	SPY	ETF	446.03	446.03	446.01	446.01	400.0
2023-08-24 04:11:00	SPY	ETF	445.87	445.92	445.87	445.92	212.0
2023-08-24 04:12:00	SPY	ETF	445.96	446.03	445.96	446.03	360.0
2023-08-24 04:13:00	SPY	ETF	445.92	445.93	445.88	445.9	5257.0
2023-08-24 04:14:00	SPY	ETF	445.85	445.85	445.85	445.85	163.0
2023-08-24 04:15:00	SPY	ETF	445.81	445.83	445.75	445.76	796.0
2023-08-24 04:16:00	SPY	ETF	445.8	445.8	445.78	445.78	711.0
2023-08-24 04:17:00	SPY	ETF	445.84	445.84	445.84	445.84	100.0
2023-08-24 04:18:00	SPY	ETF	445.88	445.93	445.88	445.93	1325.0
2023-08-24 04:19:00	SPY	ETF	445.92	445.93	445.92	445.93	259.0
2023-08-24 04:20:00	SPY	ETF	445.91	445.97	445.91	445.94	2725.0
2023-08-24 04:21:00	SPY	ETF	445.91	445.92	445.87	445.92	908.0
2023-08-24 04:24:00	SPY	ETF	446.12	446.12	446.12	446.12	100.0
2023-08-24 04:26:00	SPY	ETF	446.14	446.14	446.14	446.14	500.0
2023-08-24 04:28:00	SPY	ETF	446.24	446.24	446.24	446.24	100.0
2023-08-24 04:29:00	SPY	ETF	446.2	446.2	446.13	446.13	6221.0
2023-08-24 04:30:00	SPY	ETF	446.12	446.12	446.12	446.12	134.0
2023-08-24 04:31:00	SPY	ETF	446.13	446.13	446.07	446.07	813.0
2023-08-24 04:32:00	SPY	ETF	446.01	446.01	446.0	446.0	1000.0
2023-08-24 04:35:00	SPY	ETF	446.0	446.0	445.97	445.97	1245.0
2023-08-24 04:36:00	SPY	ETF	446.0	446.0	446.0	446.0	175.0
2023-08-24 04:38:00	SPY	ETF	446.0	446.0	445.81	445.81	403.0
2023-08-24 04:40:00	SPY	ETF	445.79	445.79	445.79	445.79	300.0
2023-08-24 04:41:00	SPY	ETF	445.76	445.81	445.76	445.81	335.0
2023-08-24 04:42:00	SPY	ETF	445.81	445.81	445.8	445.8	3375.0
2023-08-24 04:44:00	SPY	ETF	445.79	445.79	445.79	445.79	150.0
2023-08-24 04:48:00	SPY	ETF	445.9	445.9	445.82	445.82	500.0
2023-08-24 04:52:00	SPY	ETF	445.69	445.69	445.69	445.69	100.0
2023-08-24 04:53:00	SPY	ETF	445.66	445.66	445.64	445.65	3464.0
2023-08-24 04:54:00	SPY	ETF	445.71	445.71	445.71	445.71	900.0
2023-08-24 04:55:00	SPY	ETF	445.7	445.7	445.7	445.7	225.0
2023-08-24 04:56:00	SPY	ETF	445.7	445.7	445.68	445.68	999.0
2023-08-24 04:57:00	SPY	ETF	445.74	445.74	445.74	445.74	225.0
2023-08-24 04:58:00	SPY	ETF	445.72	445.72	445.72	445.72	100.0
2023-08-24 04:59:00	SPY	ETF	445.71	445.71	445.68	445.69	625.0
2023-08-24 05:00:00	SPY	ETF	445.77	445.77	445.77	445.77	700.0
2023-08-24 05:01:00	SPY	ETF	445.79	445.79	445.77	445.77	950.0
2023-08-24 05:02:00	SPY	ETF	445.75	445.75	445.75	445.75	100.0
2023-08-24 05:03:00	SPY	ETF	445.75	445.77	445.72	445.72	2550.0
2023-08-24 05:04:00	SPY	ETF	445.68	445.68	445.6	445.6	1250.0

> showing 50 of 257,453 rows — these rows as CSV

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