PREVIEW / etf_5min / 2023-07-21

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-21.parquet
  size:    1.9 MB
  rows:    93,737

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-07-21 04:00:00	SPY	ETF	453.0	453.0	452.87	452.95	1077.0
2023-07-21 04:05:00	SPY	ETF	452.99	453.13	452.96	453.05	1285.0
2023-07-21 04:10:00	SPY	ETF	452.92	452.97	452.92	452.92	1182.0
2023-07-21 04:15:00	SPY	ETF	452.92	453.01	452.92	453.0	4971.0
2023-07-21 04:20:00	SPY	ETF	453.02	453.21	453.02	453.2	2905.0
2023-07-21 04:25:00	SPY	ETF	453.21	453.24	453.2	453.23	1069.0
2023-07-21 04:30:00	SPY	ETF	453.24	453.25	453.24	453.25	1100.0
2023-07-21 04:35:00	SPY	ETF	453.26	453.29	453.26	453.29	3665.0
2023-07-21 04:40:00	SPY	ETF	453.28	453.29	453.28	453.28	4824.0
2023-07-21 04:45:00	SPY	ETF	453.28	453.28	453.28	453.28	100.0
2023-07-21 04:50:00	SPY	ETF	453.2	453.24	453.15	453.24	300.0
2023-07-21 04:55:00	SPY	ETF	453.32	453.32	453.32	453.32	499.0
2023-07-21 05:00:00	SPY	ETF	453.32	453.32	453.2	453.2	834.0
2023-07-21 05:05:00	SPY	ETF	453.17	453.17	453.17	453.17	2500.0
2023-07-21 05:10:00	SPY	ETF	453.26	453.26	453.26	453.26	751.0
2023-07-21 05:15:00	SPY	ETF	453.27	453.27	453.27	453.27	1010.0
2023-07-21 05:20:00	SPY	ETF	453.33	453.33	453.33	453.33	1500.0
2023-07-21 05:30:00	SPY	ETF	453.11	453.12	453.07	453.07	1961.0
2023-07-21 05:35:00	SPY	ETF	453.0	453.02	453.0	453.02	300.0
2023-07-21 05:40:00	SPY	ETF	453.02	453.12	452.96	452.96	2100.0
2023-07-21 05:45:00	SPY	ETF	453.09	453.09	453.09	453.09	200.0
2023-07-21 05:50:00	SPY	ETF	453.2	453.29	453.2	453.22	1553.0
2023-07-21 05:55:00	SPY	ETF	453.24	453.3	453.24	453.24	8025.0
2023-07-21 06:00:00	SPY	ETF	453.33	453.39	453.33	453.39	1900.0
2023-07-21 06:05:00	SPY	ETF	453.39	453.5	453.36	453.4	7821.0
2023-07-21 06:15:00	SPY	ETF	453.39	453.39	453.38	453.38	7900.0
2023-07-21 06:25:00	SPY	ETF	453.48	453.63	453.48	453.63	739.0
2023-07-21 06:30:00	SPY	ETF	453.62	453.62	453.55	453.55	600.0
2023-07-21 06:40:00	SPY	ETF	453.51	453.51	453.5	453.5	200.0
2023-07-21 06:45:00	SPY	ETF	453.5	453.5	453.5	453.5	100.0
2023-07-21 06:50:00	SPY	ETF	453.58	453.58	453.58	453.58	100.0
2023-07-21 06:55:00	SPY	ETF	453.56	453.58	453.46	453.58	4227.0
2023-07-21 07:00:00	SPY	ETF	453.56	453.56	453.41	453.54	3468.0
2023-07-21 07:05:00	SPY	ETF	453.41	453.45	453.36	453.45	4035.0
2023-07-21 07:10:00	SPY	ETF	453.4	453.48	453.4	453.42	4879.0
2023-07-21 07:15:00	SPY	ETF	453.48	453.505	453.48	453.5	5325.0
2023-07-21 07:20:00	SPY	ETF	453.5	453.5	453.4	453.4	1008.0
2023-07-21 07:25:00	SPY	ETF	453.4	453.47	453.37	453.39	12750.0
2023-07-21 07:30:00	SPY	ETF	453.39	453.4	453.14	453.2	3794.0
2023-07-21 07:35:00	SPY	ETF	453.16	453.45	453.16	453.3	16216.0
2023-07-21 07:40:00	SPY	ETF	453.26	453.34	453.26	453.34	5544.0
2023-07-21 07:45:00	SPY	ETF	453.31	453.31	453.25	453.25	866.0
2023-07-21 07:50:00	SPY	ETF	453.27	453.3	453.25	453.26	12390.0
2023-07-21 07:55:00	SPY	ETF	453.25	453.27	453.1	453.1	3349.0
2023-07-21 08:00:00	SPY	ETF	453.5691	453.57	452.64	453.41	27081.0
2023-07-21 08:05:00	SPY	ETF	453.37	453.52	453.35	453.45	9205.0
2023-07-21 08:10:00	SPY	ETF	453.5	453.66	453.49	453.64	27131.0
2023-07-21 08:15:00	SPY	ETF	453.67	453.9	453.64	453.82	9455.0
2023-07-21 08:20:00	SPY	ETF	453.79	454.05	453.76	454.0	38591.0
2023-07-21 08:25:00	SPY	ETF	454.01	454.07	453.97	454.01	25711.0

> showing 50 of 93,737 rows — these rows as CSV

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