PREVIEW / etf_5min / 2023-06-29

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-29.parquet
  size:    2.0 MB
  rows:    96,479

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-29 04:00:00	SPY	ETF	436.33	436.52	436.25	436.52	5078.0
2023-06-29 04:05:00	SPY	ETF	436.48	436.56	436.46	436.48	3175.0
2023-06-29 04:10:00	SPY	ETF	436.56	436.7	436.56	436.65	1500.0
2023-06-29 04:15:00	SPY	ETF	436.69	436.72	436.62	436.72	6826.0
2023-06-29 04:20:00	SPY	ETF	436.72	436.9	436.72	436.8	9202.0
2023-06-29 04:25:00	SPY	ETF	436.76	436.82	436.63	436.82	1300.0
2023-06-29 04:30:00	SPY	ETF	436.67	436.67	436.67	436.67	1000.0
2023-06-29 04:35:00	SPY	ETF	436.69	436.72	436.66	436.66	1300.0
2023-06-29 04:40:00	SPY	ETF	436.84	436.85	436.84	436.85	800.0
2023-06-29 04:45:00	SPY	ETF	436.85	436.86	436.85	436.86	800.0
2023-06-29 04:50:00	SPY	ETF	436.8	436.8	436.75	436.75	600.0
2023-06-29 04:55:00	SPY	ETF	436.92	436.97	436.92	436.94	2463.0
2023-06-29 05:00:00	SPY	ETF	436.9	436.92	436.9	436.92	300.0
2023-06-29 05:05:00	SPY	ETF	436.85	436.89	436.85	436.87	1500.0
2023-06-29 05:10:00	SPY	ETF	436.9	436.98	436.9	436.9	2789.0
2023-06-29 05:15:00	SPY	ETF	436.94	436.94	436.85	436.85	500.0
2023-06-29 05:20:00	SPY	ETF	436.86	436.86	436.75	436.77	600.0
2023-06-29 05:25:00	SPY	ETF	436.87	436.87	436.86	436.86	300.0
2023-06-29 05:30:00	SPY	ETF	436.83	436.94	436.83	436.92	1842.0
2023-06-29 05:35:00	SPY	ETF	436.96	437.01	436.96	436.99	2000.0
2023-06-29 05:40:00	SPY	ETF	437.17	437.24	437.15	437.23	3598.0
2023-06-29 05:45:00	SPY	ETF	437.2	437.26	437.2	437.26	300.0
2023-06-29 05:50:00	SPY	ETF	437.3	437.3	437.2	437.2	4456.0
2023-06-29 05:55:00	SPY	ETF	437.32	437.34	437.3	437.32	3300.0
2023-06-29 06:00:00	SPY	ETF	437.29	437.29	437.18	437.18	5601.0
2023-06-29 06:05:00	SPY	ETF	437.21	437.21	437.21	437.21	100.0
2023-06-29 06:10:00	SPY	ETF	437.2	437.4	437.2	437.4	665.0
2023-06-29 06:15:00	SPY	ETF	437.45	437.75	437.45	437.55	5887.0
2023-06-29 06:20:00	SPY	ETF	437.53	437.67	437.51	437.6	3382.0
2023-06-29 06:25:00	SPY	ETF	437.65	437.66	437.63	437.63	1502.0
2023-06-29 06:30:00	SPY	ETF	437.65	437.71	437.65	437.67	616.0
2023-06-29 06:35:00	SPY	ETF	437.58	437.58	437.58	437.58	400.0
2023-06-29 06:40:00	SPY	ETF	437.54	437.68	437.54	437.68	3377.0
2023-06-29 06:45:00	SPY	ETF	437.66	437.72	437.65	437.71	2494.0
2023-06-29 06:50:00	SPY	ETF	437.74	437.75	437.64	437.64	1461.0
2023-06-29 06:55:00	SPY	ETF	437.6	437.65	437.6	437.6	5100.0
2023-06-29 07:00:00	SPY	ETF	437.59	437.65	437.55	437.55	4569.0
2023-06-29 07:05:00	SPY	ETF	437.57	437.65	437.57	437.6	1900.0
2023-06-29 07:10:00	SPY	ETF	437.6	437.64	437.58	437.58	5332.0
2023-06-29 07:15:00	SPY	ETF	437.59	437.65	437.57	437.57	17073.0
2023-06-29 07:20:00	SPY	ETF	437.6	437.62	437.57	437.6	10832.0
2023-06-29 07:25:00	SPY	ETF	437.58	437.78	437.55	437.78	9047.0
2023-06-29 07:30:00	SPY	ETF	437.76	437.8	437.68	437.69	23144.0
2023-06-29 07:35:00	SPY	ETF	437.63	437.64	437.53	437.53	10660.0
2023-06-29 07:40:00	SPY	ETF	437.52	437.57	437.5	437.5	8450.0
2023-06-29 07:45:00	SPY	ETF	437.5	437.59	437.43	437.53	7684.0
2023-06-29 07:50:00	SPY	ETF	437.48	437.48	437.43	437.47	4386.0
2023-06-29 07:55:00	SPY	ETF	437.48	437.55	437.48	437.55	9080.0
2023-06-29 08:00:00	SPY	ETF	437.6	437.8	436.32	437.69	53702.0
2023-06-29 08:05:00	SPY	ETF	437.64	437.69	437.53	437.53	13127.0

> showing 50 of 96,479 rows — these rows as CSV

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