PREVIEW / etf_5min / 2023-07-20

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-20.parquet
  size:    2.0 MB
  rows:    98,998

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-20 04:00:00	SPY	ETF	454.55	454.97	454.55	454.96	6265.0
2023-07-20 04:05:00	SPY	ETF	454.93	454.93	454.85	454.85	1157.0
2023-07-20 04:10:00	SPY	ETF	454.81	454.82	454.66	454.66	3613.0
2023-07-20 04:15:00	SPY	ETF	454.74	454.85	454.74	454.75	3784.0
2023-07-20 04:20:00	SPY	ETF	454.68	454.78	454.63	454.78	2118.0
2023-07-20 04:25:00	SPY	ETF	454.8	454.8	454.8	454.8	1138.0
2023-07-20 04:30:00	SPY	ETF	454.75	454.8	454.74	454.74	1400.0
2023-07-20 04:35:00	SPY	ETF	454.78	454.78	454.75	454.75	500.0
2023-07-20 04:40:00	SPY	ETF	454.8	454.8	454.79	454.79	3800.0
2023-07-20 04:45:00	SPY	ETF	454.75	454.75	454.72	454.74	2264.0
2023-07-20 04:50:00	SPY	ETF	454.8	454.82	454.78	454.82	2894.0
2023-07-20 04:55:00	SPY	ETF	454.74	454.77	454.74	454.74	600.0
2023-07-20 05:00:00	SPY	ETF	454.72	454.72	454.48	454.48	1580.0
2023-07-20 05:05:00	SPY	ETF	454.53	454.62	454.53	454.59	426.0
2023-07-20 05:10:00	SPY	ETF	454.55	454.55	454.55	454.55	300.0
2023-07-20 05:15:00	SPY	ETF	454.51	454.52	454.48	454.48	1448.0
2023-07-20 05:20:00	SPY	ETF	454.48	454.53	454.48	454.52	433.0
2023-07-20 05:25:00	SPY	ETF	454.6	454.6	454.6	454.6	236.0
2023-07-20 05:30:00	SPY	ETF	454.6	454.63	454.6	454.63	440.0
2023-07-20 05:35:00	SPY	ETF	454.73	454.73	454.56	454.56	300.0
2023-07-20 05:40:00	SPY	ETF	454.46	454.48	454.46	454.48	307.0
2023-07-20 05:45:00	SPY	ETF	454.54	454.7	454.54	454.69	1200.0
2023-07-20 05:50:00	SPY	ETF	454.75	454.76	454.75	454.76	646.0
2023-07-20 05:55:00	SPY	ETF	454.72	454.73	454.72	454.73	1300.0
2023-07-20 06:00:00	SPY	ETF	454.72	454.72	454.69	454.69	2691.0
2023-07-20 06:05:00	SPY	ETF	454.75	454.79	454.75	454.79	900.0
2023-07-20 06:10:00	SPY	ETF	454.85	454.95	454.85	454.95	4500.0
2023-07-20 06:15:00	SPY	ETF	454.88	454.92	454.87	454.92	1218.0
2023-07-20 06:20:00	SPY	ETF	454.97	455.0	454.95	454.97	3900.0
2023-07-20 06:25:00	SPY	ETF	455.0	455.03	454.97	454.98	1850.0
2023-07-20 06:30:00	SPY	ETF	454.91	455.03	454.88	455.03	1912.0
2023-07-20 06:35:00	SPY	ETF	455.06	455.1	455.03	455.08	2149.0
2023-07-20 06:40:00	SPY	ETF	454.97	455.04	454.97	455.04	600.0
2023-07-20 06:45:00	SPY	ETF	454.9	454.9	454.81	454.81	800.0
2023-07-20 06:50:00	SPY	ETF	454.87	454.87	454.87	454.87	500.0
2023-07-20 06:55:00	SPY	ETF	454.87	454.9	454.87	454.9	450.0
2023-07-20 07:00:00	SPY	ETF	454.89	454.89	454.8	454.8	3911.0
2023-07-20 07:05:00	SPY	ETF	454.76	454.81	454.7	454.79	52189.0
2023-07-20 07:10:00	SPY	ETF	454.82	454.83	454.7	454.71	10915.0
2023-07-20 07:15:00	SPY	ETF	454.7	454.75	454.65	454.7	20102.0
2023-07-20 07:20:00	SPY	ETF	454.66	454.68	454.59	454.59	7880.0
2023-07-20 07:25:00	SPY	ETF	454.63	454.67	454.62	454.67	2319.0
2023-07-20 07:30:00	SPY	ETF	454.63	454.84	454.58	454.84	7115.0
2023-07-20 07:35:00	SPY	ETF	454.83	454.84	454.76	454.78	5346.0
2023-07-20 07:40:00	SPY	ETF	454.84	454.84	454.78	454.78	2568.0
2023-07-20 07:45:00	SPY	ETF	454.76	454.81	454.73	454.79	7567.0
2023-07-20 07:50:00	SPY	ETF	454.77	454.92	454.75	454.86	12145.0
2023-07-20 07:55:00	SPY	ETF	454.87	454.89	454.83	454.83	8487.0
2023-07-20 08:00:00	SPY	ETF	454.84	454.9496	454.4	454.8	72889.0
2023-07-20 08:05:00	SPY	ETF	454.77	454.77	454.62	454.64	1852.0

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

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