PREVIEW / etf_5min / 2023-01-23

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-01-23.parquet
  size:    2.1 MB
  rows:    101,250

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-01-23 04:00:00	SPY	ETF	389.05	395.57	389.05	395.57	1203.0
2023-01-23 04:05:00	SPY	ETF	395.51	395.51	395.5	395.5	319.0
2023-01-23 04:10:00	SPY	ETF	395.5	395.6	395.47	395.6	1284.0
2023-01-23 04:15:00	SPY	ETF	395.58	395.7	395.53	395.7	2652.0
2023-01-23 04:20:00	SPY	ETF	395.67	395.7	395.63	395.66	3200.0
2023-01-23 04:25:00	SPY	ETF	395.65	395.67	395.56	395.59	10989.0
2023-01-23 04:30:00	SPY	ETF	395.56	395.91	395.56	395.88	2599.0
2023-01-23 04:35:00	SPY	ETF	395.83	395.83	395.78	395.82	400.0
2023-01-23 04:40:00	SPY	ETF	395.77	395.77	395.77	395.77	100.0
2023-01-23 04:45:00	SPY	ETF	395.68	395.68	395.65	395.68	431.0
2023-01-23 04:50:00	SPY	ETF	395.86	395.86	395.8	395.8	1625.0
2023-01-23 04:55:00	SPY	ETF	395.84	395.89	395.73	395.76	1204.0
2023-01-23 05:00:00	SPY	ETF	395.9	395.91	395.86	395.86	1832.0
2023-01-23 05:05:00	SPY	ETF	395.65	395.65	395.41	395.41	8116.0
2023-01-23 05:10:00	SPY	ETF	395.41	395.6	395.26	395.26	4209.0
2023-01-23 05:15:00	SPY	ETF	395.3	395.34	395.3	395.34	1188.0
2023-01-23 05:20:00	SPY	ETF	395.34	395.45	395.34	395.45	400.0
2023-01-23 05:25:00	SPY	ETF	395.4	395.41	395.32	395.41	1989.0
2023-01-23 05:30:00	SPY	ETF	395.37	395.37	395.3	395.34	5324.0
2023-01-23 05:35:00	SPY	ETF	395.43	395.58	395.43	395.58	1400.0
2023-01-23 05:40:00	SPY	ETF	395.67	395.75	395.67	395.75	2200.0
2023-01-23 05:45:00	SPY	ETF	395.71	395.71	395.61	395.61	2346.0
2023-01-23 05:50:00	SPY	ETF	395.66	395.66	395.62	395.62	352.0
2023-01-23 05:55:00	SPY	ETF	395.76	395.85	395.7	395.7	25600.0
2023-01-23 06:00:00	SPY	ETF	395.6	395.85	395.42	395.53	26327.0
2023-01-23 06:05:00	SPY	ETF	395.56	395.56	395.41	395.46	19926.0
2023-01-23 06:10:00	SPY	ETF	395.4	395.48	395.35	395.46	12158.0
2023-01-23 06:15:00	SPY	ETF	395.49	395.63	395.49	395.6	500.0
2023-01-23 06:20:00	SPY	ETF	395.5	395.5	395.5	395.5	250.0
2023-01-23 06:25:00	SPY	ETF	395.49	395.49	395.4	395.43	5098.0
2023-01-23 06:30:00	SPY	ETF	395.52	395.52	395.52	395.52	400.0
2023-01-23 06:35:00	SPY	ETF	395.48	395.5	395.48	395.5	900.0
2023-01-23 06:40:00	SPY	ETF	395.5	395.5	395.32	395.32	1181.0
2023-01-23 06:45:00	SPY	ETF	395.33	395.4	395.24	395.4	2900.0
2023-01-23 06:50:00	SPY	ETF	395.35	395.36	395.23	395.23	19735.0
2023-01-23 06:55:00	SPY	ETF	395.2	395.38	395.16	395.38	4507.0
2023-01-23 07:00:00	SPY	ETF	395.43	395.71	395.43	395.71	16078.0
2023-01-23 07:05:00	SPY	ETF	395.67	395.75	395.64	395.7	11737.0
2023-01-23 07:10:00	SPY	ETF	395.61	395.65	395.58	395.65	607.0
2023-01-23 07:15:00	SPY	ETF	395.64	395.719	395.58	395.61	6670.0
2023-01-23 07:20:00	SPY	ETF	395.68	395.72	395.56	395.65	17277.0
2023-01-23 07:25:00	SPY	ETF	395.62	395.63	395.54	395.61	3467.0
2023-01-23 07:30:00	SPY	ETF	395.69	395.86	395.69	395.86	8147.0
2023-01-23 07:35:00	SPY	ETF	395.9	396.1	395.9	396.06	3212.0
2023-01-23 07:40:00	SPY	ETF	395.97	396.44	395.97	396.3	71004.0
2023-01-23 07:45:00	SPY	ETF	396.35	396.35	396.04	396.04	5673.0
2023-01-23 07:50:00	SPY	ETF	396.11	396.14	395.86	395.86	23323.0
2023-01-23 07:55:00	SPY	ETF	395.87	395.93	395.8	395.86	8958.0
2023-01-23 08:00:00	SPY	ETF	395.5	396.37	395.5	396.36	40510.0
2023-01-23 08:05:00	SPY	ETF	396.38	396.58	396.239	396.48	33217.0

> showing 50 of 101,250 rows — these rows as CSV

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