PREVIEW / etf_5min / 2023-06-30

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-30.parquet
  size:    2.0 MB
  rows:    98,257

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-06-30 04:00:00	SPY	ETF	438.65	438.97	438.35	438.94	29242.0
2023-06-30 04:05:00	SPY	ETF	438.93	438.97	438.83	438.88	6342.0
2023-06-30 04:10:00	SPY	ETF	438.9	438.95	438.82	438.82	1990.0
2023-06-30 04:15:00	SPY	ETF	438.81	438.81	438.72	438.73	1676.0
2023-06-30 04:20:00	SPY	ETF	438.79	438.86	438.79	438.86	1601.0
2023-06-30 04:25:00	SPY	ETF	438.85	438.87	438.77	438.77	1560.0
2023-06-30 04:30:00	SPY	ETF	438.85	438.87	438.78	438.85	1920.0
2023-06-30 04:35:00	SPY	ETF	438.89	439.0	438.89	439.0	1416.0
2023-06-30 04:40:00	SPY	ETF	439.01	439.13	439.01	439.13	427.0
2023-06-30 04:45:00	SPY	ETF	439.04	439.11	439.04	439.11	200.0
2023-06-30 04:50:00	SPY	ETF	439.17	439.28	439.15	439.28	1817.0
2023-06-30 04:55:00	SPY	ETF	439.23	439.28	439.23	439.28	1100.0
2023-06-30 05:00:00	SPY	ETF	439.35	439.5	439.23	439.5	2987.0
2023-06-30 05:05:00	SPY	ETF	439.39	439.45	439.36	439.45	2500.0
2023-06-30 05:10:00	SPY	ETF	439.43	439.43	439.33	439.36	5650.0
2023-06-30 05:15:00	SPY	ETF	439.36	439.38	439.36	439.38	1600.0
2023-06-30 05:20:00	SPY	ETF	439.36	439.51	439.34	439.44	2686.0
2023-06-30 05:25:00	SPY	ETF	439.45	439.6	439.45	439.6	2823.0
2023-06-30 05:30:00	SPY	ETF	439.57	439.64	439.57	439.58	960.0
2023-06-30 05:35:00	SPY	ETF	439.59	439.59	439.53	439.55	4077.0
2023-06-30 05:40:00	SPY	ETF	439.6	439.63	439.6	439.63	3000.0
2023-06-30 05:45:00	SPY	ETF	439.65	439.65	439.65	439.65	100.0
2023-06-30 05:50:00	SPY	ETF	439.72	439.72	439.67	439.67	700.0
2023-06-30 05:55:00	SPY	ETF	439.69	439.73	439.57	439.63	8129.0
2023-06-30 06:00:00	SPY	ETF	439.56	439.61	439.55	439.61	851.0
2023-06-30 06:05:00	SPY	ETF	439.62	439.77	439.62	439.77	700.0
2023-06-30 06:10:00	SPY	ETF	439.78	439.84	439.78	439.84	1416.0
2023-06-30 06:20:00	SPY	ETF	439.85	439.85	439.81	439.81	400.0
2023-06-30 06:25:00	SPY	ETF	439.79	439.81	439.79	439.81	1200.0
2023-06-30 06:30:00	SPY	ETF	439.84	439.84	439.81	439.81	900.0
2023-06-30 06:35:00	SPY	ETF	439.81	439.85	439.79	439.82	4500.0
2023-06-30 06:40:00	SPY	ETF	439.85	440.01	439.85	440.01	27334.0
2023-06-30 06:45:00	SPY	ETF	440.01	440.1	440.01	440.09	6115.0
2023-06-30 06:50:00	SPY	ETF	440.18	440.24	440.01	440.02	10462.0
2023-06-30 06:55:00	SPY	ETF	440.02	440.02	440.0	440.01	3561.0
2023-06-30 07:00:00	SPY	ETF	439.97	440.12	439.94	440.1	36052.0
2023-06-30 07:05:00	SPY	ETF	439.99	440.011	439.97	439.98	4213.0
2023-06-30 07:10:00	SPY	ETF	439.97	439.97	439.88	439.91	9457.0
2023-06-30 07:15:00	SPY	ETF	439.89	439.89	439.79	439.84	10509.0
2023-06-30 07:20:00	SPY	ETF	439.84	439.86	439.78	439.82	3872.0
2023-06-30 07:25:00	SPY	ETF	439.8	439.82	439.79	439.82	6615.0
2023-06-30 07:30:00	SPY	ETF	439.8	439.87	439.78	439.83	17502.0
2023-06-30 07:35:00	SPY	ETF	439.85	439.86	439.77	439.78	11972.0
2023-06-30 07:40:00	SPY	ETF	439.78	439.81	439.76	439.78	4239.0
2023-06-30 07:45:00	SPY	ETF	439.78	439.79	439.75	439.79	18641.0
2023-06-30 07:50:00	SPY	ETF	439.77	439.81	439.67	439.73	23559.0
2023-06-30 07:55:00	SPY	ETF	439.81	439.83	439.78	439.79	14321.0
2023-06-30 08:00:00	SPY	ETF	439.9514	440.0239	438.36	439.98	43869.0
2023-06-30 08:05:00	SPY	ETF	440.02	440.12	439.95	440.12	25822.0
2023-06-30 08:10:00	SPY	ETF	440.11	440.13	440.01	440.02	17528.0

> showing 50 of 98,257 rows — these rows as CSV

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