PREVIEW / etf_1min / 2023-11-01

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-11-01.parquet
  size:    5.0 MB
  rows:    285,575

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-11-01 04:00:00	SPY	ETF	417.5	417.5	417.41	417.41	531.0
2023-11-01 04:01:00	SPY	ETF	417.41	417.41	417.41	417.41	100.0
2023-11-01 04:02:00	SPY	ETF	417.38	417.38	417.35	417.35	300.0
2023-11-01 04:03:00	SPY	ETF	417.29	417.32	417.29	417.32	900.0
2023-11-01 04:05:00	SPY	ETF	417.48	417.48	417.42	417.44	1405.0
2023-11-01 04:06:00	SPY	ETF	417.34	417.43	417.34	417.43	421.0
2023-11-01 04:08:00	SPY	ETF	417.47	417.6	417.47	417.6	721.0
2023-11-01 04:09:00	SPY	ETF	417.57	417.58	417.57	417.58	327.0
2023-11-01 04:12:00	SPY	ETF	417.48	417.48	417.48	417.48	100.0
2023-11-01 04:13:00	SPY	ETF	417.61	417.68	417.61	417.68	310.0
2023-11-01 04:14:00	SPY	ETF	417.73	417.8	417.72	417.72	1017.0
2023-11-01 04:15:00	SPY	ETF	417.61	417.61	417.61	417.61	100.0
2023-11-01 04:16:00	SPY	ETF	417.46	417.46	417.46	417.46	114.0
2023-11-01 04:19:00	SPY	ETF	417.3	417.3	417.3	417.3	200.0
2023-11-01 04:25:00	SPY	ETF	417.33	417.33	417.32	417.32	600.0
2023-11-01 04:27:00	SPY	ETF	417.28	417.28	417.23	417.24	5000.0
2023-11-01 04:29:00	SPY	ETF	416.95	416.95	416.95	416.95	258.0
2023-11-01 04:31:00	SPY	ETF	417.0	417.0	417.0	417.0	100.0
2023-11-01 04:32:00	SPY	ETF	417.15	417.15	417.15	417.15	234.0
2023-11-01 04:33:00	SPY	ETF	417.24	417.32	417.24	417.32	1508.0
2023-11-01 04:34:00	SPY	ETF	417.31	417.31	417.26	417.27	1353.0
2023-11-01 04:37:00	SPY	ETF	417.23	417.23	417.23	417.23	100.0
2023-11-01 04:40:00	SPY	ETF	417.26	417.26	417.23	417.23	200.0
2023-11-01 04:41:00	SPY	ETF	417.17	417.17	417.17	417.17	139.0
2023-11-01 04:43:00	SPY	ETF	416.91	416.91	416.91	416.91	249.0
2023-11-01 04:47:00	SPY	ETF	416.86	416.86	416.86	416.86	150.0
2023-11-01 04:48:00	SPY	ETF	416.89	416.89	416.89	416.89	141.0
2023-11-01 04:50:00	SPY	ETF	416.99	416.99	416.99	416.99	153.0
2023-11-01 04:51:00	SPY	ETF	416.93	416.93	416.93	416.93	100.0
2023-11-01 04:52:00	SPY	ETF	416.84	416.84	416.84	416.84	100.0
2023-11-01 04:54:00	SPY	ETF	416.75	416.75	416.65	416.65	300.0
2023-11-01 04:56:00	SPY	ETF	416.77	416.77	416.77	416.77	454.0
2023-11-01 04:57:00	SPY	ETF	416.81	416.81	416.81	416.81	500.0
2023-11-01 04:58:00	SPY	ETF	416.82	416.82	416.82	416.82	100.0
2023-11-01 04:59:00	SPY	ETF	416.88	416.88	416.88	416.88	200.0
2023-11-01 05:00:00	SPY	ETF	416.89	416.91	416.83	416.83	600.0
2023-11-01 05:01:00	SPY	ETF	416.8	416.8	416.8	416.8	100.0
2023-11-01 05:03:00	SPY	ETF	417.0	417.05	417.0	417.05	800.0
2023-11-01 05:05:00	SPY	ETF	417.14	417.14	417.14	417.14	200.0
2023-11-01 05:06:00	SPY	ETF	417.15	417.2	417.15	417.2	900.0
2023-11-01 05:12:00	SPY	ETF	417.11	417.11	417.11	417.11	400.0
2023-11-01 05:14:00	SPY	ETF	417.07	417.07	417.07	417.07	700.0
2023-11-01 05:15:00	SPY	ETF	416.94	416.94	416.94	416.94	830.0
2023-11-01 05:20:00	SPY	ETF	416.77	416.77	416.77	416.77	100.0
2023-11-01 05:23:00	SPY	ETF	416.7	416.7	416.7	416.7	1380.0
2023-11-01 05:24:00	SPY	ETF	416.67	416.67	416.65	416.65	750.0
2023-11-01 05:32:00	SPY	ETF	416.93	416.93	416.93	416.93	168.0
2023-11-01 05:35:00	SPY	ETF	416.68	416.68	416.68	416.68	100.0
2023-11-01 05:37:00	SPY	ETF	416.82	416.82	416.82	416.82	100.0
2023-11-01 05:41:00	SPY	ETF	416.77	416.77	416.77	416.77	388.0

> showing 50 of 285,575 rows — these rows as CSV

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