PREVIEW / etf_1min / 2023-07-31

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-07-31.parquet
  size:    4.5 MB
  rows:    255,753

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-07-31 04:00:00	SPY	ETF	456.63	456.77	456.63	456.73	9870.0
2023-07-31 04:01:00	SPY	ETF	456.76	456.77	456.76	456.77	366.0
2023-07-31 04:02:00	SPY	ETF	456.86	456.86	456.7	456.73	1216.0
2023-07-31 04:03:00	SPY	ETF	456.75	456.83	456.75	456.82	1600.0
2023-07-31 04:04:00	SPY	ETF	456.82	456.83	456.77	456.83	1218.0
2023-07-31 04:05:00	SPY	ETF	456.85	456.9	456.82	456.87	400.0
2023-07-31 04:06:00	SPY	ETF	456.92	456.96	456.92	456.96	456.0
2023-07-31 04:07:00	SPY	ETF	456.99	457.0	456.99	456.99	800.0
2023-07-31 04:08:00	SPY	ETF	456.99	456.99	456.99	456.99	136.0
2023-07-31 04:09:00	SPY	ETF	456.97	456.97	456.97	456.97	108.0
2023-07-31 04:10:00	SPY	ETF	457.05	457.05	457.05	457.05	125.0
2023-07-31 04:11:00	SPY	ETF	456.95	456.95	456.95	456.95	200.0
2023-07-31 04:12:00	SPY	ETF	456.95	456.95	456.95	456.95	109.0
2023-07-31 04:13:00	SPY	ETF	456.91	456.91	456.91	456.91	100.0
2023-07-31 04:16:00	SPY	ETF	456.82	456.82	456.8	456.8	525.0
2023-07-31 04:18:00	SPY	ETF	456.93	456.95	456.93	456.95	247.0
2023-07-31 04:19:00	SPY	ETF	456.95	456.95	456.95	456.95	116.0
2023-07-31 04:20:00	SPY	ETF	456.85	456.85	456.85	456.85	254.0
2023-07-31 04:21:00	SPY	ETF	456.85	456.85	456.83	456.83	430.0
2023-07-31 04:26:00	SPY	ETF	456.76	456.76	456.76	456.76	124.0
2023-07-31 04:27:00	SPY	ETF	456.84	456.84	456.84	456.84	210.0
2023-07-31 04:34:00	SPY	ETF	457.07	457.07	457.07	457.07	100.0
2023-07-31 04:37:00	SPY	ETF	457.04	457.04	457.04	457.04	900.0
2023-07-31 04:38:00	SPY	ETF	457.04	457.04	457.04	457.04	1500.0
2023-07-31 04:39:00	SPY	ETF	457.03	457.03	457.03	457.03	125.0
2023-07-31 04:40:00	SPY	ETF	457.03	457.05	457.03	457.05	1000.0
2023-07-31 04:42:00	SPY	ETF	457.15	457.15	457.15	457.15	200.0
2023-07-31 04:44:00	SPY	ETF	457.08	457.08	457.08	457.08	100.0
2023-07-31 04:49:00	SPY	ETF	457.13	457.13	457.13	457.13	125.0
2023-07-31 04:50:00	SPY	ETF	457.1	457.17	457.1	457.17	430.0
2023-07-31 04:51:00	SPY	ETF	457.17	457.17	457.15	457.15	300.0
2023-07-31 04:56:00	SPY	ETF	457.18	457.18	457.18	457.18	500.0
2023-07-31 04:57:00	SPY	ETF	457.26	457.29	457.26	457.29	1304.0
2023-07-31 05:01:00	SPY	ETF	457.32	457.32	457.28	457.28	400.0
2023-07-31 05:02:00	SPY	ETF	457.29	457.32	457.29	457.32	625.0
2023-07-31 05:03:00	SPY	ETF	457.32	457.32	457.32	457.32	500.0
2023-07-31 05:04:00	SPY	ETF	457.31	457.31	457.31	457.31	200.0
2023-07-31 05:05:00	SPY	ETF	457.35	457.36	457.35	457.36	900.0
2023-07-31 05:07:00	SPY	ETF	457.36	457.43	457.36	457.43	499.0
2023-07-31 05:08:00	SPY	ETF	457.42	457.42	457.38	457.41	400.0
2023-07-31 05:09:00	SPY	ETF	457.43	457.43	457.39	457.39	427.0
2023-07-31 05:10:00	SPY	ETF	457.34	457.34	457.34	457.34	100.0
2023-07-31 05:12:00	SPY	ETF	457.28	457.28	457.28	457.28	100.0
2023-07-31 05:14:00	SPY	ETF	457.23	457.23	457.23	457.23	225.0
2023-07-31 05:17:00	SPY	ETF	457.34	457.34	457.34	457.34	100.0
2023-07-31 05:18:00	SPY	ETF	457.27	457.27	457.27	457.27	156.0
2023-07-31 05:19:00	SPY	ETF	457.32	457.32	457.32	457.32	128.0
2023-07-31 05:22:00	SPY	ETF	457.32	457.32	457.32	457.32	302.0
2023-07-31 05:23:00	SPY	ETF	457.32	457.32	457.3	457.3	201.0
2023-07-31 05:28:00	SPY	ETF	457.32	457.32	457.32	457.32	204.0

> showing 50 of 255,753 rows — these rows as CSV

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