PREVIEW / etf_5min / 2021-08-03

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-08-03.parquet
  size:    1.7 MB
  rows:    79,766

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
2021-08-03 04:00:00	SPY	ETF	438.25	439.11	438.25	439.02	13800.0
2021-08-03 04:05:00	SPY	ETF	438.95	439.0	438.95	439.0	1023.0
2021-08-03 04:10:00	SPY	ETF	438.91	438.91	438.85	438.85	10200.0
2021-08-03 04:15:00	SPY	ETF	438.87	438.88	438.86	438.86	12300.0
2021-08-03 04:20:00	SPY	ETF	438.8	438.8	438.76	438.76	1979.0
2021-08-03 04:30:00	SPY	ETF	438.97	438.97	438.95	438.95	2100.0
2021-08-03 04:35:00	SPY	ETF	438.93	438.93	438.93	438.93	300.0
2021-08-03 04:40:00	SPY	ETF	438.89	438.9	438.89	438.9	455.0
2021-08-03 04:45:00	SPY	ETF	438.87	438.92	438.86	438.9	1200.0
2021-08-03 04:50:00	SPY	ETF	438.9	438.9	438.9	438.9	100.0
2021-08-03 04:55:00	SPY	ETF	438.95	438.95	438.95	438.95	100.0
2021-08-03 05:00:00	SPY	ETF	439.05	439.05	438.97	438.97	800.0
2021-08-03 05:10:00	SPY	ETF	438.93	438.93	438.93	438.93	100.0
2021-08-03 05:20:00	SPY	ETF	438.75	438.75	438.69	438.69	1518.0
2021-08-03 05:30:00	SPY	ETF	439.05	439.05	439.05	439.05	400.0
2021-08-03 05:35:00	SPY	ETF	439.03	439.17	439.02	439.15	4800.0
2021-08-03 05:40:00	SPY	ETF	439.1	439.1	439.02	439.02	200.0
2021-08-03 05:45:00	SPY	ETF	439.09	439.12	438.98	438.98	1599.0
2021-08-03 05:50:00	SPY	ETF	438.93	438.93	438.93	438.93	100.0
2021-08-03 05:55:00	SPY	ETF	439.07	439.14	439.07	439.07	560.0
2021-08-03 06:00:00	SPY	ETF	439.07	439.07	439.07	439.07	545.0
2021-08-03 06:05:00	SPY	ETF	439.15	439.15	439.12	439.12	3059.0
2021-08-03 06:15:00	SPY	ETF	439.26	439.26	439.17	439.17	5100.0
2021-08-03 06:20:00	SPY	ETF	439.21	439.21	439.21	439.21	300.0
2021-08-03 06:25:00	SPY	ETF	439.18	439.2	439.17	439.19	3800.0
2021-08-03 06:30:00	SPY	ETF	439.11	439.11	439.06	439.06	2988.0
2021-08-03 06:40:00	SPY	ETF	439.22	439.22	439.2	439.2	1066.0
2021-08-03 06:45:00	SPY	ETF	439.2	439.2	439.2	439.2	235.0
2021-08-03 06:50:00	SPY	ETF	439.17	439.17	439.17	439.17	100.0
2021-08-03 06:55:00	SPY	ETF	439.19	439.19	439.18	439.18	700.0
2021-08-03 07:00:00	SPY	ETF	439.19	439.24	439.11	439.11	5590.0
2021-08-03 07:05:00	SPY	ETF	439.1	439.11	439.1	439.11	700.0
2021-08-03 07:10:00	SPY	ETF	439.1	439.13	439.04	439.04	3512.0
2021-08-03 07:15:00	SPY	ETF	439.03	439.06	438.97	438.97	4488.0
2021-08-03 07:20:00	SPY	ETF	438.94	438.99	438.94	438.97	1720.0
2021-08-03 07:25:00	SPY	ETF	438.97	439.08	438.97	439.06	4568.0
2021-08-03 07:30:00	SPY	ETF	439.05	439.08	439.02	439.02	7594.0
2021-08-03 07:35:00	SPY	ETF	439.01	439.05	439.0	439.01	7338.0
2021-08-03 07:40:00	SPY	ETF	439.01	439.17	439.0	439.11	14778.0
2021-08-03 07:45:00	SPY	ETF	439.14	439.15	439.09	439.13	1914.0
2021-08-03 07:50:00	SPY	ETF	439.13	439.17	439.13	439.14	2374.0
2021-08-03 07:55:00	SPY	ETF	439.15	439.16	439.13	439.16	16444.0
2021-08-03 08:00:00	SPY	ETF	439.0101	439.2	438.62	439.11	22237.0
2021-08-03 08:05:00	SPY	ETF	439.08	439.08	438.94	438.94	35959.0
2021-08-03 08:10:00	SPY	ETF	438.94	438.99	438.8	438.85	48799.0
2021-08-03 08:15:00	SPY	ETF	438.84	438.91	438.51	438.52	23247.0
2021-08-03 08:20:00	SPY	ETF	438.5	438.55	438.15	438.2	37672.0
2021-08-03 08:25:00	SPY	ETF	438.22	438.35	438.2	438.21	24798.0
2021-08-03 08:30:00	SPY	ETF	438.22	438.45	438.22	438.45	18273.0
2021-08-03 08:35:00	SPY	ETF	438.43	438.43	438.3	438.3	7348.0

> showing 50 of 79,766 rows — these rows as CSV

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