PREVIEW / etf_5min / 2023-05-11

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-11.parquet
  size:    1.9 MB
  rows:    92,870

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-05-11 04:00:00	SPY	ETF	414.1	414.29	413.86	414.03	3300.0
2023-05-11 04:05:00	SPY	ETF	414.16	414.35	414.16	414.3	400.0
2023-05-11 04:10:00	SPY	ETF	414.33	414.37	414.33	414.37	1300.0
2023-05-11 04:15:00	SPY	ETF	414.39	414.51	414.39	414.42	4860.0
2023-05-11 04:20:00	SPY	ETF	414.48	414.48	414.25	414.32	6700.0
2023-05-11 04:25:00	SPY	ETF	414.33	414.33	414.24	414.24	1000.0
2023-05-11 04:30:00	SPY	ETF	414.25	414.3	414.25	414.28	10100.0
2023-05-11 04:35:00	SPY	ETF	414.32	414.32	414.04	414.04	3763.0
2023-05-11 04:40:00	SPY	ETF	414.17	414.18	414.1	414.1	1500.0
2023-05-11 04:45:00	SPY	ETF	414.1	414.15	414.1	414.15	1400.0
2023-05-11 04:50:00	SPY	ETF	414.1	414.1	414.1	414.1	274.0
2023-05-11 05:00:00	SPY	ETF	414.17	414.29	414.17	414.29	408.0
2023-05-11 05:10:00	SPY	ETF	414.17	414.17	414.17	414.17	100.0
2023-05-11 05:15:00	SPY	ETF	414.03	414.03	413.94	413.94	300.0
2023-05-11 05:20:00	SPY	ETF	413.96	414.55	413.96	414.55	2150.0
2023-05-11 05:25:00	SPY	ETF	414.32	414.41	414.32	414.41	800.0
2023-05-11 05:30:00	SPY	ETF	414.37	414.49	414.37	414.49	1100.0
2023-05-11 05:35:00	SPY	ETF	414.5	414.5	414.47	414.47	900.0
2023-05-11 05:40:00	SPY	ETF	414.44	414.48	414.44	414.48	608.0
2023-05-11 05:45:00	SPY	ETF	414.38	414.38	414.37	414.38	400.0
2023-05-11 05:50:00	SPY	ETF	414.33	414.41	414.33	414.36	5965.0
2023-05-11 05:55:00	SPY	ETF	414.3	414.3	414.18	414.18	801.0
2023-05-11 06:00:00	SPY	ETF	414.3	414.3	414.3	414.3	350.0
2023-05-11 06:05:00	SPY	ETF	414.28	414.28	414.2	414.2	950.0
2023-05-11 06:10:00	SPY	ETF	414.2	414.2	413.92	413.94	4662.0
2023-05-11 06:15:00	SPY	ETF	413.94	413.94	413.88	413.91	1190.0
2023-05-11 06:20:00	SPY	ETF	413.85	414.01	413.85	414.0	7650.0
2023-05-11 06:25:00	SPY	ETF	414.05	414.06	413.95	413.95	926.0
2023-05-11 06:30:00	SPY	ETF	413.95	413.98	413.95	413.95	687.0
2023-05-11 06:35:00	SPY	ETF	413.9	413.94	413.81	413.94	1300.0
2023-05-11 06:40:00	SPY	ETF	413.78	413.8	413.74	413.79	1058.0
2023-05-11 06:45:00	SPY	ETF	413.92	413.92	413.91	413.91	518.0
2023-05-11 06:50:00	SPY	ETF	413.87	413.92	413.87	413.92	323.0
2023-05-11 06:55:00	SPY	ETF	413.83	413.84	413.66	413.66	80888.0
2023-05-11 07:00:00	SPY	ETF	413.6	413.69	413.4	413.55	81105.0
2023-05-11 07:05:00	SPY	ETF	413.57	413.6	413.29	413.29	35245.0
2023-05-11 07:10:00	SPY	ETF	413.32	413.33	413.04	413.09	43258.0
2023-05-11 07:15:00	SPY	ETF	413.1	413.1	412.61	412.7	95618.0
2023-05-11 07:20:00	SPY	ETF	412.7	412.79	412.48	412.62	87076.0
2023-05-11 07:25:00	SPY	ETF	412.62	412.85	412.59	412.83	44104.0
2023-05-11 07:30:00	SPY	ETF	412.82	412.92	412.731	412.82	26894.0
2023-05-11 07:35:00	SPY	ETF	412.8	412.81	412.65	412.75	14280.0
2023-05-11 07:40:00	SPY	ETF	412.68	412.69	412.4	412.4	41013.0
2023-05-11 07:45:00	SPY	ETF	412.37	412.54	412.26	412.54	20246.0
2023-05-11 07:50:00	SPY	ETF	412.42	412.63	412.35	412.58	8601.0
2023-05-11 07:55:00	SPY	ETF	412.61	412.63	412.44	412.44	20000.0
2023-05-11 08:00:00	SPY	ETF	412.7695	414.53	412.31	412.51	78033.0
2023-05-11 08:05:00	SPY	ETF	412.45	412.78	412.44	412.76	23889.0
2023-05-11 08:10:00	SPY	ETF	412.79	412.93	412.7	412.9001	38936.0
2023-05-11 08:15:00	SPY	ETF	412.91	414.05	412.81	413.27	300902.0

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

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