PREVIEW / etf_5min / 2023-06-01

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-01.parquet
  size:    2.0 MB
  rows:    97,405

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-01 04:00:00	SPY	ETF	418.5	418.5	418.34	418.34	1666.0
2023-06-01 04:10:00	SPY	ETF	418.34	418.39	418.34	418.37	300.0
2023-06-01 04:15:00	SPY	ETF	418.23	418.38	418.23	418.38	700.0
2023-06-01 04:20:00	SPY	ETF	418.3	418.35	418.2	418.35	2611.0
2023-06-01 04:25:00	SPY	ETF	418.45	418.57	418.45	418.57	1700.0
2023-06-01 04:30:00	SPY	ETF	418.67	418.69	418.66	418.66	3005.0
2023-06-01 04:35:00	SPY	ETF	418.72	418.77	418.72	418.77	2444.0
2023-06-01 04:40:00	SPY	ETF	418.77	418.78	418.77	418.78	837.0
2023-06-01 04:45:00	SPY	ETF	418.83	418.99	418.83	418.94	2024.0
2023-06-01 04:50:00	SPY	ETF	419.0	419.08	419.0	419.08	6439.0
2023-06-01 04:55:00	SPY	ETF	419.06	419.06	419.0	419.0	408.0
2023-06-01 05:00:00	SPY	ETF	418.94	418.97	418.92	418.95	11497.0
2023-06-01 05:05:00	SPY	ETF	418.9	418.95	418.8	418.87	2853.0
2023-06-01 05:10:00	SPY	ETF	418.95	418.97	418.92	418.92	2146.0
2023-06-01 05:15:00	SPY	ETF	418.74	418.86	418.74	418.86	700.0
2023-06-01 05:20:00	SPY	ETF	418.73	418.8	418.73	418.79	1100.0
2023-06-01 05:25:00	SPY	ETF	418.73	418.76	418.73	418.76	799.0
2023-06-01 05:30:00	SPY	ETF	418.7	418.7	418.65	418.69	2940.0
2023-06-01 05:35:00	SPY	ETF	418.64	418.71	418.64	418.71	260.0
2023-06-01 05:40:00	SPY	ETF	418.7	418.88	418.7	418.88	18650.0
2023-06-01 05:45:00	SPY	ETF	418.88	418.96	418.88	418.9	22564.0
2023-06-01 05:50:00	SPY	ETF	418.84	418.86	418.84	418.86	18000.0
2023-06-01 05:55:00	SPY	ETF	418.9	418.98	418.9	418.97	18299.0
2023-06-01 06:00:00	SPY	ETF	418.97	418.97	418.87	418.87	9804.0
2023-06-01 06:05:00	SPY	ETF	418.9	419.0	418.81	418.98	5890.0
2023-06-01 06:10:00	SPY	ETF	419.0	419.04	418.95	419.01	4321.0
2023-06-01 06:15:00	SPY	ETF	418.9	418.94	418.9	418.94	2300.0
2023-06-01 06:20:00	SPY	ETF	418.96	419.1	418.96	419.04	5066.0
2023-06-01 06:25:00	SPY	ETF	419.07	419.17	419.07	419.17	3357.0
2023-06-01 06:30:00	SPY	ETF	419.22	419.34	419.21	419.21	2071.0
2023-06-01 06:35:00	SPY	ETF	419.22	419.28	419.13	419.21	7427.0
2023-06-01 06:40:00	SPY	ETF	419.23	419.23	419.16	419.16	4100.0
2023-06-01 06:45:00	SPY	ETF	419.12	419.17	419.12	419.14	2634.0
2023-06-01 06:50:00	SPY	ETF	419.19	419.24	419.15	419.24	1149.0
2023-06-01 06:55:00	SPY	ETF	419.2	419.2	418.85	418.85	6029.0
2023-06-01 07:00:00	SPY	ETF	418.84	419.0	418.82	418.99	70336.0
2023-06-01 07:05:00	SPY	ETF	419.01	419.07	419.0	419.05	5147.0
2023-06-01 07:10:00	SPY	ETF	419.05	419.24	419.03	419.24	5398.0
2023-06-01 07:15:00	SPY	ETF	419.24	419.24	419.07	419.14	8587.0
2023-06-01 07:20:00	SPY	ETF	419.06	419.08	419.03	419.05	4741.0
2023-06-01 07:25:00	SPY	ETF	419.02	419.1	418.81	418.82	6413.0
2023-06-01 07:30:00	SPY	ETF	418.85	419.0	418.85	418.9	5515.0
2023-06-01 07:35:00	SPY	ETF	418.8	418.81	418.75	418.78	2441.0
2023-06-01 07:40:00	SPY	ETF	418.73	418.93	418.71	418.93	19316.0
2023-06-01 07:45:00	SPY	ETF	418.91	418.92	418.68	418.72	3180.0
2023-06-01 07:50:00	SPY	ETF	418.71	418.79	418.66	418.66	25554.0
2023-06-01 07:55:00	SPY	ETF	418.73	418.73	418.6	418.68	56501.0
2023-06-01 08:00:00	SPY	ETF	418.8805	419.22	418.37	418.79	115589.0
2023-06-01 08:05:00	SPY	ETF	418.79	418.79	418.28	418.37	99288.0
2023-06-01 08:10:00	SPY	ETF	418.35	418.49	418.32	418.49	12126.0

> showing 50 of 97,405 rows — these rows as CSV

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