PREVIEW / etf_5min / 2023-04-20

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-04-20.parquet
  size:    1.9 MB
  rows:    92,236

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-04-20 04:00:00	SPY	ETF	411.55	411.64	411.22	411.28	7265.0
2023-04-20 04:05:00	SPY	ETF	411.28	411.43	411.28	411.3	3387.0
2023-04-20 04:10:00	SPY	ETF	411.31	411.45	411.28	411.45	4204.0
2023-04-20 04:15:00	SPY	ETF	411.43	411.51	411.43	411.51	1117.0
2023-04-20 04:25:00	SPY	ETF	411.56	411.56	411.4	411.4	3561.0
2023-04-20 04:30:00	SPY	ETF	411.38	411.47	411.28	411.31	11955.0
2023-04-20 04:35:00	SPY	ETF	411.3	411.35	411.26	411.26	1200.0
2023-04-20 04:40:00	SPY	ETF	411.26	411.26	411.12	411.12	3195.0
2023-04-20 04:45:00	SPY	ETF	411.1	411.29	411.0	411.26	7065.0
2023-04-20 04:50:00	SPY	ETF	411.3	411.39	411.28	411.39	2318.0
2023-04-20 04:55:00	SPY	ETF	411.3	411.31	411.21	411.21	2852.0
2023-04-20 05:00:00	SPY	ETF	411.18	411.32	411.13	411.32	2299.0
2023-04-20 05:05:00	SPY	ETF	411.3	411.3	411.14	411.16	1550.0
2023-04-20 05:10:00	SPY	ETF	411.16	411.26	411.16	411.26	1008.0
2023-04-20 05:15:00	SPY	ETF	411.17	411.23	411.16	411.22	1835.0
2023-04-20 05:20:00	SPY	ETF	411.23	411.34	411.23	411.34	2700.0
2023-04-20 05:25:00	SPY	ETF	411.36	411.42	411.32	411.42	2330.0
2023-04-20 05:30:00	SPY	ETF	411.41	411.56	411.41	411.56	1500.0
2023-04-20 05:35:00	SPY	ETF	411.57	411.58	411.42	411.42	3206.0
2023-04-20 05:40:00	SPY	ETF	411.36	411.36	411.36	411.36	200.0
2023-04-20 05:45:00	SPY	ETF	411.35	411.35	411.32	411.32	2890.0
2023-04-20 05:50:00	SPY	ETF	411.38	411.41	411.36	411.36	403.0
2023-04-20 05:55:00	SPY	ETF	411.36	411.48	411.36	411.47	2212.0
2023-04-20 06:00:00	SPY	ETF	411.47	411.57	411.47	411.57	600.0
2023-04-20 06:05:00	SPY	ETF	411.55	411.62	411.55	411.59	1000.0
2023-04-20 06:10:00	SPY	ETF	411.6	411.6	411.49	411.55	26529.0
2023-04-20 06:15:00	SPY	ETF	411.59	411.6	411.41	411.46	47595.0
2023-04-20 06:20:00	SPY	ETF	411.46	411.46	411.3	411.32	45100.0
2023-04-20 06:25:00	SPY	ETF	411.35	411.35	411.29	411.32	2795.0
2023-04-20 06:30:00	SPY	ETF	411.32	411.32	411.27	411.31	2300.0
2023-04-20 06:35:00	SPY	ETF	411.31	411.39	411.31	411.39	300.0
2023-04-20 06:40:00	SPY	ETF	411.34	411.37	411.32	411.35	6029.0
2023-04-20 06:45:00	SPY	ETF	411.34	411.64	411.34	411.6	1810.0
2023-04-20 06:50:00	SPY	ETF	411.7	411.74	411.58	411.61	7709.0
2023-04-20 06:55:00	SPY	ETF	411.59	411.75	411.59	411.75	2700.0
2023-04-20 07:00:00	SPY	ETF	411.75	411.81	411.61	411.65	22783.0
2023-04-20 07:05:00	SPY	ETF	411.61	411.81	411.56	411.77	10908.0
2023-04-20 07:10:00	SPY	ETF	411.8	411.9	411.8	411.8	56909.0
2023-04-20 07:15:00	SPY	ETF	411.82	411.88	411.73	411.74	9057.0
2023-04-20 07:20:00	SPY	ETF	411.73	411.97	411.72	411.97	7706.0
2023-04-20 07:25:00	SPY	ETF	411.89	411.95	411.84	411.87	23092.0
2023-04-20 07:30:00	SPY	ETF	411.87	411.87	411.5	411.5	31818.0
2023-04-20 07:35:00	SPY	ETF	411.5	411.61	411.5	411.59	5964.0
2023-04-20 07:40:00	SPY	ETF	411.59	411.76	411.59	411.72	2527.0
2023-04-20 07:45:00	SPY	ETF	411.68	411.68	411.58	411.58	2198.0
2023-04-20 07:50:00	SPY	ETF	411.58	411.58	411.33	411.33	54794.0
2023-04-20 07:55:00	SPY	ETF	411.32	411.34	411.25	411.25	39018.0
2023-04-20 08:00:00	SPY	ETF	411.62	413.48	411.1	411.13	76587.0
2023-04-20 08:05:00	SPY	ETF	411.17	411.3	411.04	411.05	20233.0
2023-04-20 08:10:00	SPY	ETF	411.03	411.03	410.87	410.87	32255.0

> showing 50 of 92,236 rows — these rows as CSV

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