PREVIEW / etf_5min / 2023-08-31

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-08-31.parquet
  size:    2.0 MB
  rows:    94,800

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-08-31 04:00:00	SPY	ETF	451.93	451.93	451.42	451.69	3378.0
2023-08-31 04:05:00	SPY	ETF	451.74	451.79	451.74	451.79	2044.0
2023-08-31 04:10:00	SPY	ETF	451.86	451.97	451.86	451.97	2832.0
2023-08-31 04:15:00	SPY	ETF	451.92	451.92	451.74	451.8	2719.0
2023-08-31 04:20:00	SPY	ETF	451.82	451.82	451.82	451.82	127.0
2023-08-31 04:25:00	SPY	ETF	451.74	451.79	451.74	451.79	900.0
2023-08-31 04:30:00	SPY	ETF	451.8	451.85	451.8	451.85	521.0
2023-08-31 04:35:00	SPY	ETF	451.68	451.68	451.67	451.67	1800.0
2023-08-31 04:40:00	SPY	ETF	451.8	451.8	451.74	451.79	1614.0
2023-08-31 04:45:00	SPY	ETF	451.84	451.85	451.84	451.85	305.0
2023-08-31 04:50:00	SPY	ETF	451.8	451.8	451.8	451.8	2800.0
2023-08-31 04:55:00	SPY	ETF	451.86	451.86	451.86	451.86	100.0
2023-08-31 05:00:00	SPY	ETF	451.93	451.93	451.58	451.59	3230.0
2023-08-31 05:05:00	SPY	ETF	451.67	451.67	451.5	451.55	9390.0
2023-08-31 05:10:00	SPY	ETF	451.44	451.45	451.22	451.45	3399.0
2023-08-31 05:15:00	SPY	ETF	451.43	451.58	451.43	451.58	1266.0
2023-08-31 05:20:00	SPY	ETF	451.42	451.46	451.41	451.46	600.0
2023-08-31 05:25:00	SPY	ETF	451.48	451.48	451.46	451.46	1112.0
2023-08-31 05:35:00	SPY	ETF	451.49	451.49	451.49	451.49	109.0
2023-08-31 05:40:00	SPY	ETF	451.42	451.42	451.42	451.42	150.0
2023-08-31 05:45:00	SPY	ETF	451.54	451.54	451.54	451.54	181.0
2023-08-31 05:50:00	SPY	ETF	451.35	451.35	451.35	451.35	300.0
2023-08-31 05:55:00	SPY	ETF	451.31	451.34	451.23	451.32	1500.0
2023-08-31 06:00:00	SPY	ETF	451.47	451.69	451.46	451.69	3975.0
2023-08-31 06:05:00	SPY	ETF	451.7	451.71	451.66	451.66	1300.0
2023-08-31 06:10:00	SPY	ETF	451.69	451.71	451.69	451.71	300.0
2023-08-31 06:15:00	SPY	ETF	451.71	451.71	451.71	451.71	300.0
2023-08-31 06:20:00	SPY	ETF	451.7	451.7	451.69	451.69	1100.0
2023-08-31 06:35:00	SPY	ETF	451.74	451.74	451.74	451.74	200.0
2023-08-31 06:40:00	SPY	ETF	451.79	451.79	451.55	451.55	4800.0
2023-08-31 06:45:00	SPY	ETF	451.6	451.61	451.6	451.61	600.0
2023-08-31 06:50:00	SPY	ETF	451.62	451.62	451.53	451.53	501.0
2023-08-31 06:55:00	SPY	ETF	451.58	451.67	451.58	451.67	975.0
2023-08-31 07:00:00	SPY	ETF	451.55	451.55	451.38	451.47	2409.0
2023-08-31 07:05:00	SPY	ETF	451.38	451.54	451.33	451.54	877.0
2023-08-31 07:10:00	SPY	ETF	451.62	451.7	451.62	451.7	2175.0
2023-08-31 07:15:00	SPY	ETF	451.7	451.7	451.65	451.66	1215.0
2023-08-31 07:20:00	SPY	ETF	451.69	451.79	451.68	451.75	1857.0
2023-08-31 07:25:00	SPY	ETF	451.85	451.85	451.8	451.8	2000.0
2023-08-31 07:30:00	SPY	ETF	451.8	452.13	451.8	452.04	8366.0
2023-08-31 07:35:00	SPY	ETF	452.06	452.19	452.05	452.19	3329.0
2023-08-31 07:40:00	SPY	ETF	452.2	452.49	452.17	452.49	5804.0
2023-08-31 07:45:00	SPY	ETF	452.42	452.59	452.3	452.52	12298.0
2023-08-31 07:50:00	SPY	ETF	452.535	452.57	452.43	452.47	8505.0
2023-08-31 07:55:00	SPY	ETF	452.43	452.47	452.35	452.4	20445.0
2023-08-31 08:00:00	SPY	ETF	452.559	452.559	451.33	452.38	57997.0
2023-08-31 08:05:00	SPY	ETF	452.32	452.33	452.24	452.33	12145.0
2023-08-31 08:10:00	SPY	ETF	452.28	452.55	452.28	452.55	31762.0
2023-08-31 08:15:00	SPY	ETF	452.55	452.76	452.52	452.66	47137.0
2023-08-31 08:20:00	SPY	ETF	452.7	452.7	452.54	452.65	26423.0

> showing 50 of 94,800 rows — these rows as CSV

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