PREVIEW / etf_5min / 2022-07-27

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-07-27.parquet
  size:    1.9 MB
  rows:    90,341

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
2022-07-27 04:00:00	SPY	ETF	394.5	394.79	394.28	394.78	4865.0
2022-07-27 04:05:00	SPY	ETF	394.83	395.42	394.82	395.26	16024.0
2022-07-27 04:10:00	SPY	ETF	395.23	395.34	395.19	395.2	3984.0
2022-07-27 04:15:00	SPY	ETF	395.21	395.21	394.97	394.97	400.0
2022-07-27 04:20:00	SPY	ETF	394.83	394.88	394.81	394.88	845.0
2022-07-27 04:25:00	SPY	ETF	394.76	394.9	394.74	394.75	3100.0
2022-07-27 04:30:00	SPY	ETF	394.92	395.05	394.92	394.95	3900.0
2022-07-27 04:35:00	SPY	ETF	394.94	395.04	394.84	394.84	1866.0
2022-07-27 04:40:00	SPY	ETF	394.9	395.04	394.84	394.95	5600.0
2022-07-27 04:45:00	SPY	ETF	394.98	395.03	394.9	394.9	6700.0
2022-07-27 04:50:00	SPY	ETF	394.99	395.13	394.9	395.11	9199.0
2022-07-27 04:55:00	SPY	ETF	395.04	395.04	394.99	395.04	7415.0
2022-07-27 05:00:00	SPY	ETF	394.89	395.02	394.83	395.0	2100.0
2022-07-27 05:05:00	SPY	ETF	395.05	395.05	395.0	395.01	600.0
2022-07-27 05:10:00	SPY	ETF	395.0	395.02	394.86	394.88	3100.0
2022-07-27 05:15:00	SPY	ETF	394.83	394.83	394.83	394.83	5100.0
2022-07-27 05:20:00	SPY	ETF	394.91	394.91	394.81	394.81	2600.0
2022-07-27 05:25:00	SPY	ETF	394.81	394.85	394.75	394.85	2700.0
2022-07-27 05:30:00	SPY	ETF	394.89	395.04	394.89	395.04	800.0
2022-07-27 05:35:00	SPY	ETF	395.04	395.15	394.83	394.96	6900.0
2022-07-27 05:45:00	SPY	ETF	394.9	394.92	394.76	394.76	1499.0
2022-07-27 05:50:00	SPY	ETF	394.61	394.61	394.5	394.5	2050.0
2022-07-27 05:55:00	SPY	ETF	394.51	394.57	394.51	394.57	1822.0
2022-07-27 06:00:00	SPY	ETF	394.41	394.41	394.4	394.4	200.0
2022-07-27 06:05:00	SPY	ETF	394.41	394.42	394.41	394.42	1400.0
2022-07-27 06:10:00	SPY	ETF	394.4	394.51	394.38	394.38	1295.0
2022-07-27 06:15:00	SPY	ETF	394.36	394.36	394.32	394.32	1990.0
2022-07-27 06:20:00	SPY	ETF	394.33	394.36	394.2	394.2	6648.0
2022-07-27 06:25:00	SPY	ETF	394.26	394.43	394.26	394.27	51014.0
2022-07-27 06:30:00	SPY	ETF	394.24	394.3	394.1	394.3	2798.0
2022-07-27 06:35:00	SPY	ETF	394.42	394.5	394.36	394.42	2799.0
2022-07-27 06:40:00	SPY	ETF	394.44	394.46	394.44	394.46	600.0
2022-07-27 06:45:00	SPY	ETF	394.4	394.4	394.27	394.27	1300.0
2022-07-27 06:50:00	SPY	ETF	394.38	394.45	394.31	394.42	3050.0
2022-07-27 06:55:00	SPY	ETF	394.38	394.45	394.38	394.4	35526.0
2022-07-27 07:00:00	SPY	ETF	394.41	394.41	394.13	394.15	14874.0
2022-07-27 07:05:00	SPY	ETF	394.22	394.24	393.95	393.99	21537.0
2022-07-27 07:10:00	SPY	ETF	393.96	394.12	393.93	394.09	7275.0
2022-07-27 07:15:00	SPY	ETF	394.06	394.13	394.05	394.07	8854.0
2022-07-27 07:20:00	SPY	ETF	394.11	394.14	394.07	394.14	3717.0
2022-07-27 07:25:00	SPY	ETF	394.2	394.33	394.2	394.24	13180.0
2022-07-27 07:30:00	SPY	ETF	394.24	394.36	394.19	394.24	15853.0
2022-07-27 07:35:00	SPY	ETF	394.22	394.24	394.03	394.06	28915.0
2022-07-27 07:40:00	SPY	ETF	394.13	394.34	394.13	394.3	31788.0
2022-07-27 07:45:00	SPY	ETF	394.3	394.3	394.1	394.1	8121.0
2022-07-27 07:50:00	SPY	ETF	394.06	394.27	394.06	394.2	8664.0
2022-07-27 07:55:00	SPY	ETF	394.18	394.26	393.97	393.99	18007.0
2022-07-27 08:00:00	SPY	ETF	394.03	395.3604	393.94	394.15	28296.0
2022-07-27 08:05:00	SPY	ETF	394.18	394.3	394.18	394.22	39322.0
2022-07-27 08:10:00	SPY	ETF	394.19	394.31	394.12	394.3	5740.0

> showing 50 of 90,341 rows — these rows as CSV

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