PREVIEW / etf_5min / 2023-10-31

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-10-31.parquet
  size:    2.1 MB
  rows:    99,887

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-31 04:00:00	SPY	ETF	414.7	414.85	414.5	414.5	9638.0
2023-10-31 04:05:00	SPY	ETF	414.49	414.72	414.47	414.66	6581.0
2023-10-31 04:10:00	SPY	ETF	414.58	414.97	414.58	414.97	2460.0
2023-10-31 04:15:00	SPY	ETF	414.88	415.09	414.88	414.99	5846.0
2023-10-31 04:20:00	SPY	ETF	415.02	415.17	414.98	415.16	3586.0
2023-10-31 04:25:00	SPY	ETF	415.08	415.38	415.05	415.31	8419.0
2023-10-31 04:30:00	SPY	ETF	415.29	415.37	415.26	415.29	7575.0
2023-10-31 04:35:00	SPY	ETF	415.33	415.64	415.33	415.64	3016.0
2023-10-31 04:40:00	SPY	ETF	415.63	415.76	415.63	415.75	1766.0
2023-10-31 04:45:00	SPY	ETF	415.76	415.92	415.73	415.73	2813.0
2023-10-31 04:50:00	SPY	ETF	415.98	416.22	415.98	416.1	3284.0
2023-10-31 04:55:00	SPY	ETF	416.09	416.26	416.04	416.19	2000.0
2023-10-31 05:00:00	SPY	ETF	416.15	416.2	416.0	416.05	3991.0
2023-10-31 05:05:00	SPY	ETF	416.04	416.04	415.84	415.87	7720.0
2023-10-31 05:10:00	SPY	ETF	415.8	416.09	415.8	415.91	4520.0
2023-10-31 05:15:00	SPY	ETF	415.95	416.04	415.86	416.02	4500.0
2023-10-31 05:20:00	SPY	ETF	415.9	415.9	415.7	415.7	1156.0
2023-10-31 05:25:00	SPY	ETF	415.75	415.75	415.49	415.58	4177.0
2023-10-31 05:30:00	SPY	ETF	415.62	416.18	415.62	416.18	8322.0
2023-10-31 05:35:00	SPY	ETF	416.01	416.18	416.01	416.18	6600.0
2023-10-31 05:40:00	SPY	ETF	416.27	416.3	416.27	416.3	1292.0
2023-10-31 05:45:00	SPY	ETF	416.32	416.33	416.28	416.29	952.0
2023-10-31 05:50:00	SPY	ETF	416.19	416.19	416.15	416.15	300.0
2023-10-31 05:55:00	SPY	ETF	416.2	416.47	416.2	416.36	2692.0
2023-10-31 06:00:00	SPY	ETF	416.48	416.57	416.47	416.57	4542.0
2023-10-31 06:05:00	SPY	ETF	416.6	416.6	416.41	416.41	3957.0
2023-10-31 06:10:00	SPY	ETF	416.34	416.62	416.34	416.62	2081.0
2023-10-31 06:15:00	SPY	ETF	416.59	416.79	416.4	416.79	5861.0
2023-10-31 06:20:00	SPY	ETF	416.8	416.83	416.67	416.75	3200.0
2023-10-31 06:25:00	SPY	ETF	416.57	416.6	416.5	416.5	2945.0
2023-10-31 06:30:00	SPY	ETF	416.5	416.73	416.5	416.73	902.0
2023-10-31 06:35:00	SPY	ETF	416.71	416.71	416.6	416.6	13261.0
2023-10-31 06:40:00	SPY	ETF	416.54	416.54	416.4	416.4	4209.0
2023-10-31 06:45:00	SPY	ETF	416.36	416.62	416.36	416.62	3689.0
2023-10-31 06:50:00	SPY	ETF	416.55	416.58	416.53	416.58	900.0
2023-10-31 06:55:00	SPY	ETF	416.48	416.56	416.48	416.55	2590.0
2023-10-31 07:00:00	SPY	ETF	416.58	416.62	416.49	416.57	7093.0
2023-10-31 07:05:00	SPY	ETF	416.57	416.57	416.36	416.38	5531.0
2023-10-31 07:10:00	SPY	ETF	416.49	416.74	416.49	416.74	6165.0
2023-10-31 07:15:00	SPY	ETF	416.75	416.87	416.69	416.74	13526.0
2023-10-31 07:20:00	SPY	ETF	416.74	416.88	416.71	416.88	7951.0
2023-10-31 07:25:00	SPY	ETF	416.83	416.83	416.78	416.8	2400.0
2023-10-31 07:30:00	SPY	ETF	416.85	416.85	416.7	416.84	13359.0
2023-10-31 07:35:00	SPY	ETF	416.86	416.86	416.62	416.67	18198.0
2023-10-31 07:40:00	SPY	ETF	416.7	416.75	416.54	416.54	3397.0
2023-10-31 07:45:00	SPY	ETF	416.57	416.61	416.5	416.5	6900.0
2023-10-31 07:50:00	SPY	ETF	416.52	416.71	416.44	416.69	9384.0
2023-10-31 07:55:00	SPY	ETF	416.67	416.67	416.48	416.5	10566.0
2023-10-31 08:00:00	SPY	ETF	416.48	416.8704	413.83	416.64	45309.0
2023-10-31 08:05:00	SPY	ETF	416.6	416.66	416.54	416.61	6869.0

> showing 50 of 99,887 rows — these rows as CSV

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