PREVIEW / etf_5min / 2023-06-27

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-27.parquet
  size:    2.0 MB
  rows:    94,810

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-06-27 04:00:00	SPY	ETF	432.45	432.62	432.45	432.62	12691.0
2023-06-27 04:05:00	SPY	ETF	432.55	432.63	432.37	432.37	3837.0
2023-06-27 04:10:00	SPY	ETF	432.48	432.66	432.48	432.65	1112.0
2023-06-27 04:15:00	SPY	ETF	432.56	432.72	432.55	432.69	1678.0
2023-06-27 04:20:00	SPY	ETF	432.62	432.62	432.52	432.52	1734.0
2023-06-27 04:25:00	SPY	ETF	432.52	432.52	432.48	432.48	282.0
2023-06-27 04:30:00	SPY	ETF	432.41	432.41	432.33	432.37	2190.0
2023-06-27 04:35:00	SPY	ETF	432.4	432.4	432.29	432.29	9000.0
2023-06-27 04:40:00	SPY	ETF	432.22	432.22	432.09	432.2	2500.0
2023-06-27 04:45:00	SPY	ETF	432.23	432.24	432.12	432.24	1700.0
2023-06-27 04:50:00	SPY	ETF	432.21	432.21	432.21	432.21	400.0
2023-06-27 04:55:00	SPY	ETF	432.22	432.22	432.22	432.22	200.0
2023-06-27 05:00:00	SPY	ETF	432.15	432.15	432.11	432.14	400.0
2023-06-27 05:05:00	SPY	ETF	432.14	432.28	432.14	432.28	1535.0
2023-06-27 05:10:00	SPY	ETF	432.15	432.25	432.12	432.16	2051.0
2023-06-27 05:15:00	SPY	ETF	432.15	432.16	432.1	432.16	804.0
2023-06-27 05:20:00	SPY	ETF	432.19	432.3	432.19	432.3	452.0
2023-06-27 05:25:00	SPY	ETF	432.21	432.33	432.21	432.33	851.0
2023-06-27 05:30:00	SPY	ETF	432.29	432.29	432.21	432.21	1000.0
2023-06-27 05:35:00	SPY	ETF	432.27	432.27	432.27	432.27	120.0
2023-06-27 05:40:00	SPY	ETF	432.19	432.25	432.19	432.25	306.0
2023-06-27 05:45:00	SPY	ETF	432.23	432.23	432.15	432.15	600.0
2023-06-27 05:50:00	SPY	ETF	432.2	432.2	432.2	432.2	100.0
2023-06-27 05:55:00	SPY	ETF	432.23	432.23	432.18	432.18	510.0
2023-06-27 06:05:00	SPY	ETF	432.32	432.32	432.27	432.27	210.0
2023-06-27 06:10:00	SPY	ETF	432.16	432.27	432.16	432.27	739.0
2023-06-27 06:15:00	SPY	ETF	432.18	432.2	432.17	432.18	2541.0
2023-06-27 06:20:00	SPY	ETF	432.16	432.2	432.11	432.18	3434.0
2023-06-27 06:25:00	SPY	ETF	432.2	432.23	432.2	432.23	207.0
2023-06-27 06:30:00	SPY	ETF	432.39	432.39	432.39	432.39	2000.0
2023-06-27 06:35:00	SPY	ETF	432.29	432.39	432.28	432.39	1483.0
2023-06-27 06:40:00	SPY	ETF	432.44	432.44	432.31	432.43	728.0
2023-06-27 06:45:00	SPY	ETF	432.45	432.45	432.45	432.45	2596.0
2023-06-27 06:55:00	SPY	ETF	432.5	432.5	432.47	432.47	2665.0
2023-06-27 07:00:00	SPY	ETF	432.49	432.5	432.31	432.31	24399.0
2023-06-27 07:05:00	SPY	ETF	432.29	432.36	432.25	432.25	4404.0
2023-06-27 07:10:00	SPY	ETF	432.28	432.35	432.28	432.35	11473.0
2023-06-27 07:15:00	SPY	ETF	432.28	432.28	432.08	432.08	10060.0
2023-06-27 07:20:00	SPY	ETF	432.06	432.18	432.05	432.1	4114.0
2023-06-27 07:25:00	SPY	ETF	432.16	432.16	432.03	432.06	2512.0
2023-06-27 07:30:00	SPY	ETF	432.08	432.08	431.9	432.04	18400.0
2023-06-27 07:35:00	SPY	ETF	431.95	432.03	431.95	432.0	7638.0
2023-06-27 07:40:00	SPY	ETF	431.95	432.0	431.85	431.9	7767.0
2023-06-27 07:45:00	SPY	ETF	431.909	431.91	431.8	431.8	11183.0
2023-06-27 07:50:00	SPY	ETF	431.81	431.81	431.68	431.75	9494.0
2023-06-27 07:55:00	SPY	ETF	431.71	431.84	431.7	431.74	3064.0
2023-06-27 08:00:00	SPY	ETF	432.3301	432.94	431.59	431.75	35152.0
2023-06-27 08:05:00	SPY	ETF	431.75	431.94	431.75	431.9	12950.0
2023-06-27 08:10:00	SPY	ETF	431.8801	431.93	431.64	431.73	13276.0
2023-06-27 08:15:00	SPY	ETF	431.7	431.84	431.7	431.78	22847.0

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

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