PREVIEW / etf_5min / 2023-05-19

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-19.parquet
  size:    1.9 MB
  rows:    92,984

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-05-19 04:00:00	SPY	ETF	419.74	419.9	419.68	419.73	13531.0
2023-05-19 04:05:00	SPY	ETF	419.8	419.82	419.74	419.74	3746.0
2023-05-19 04:10:00	SPY	ETF	419.7	419.8	419.7	419.8	4200.0
2023-05-19 04:15:00	SPY	ETF	419.74	419.74	419.57	419.71	3296.0
2023-05-19 04:25:00	SPY	ETF	419.64	419.79	419.63	419.79	3000.0
2023-05-19 04:30:00	SPY	ETF	420.0	420.11	419.99	420.1	9870.0
2023-05-19 04:35:00	SPY	ETF	420.12	420.31	420.12	420.15	6373.0
2023-05-19 04:40:00	SPY	ETF	420.09	420.09	419.97	419.97	1000.0
2023-05-19 04:50:00	SPY	ETF	420.14	420.14	420.14	420.14	4800.0
2023-05-19 04:55:00	SPY	ETF	420.29	420.34	420.2	420.2	3763.0
2023-05-19 05:00:00	SPY	ETF	420.19	420.19	420.07	420.07	1797.0
2023-05-19 05:05:00	SPY	ETF	420.07	420.07	420.06	420.06	200.0
2023-05-19 05:10:00	SPY	ETF	420.12	420.12	420.09	420.11	600.0
2023-05-19 05:15:00	SPY	ETF	420.11	420.13	420.11	420.13	299.0
2023-05-19 05:20:00	SPY	ETF	420.02	420.02	420.0	420.0	1300.0
2023-05-19 05:25:00	SPY	ETF	419.88	419.97	419.88	419.97	520.0
2023-05-19 05:30:00	SPY	ETF	419.88	419.88	419.86	419.86	319.0
2023-05-19 05:35:00	SPY	ETF	419.88	420.0	419.86	419.91	1770.0
2023-05-19 05:40:00	SPY	ETF	419.9	420.01	419.86	420.01	2874.0
2023-05-19 05:45:00	SPY	ETF	420.0	420.08	419.93	420.08	675.0
2023-05-19 05:50:00	SPY	ETF	420.04	420.1	420.01	420.01	2100.0
2023-05-19 06:00:00	SPY	ETF	420.0	420.0	419.88	419.99	4766.0
2023-05-19 06:05:00	SPY	ETF	419.98	419.98	419.82	419.82	4400.0
2023-05-19 06:10:00	SPY	ETF	419.85	419.86	419.81	419.82	4501.0
2023-05-19 06:15:00	SPY	ETF	419.8	419.84	419.58	419.58	13824.0
2023-05-19 06:20:00	SPY	ETF	419.72	419.75	419.67	419.7	4548.0
2023-05-19 06:25:00	SPY	ETF	419.72	419.89	419.71	419.85	16700.0
2023-05-19 06:30:00	SPY	ETF	419.84	419.84	419.74	419.74	2176.0
2023-05-19 06:35:00	SPY	ETF	419.84	419.84	419.78	419.78	2399.0
2023-05-19 06:40:00	SPY	ETF	419.87	419.87	419.8	419.8	1624.0
2023-05-19 06:45:00	SPY	ETF	419.82	419.82	419.71	419.74	2000.0
2023-05-19 06:50:00	SPY	ETF	419.72	419.73	419.7	419.71	3110.0
2023-05-19 06:55:00	SPY	ETF	419.71	419.79	419.7	419.76	4139.0
2023-05-19 07:00:00	SPY	ETF	419.75	420.3	419.75	420.07	24606.0
2023-05-19 07:05:00	SPY	ETF	420.11	420.11	420.02	420.09	10080.0
2023-05-19 07:10:00	SPY	ETF	420.06	420.09	420.04	420.05	1999.0
2023-05-19 07:15:00	SPY	ETF	420.07	420.17	420.02	420.17	2400.0
2023-05-19 07:20:00	SPY	ETF	420.2	420.68	420.2	420.48	21038.0
2023-05-19 07:25:00	SPY	ETF	420.44	420.45	420.32	420.34	15692.0
2023-05-19 07:30:00	SPY	ETF	420.41	420.48	420.33	420.47	10166.0
2023-05-19 07:35:00	SPY	ETF	420.45	420.61	420.45	420.61	22154.0
2023-05-19 07:40:00	SPY	ETF	420.61	420.61	420.35	420.381	15288.0
2023-05-19 07:45:00	SPY	ETF	420.36	420.36	420.08	420.08	17102.0
2023-05-19 07:50:00	SPY	ETF	420.07	420.25	420.07	420.22	6670.0
2023-05-19 07:55:00	SPY	ETF	420.23	420.43	420.17	420.37	16524.0
2023-05-19 08:00:00	SPY	ETF	419.7882	420.62	419.75	420.43	61684.0
2023-05-19 08:05:00	SPY	ETF	420.48	420.49	420.34	420.34	11655.0
2023-05-19 08:10:00	SPY	ETF	420.32	420.32	420.17	420.18	13016.0
2023-05-19 08:15:00	SPY	ETF	420.17	420.29	420.03	420.21	59692.0
2023-05-19 08:20:00	SPY	ETF	420.15	420.52	420.15	420.4	26786.0

> showing 50 of 92,984 rows — these rows as CSV

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