PREVIEW / etf_1min / 2023-08-07

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-08-07.parquet
  size:    4.4 MB
  rows:    251,532

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-07 04:00:00	SPY	ETF	448.94	449.08	448.45	449.01	9565.0
2023-08-07 04:01:00	SPY	ETF	449.03	449.03	448.94	448.98	800.0
2023-08-07 04:02:00	SPY	ETF	448.92	448.93	448.9	448.93	1189.0
2023-08-07 04:03:00	SPY	ETF	449.0	449.01	449.0	449.01	834.0
2023-08-07 04:04:00	SPY	ETF	448.84	448.84	448.84	448.84	100.0
2023-08-07 04:05:00	SPY	ETF	448.81	448.91	448.78	448.91	12087.0
2023-08-07 04:06:00	SPY	ETF	448.94	448.96	448.91	448.92	10410.0
2023-08-07 04:07:00	SPY	ETF	448.95	448.96	448.87	448.87	8830.0
2023-08-07 04:08:00	SPY	ETF	448.8	448.87	448.8	448.8	600.0
2023-08-07 04:10:00	SPY	ETF	448.79	448.79	448.79	448.79	200.0
2023-08-07 04:11:00	SPY	ETF	448.89	448.89	448.89	448.89	139.0
2023-08-07 04:13:00	SPY	ETF	448.78	448.78	448.78	448.78	182.0
2023-08-07 04:16:00	SPY	ETF	448.75	448.75	448.74	448.74	225.0
2023-08-07 04:18:00	SPY	ETF	448.75	448.75	448.75	448.75	400.0
2023-08-07 04:20:00	SPY	ETF	448.76	448.85	448.75	448.85	2200.0
2023-08-07 04:21:00	SPY	ETF	448.77	448.77	448.77	448.77	164.0
2023-08-07 04:23:00	SPY	ETF	448.66	448.66	448.63	448.63	3600.0
2023-08-07 04:24:00	SPY	ETF	448.63	448.63	448.63	448.63	300.0
2023-08-07 04:25:00	SPY	ETF	448.56	448.6	448.55	448.55	500.0
2023-08-07 04:27:00	SPY	ETF	448.62	448.62	448.62	448.62	180.0
2023-08-07 04:28:00	SPY	ETF	448.55	448.55	448.55	448.55	200.0
2023-08-07 04:29:00	SPY	ETF	448.52	448.52	448.52	448.52	200.0
2023-08-07 04:30:00	SPY	ETF	448.5	448.54	448.5	448.54	223.0
2023-08-07 04:31:00	SPY	ETF	448.54	448.54	448.54	448.54	200.0
2023-08-07 04:33:00	SPY	ETF	448.4	448.4	448.33	448.33	364.0
2023-08-07 04:43:00	SPY	ETF	448.03	448.03	448.03	448.03	400.0
2023-08-07 04:44:00	SPY	ETF	448.01	448.01	448.0	448.0	400.0
2023-08-07 04:45:00	SPY	ETF	448.05	448.05	448.05	448.05	100.0
2023-08-07 04:47:00	SPY	ETF	447.95	447.95	447.95	447.95	100.0
2023-08-07 04:48:00	SPY	ETF	447.86	447.86	447.86	447.86	700.0
2023-08-07 04:50:00	SPY	ETF	447.76	447.76	447.76	447.76	270.0
2023-08-07 04:51:00	SPY	ETF	447.94	448.02	447.94	448.02	943.0
2023-08-07 04:52:00	SPY	ETF	448.1	448.1	448.1	448.1	300.0
2023-08-07 04:54:00	SPY	ETF	448.25	448.25	448.25	448.25	100.0
2023-08-07 04:56:00	SPY	ETF	448.21	448.25	448.21	448.25	400.0
2023-08-07 04:59:00	SPY	ETF	448.11	448.14	448.11	448.14	400.0
2023-08-07 05:00:00	SPY	ETF	448.14	448.14	448.14	448.14	100.0
2023-08-07 05:01:00	SPY	ETF	448.0	448.0	447.91	447.91	1214.0
2023-08-07 05:03:00	SPY	ETF	447.95	447.96	447.95	447.96	318.0
2023-08-07 05:05:00	SPY	ETF	448.03	448.03	448.03	448.03	1371.0
2023-08-07 05:12:00	SPY	ETF	448.06	448.06	448.06	448.06	2000.0
2023-08-07 05:13:00	SPY	ETF	447.93	447.93	447.93	447.93	2000.0
2023-08-07 05:14:00	SPY	ETF	447.94	447.94	447.94	447.94	100.0
2023-08-07 05:16:00	SPY	ETF	448.01	448.01	448.01	448.01	100.0
2023-08-07 05:17:00	SPY	ETF	448.1	448.11	448.1	448.11	500.0
2023-08-07 05:18:00	SPY	ETF	448.12	448.12	448.12	448.12	400.0
2023-08-07 05:19:00	SPY	ETF	448.11	448.11	448.11	448.11	200.0
2023-08-07 05:22:00	SPY	ETF	448.08	448.08	448.08	448.08	500.0
2023-08-07 05:24:00	SPY	ETF	448.1	448.1	448.1	448.1	100.0
2023-08-07 05:25:00	SPY	ETF	448.22	448.22	448.22	448.22	220.0

> showing 50 of 251,532 rows — these rows as CSV

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