PREVIEW / etf_5min / 2023-10-09

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-10-09.parquet
  size:    2.0 MB
  rows:    95,337

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-10-09 04:00:00	SPY	ETF	426.08	426.91	425.97	426.12	17510.0
2023-10-09 04:05:00	SPY	ETF	426.11	426.15	425.95	426.05	8940.0
2023-10-09 04:10:00	SPY	ETF	426.2	426.41	426.15	426.28	6566.0
2023-10-09 04:15:00	SPY	ETF	426.34	426.34	426.12	426.22	6100.0
2023-10-09 04:20:00	SPY	ETF	426.32	426.42	425.95	425.95	6499.0
2023-10-09 04:25:00	SPY	ETF	426.0	426.16	425.96	425.98	4611.0
2023-10-09 04:30:00	SPY	ETF	426.03	426.5	426.03	426.39	1865.0
2023-10-09 04:35:00	SPY	ETF	426.23	426.67	426.23	426.62	1789.0
2023-10-09 04:40:00	SPY	ETF	426.76	426.92	426.72	426.8	5972.0
2023-10-09 04:45:00	SPY	ETF	426.84	426.9	426.81	426.9	2999.0
2023-10-09 04:50:00	SPY	ETF	426.91	427.08	426.9	427.07	4866.0
2023-10-09 04:55:00	SPY	ETF	427.105	427.15	427.03	427.08	1956.0
2023-10-09 05:00:00	SPY	ETF	427.03	427.17	426.96	427.17	4647.0
2023-10-09 05:05:00	SPY	ETF	427.36	427.57	427.28	427.28	4511.0
2023-10-09 05:10:00	SPY	ETF	427.31	427.31	427.09	427.13	1496.0
2023-10-09 05:15:00	SPY	ETF	427.21	427.5	427.21	427.5	5475.0
2023-10-09 05:20:00	SPY	ETF	427.49	427.53	427.48	427.53	1217.0
2023-10-09 05:25:00	SPY	ETF	427.6	427.61	427.46	427.46	4618.0
2023-10-09 05:30:00	SPY	ETF	427.37	427.47	427.32	427.32	6275.0
2023-10-09 05:35:00	SPY	ETF	427.41	427.48	427.15	427.15	8270.0
2023-10-09 05:40:00	SPY	ETF	427.06	427.11	427.01	427.11	1615.0
2023-10-09 05:45:00	SPY	ETF	427.04	427.04	426.99	426.99	2600.0
2023-10-09 05:50:00	SPY	ETF	427.01	427.09	426.96	427.09	592.0
2023-10-09 05:55:00	SPY	ETF	427.0	427.14	427.0	427.06	7122.0
2023-10-09 06:00:00	SPY	ETF	427.13	427.34	427.13	427.3	775.0
2023-10-09 06:05:00	SPY	ETF	427.33	427.41	427.22	427.36	1699.0
2023-10-09 06:10:00	SPY	ETF	427.36	427.46	427.36	427.46	3567.0
2023-10-09 06:15:00	SPY	ETF	427.41	427.59	427.39	427.39	8712.0
2023-10-09 06:20:00	SPY	ETF	427.29	427.5	427.29	427.48	717.0
2023-10-09 06:25:00	SPY	ETF	427.32	427.36	427.12	427.19	2047.0
2023-10-09 06:30:00	SPY	ETF	427.16	427.16	427.15	427.15	500.0
2023-10-09 06:35:00	SPY	ETF	427.25	427.38	427.25	427.33	2400.0
2023-10-09 06:40:00	SPY	ETF	427.18	427.21	427.16	427.16	1784.0
2023-10-09 06:45:00	SPY	ETF	427.25	427.25	427.2	427.25	2400.0
2023-10-09 06:50:00	SPY	ETF	427.26	427.27	427.12	427.15	5817.0
2023-10-09 06:55:00	SPY	ETF	427.2	427.2	426.89	426.89	12438.0
2023-10-09 07:00:00	SPY	ETF	427.0	427.14	426.99	427.05	45908.0
2023-10-09 07:05:00	SPY	ETF	427.0	427.0	426.61	426.82	23479.0
2023-10-09 07:10:00	SPY	ETF	426.851	426.97	426.82	426.82	14455.0
2023-10-09 07:15:00	SPY	ETF	426.85	426.91	426.66	426.67	4009.0
2023-10-09 07:20:00	SPY	ETF	426.91	427.06	426.85	426.88	4444.0
2023-10-09 07:25:00	SPY	ETF	426.88	426.88	426.73	426.77	3510.0
2023-10-09 07:30:00	SPY	ETF	426.77	426.79	426.69	426.75	3154.0
2023-10-09 07:35:00	SPY	ETF	426.75	426.87	426.74	426.83	30247.0
2023-10-09 07:40:00	SPY	ETF	426.82	426.86	426.43	426.56	15965.0
2023-10-09 07:45:00	SPY	ETF	426.53	426.62	426.47	426.6	19032.0
2023-10-09 07:50:00	SPY	ETF	426.54	426.86	426.54	426.779	46070.0
2023-10-09 07:55:00	SPY	ETF	426.78	426.8	426.64	426.8	12050.0
2023-10-09 08:00:00	SPY	ETF	427.0608	427.6196	425.5	426.76	78476.0
2023-10-09 08:05:00	SPY	ETF	426.8	427.17	426.78	427.14	42852.0

> showing 50 of 95,337 rows — these rows as CSV

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