PREVIEW / etf_5min / 2021-07-26

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-26.parquet
  size:    1.7 MB
  rows:    80,463

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-07-26 04:00:00	SPY	ETF	438.65	438.65	437.33	437.33	2788.0
2021-07-26 04:05:00	SPY	ETF	437.39	437.39	437.13	437.13	1664.0
2021-07-26 04:10:00	SPY	ETF	437.08	437.29	437.08	437.29	3550.0
2021-07-26 04:15:00	SPY	ETF	437.29	437.3	437.22	437.3	1569.0
2021-07-26 04:20:00	SPY	ETF	437.28	437.35	437.26	437.3	688.0
2021-07-26 04:25:00	SPY	ETF	437.28	437.3	437.28	437.3	200.0
2021-07-26 04:30:00	SPY	ETF	437.42	437.65	437.42	437.65	1011.0
2021-07-26 04:35:00	SPY	ETF	437.75	437.88	437.74	437.88	500.0
2021-07-26 04:40:00	SPY	ETF	437.84	438.05	437.82	437.96	6049.0
2021-07-26 04:45:00	SPY	ETF	438.04	438.15	437.97	437.97	7373.0
2021-07-26 04:50:00	SPY	ETF	437.99	437.99	437.99	437.99	150.0
2021-07-26 05:10:00	SPY	ETF	438.27	438.27	438.21	438.23	500.0
2021-07-26 05:15:00	SPY	ETF	438.29	438.29	438.29	438.29	350.0
2021-07-26 05:20:00	SPY	ETF	438.3	438.3	438.3	438.3	200.0
2021-07-26 05:25:00	SPY	ETF	438.5	438.53	438.49	438.49	5686.0
2021-07-26 05:30:00	SPY	ETF	438.62	438.62	438.62	438.62	100.0
2021-07-26 05:35:00	SPY	ETF	438.6	438.6	438.57	438.58	1200.0
2021-07-26 05:40:00	SPY	ETF	438.66	438.66	438.56	438.58	600.0
2021-07-26 05:45:00	SPY	ETF	438.6	438.8	438.59	438.8	1698.0
2021-07-26 05:55:00	SPY	ETF	438.8	438.93	438.75	438.79	2884.0
2021-07-26 06:00:00	SPY	ETF	438.9	439.0	438.9	439.0	3000.0
2021-07-26 06:05:00	SPY	ETF	439.04	439.13	439.0	439.06	5129.0
2021-07-26 06:10:00	SPY	ETF	439.07	439.07	439.0	439.03	1371.0
2021-07-26 06:15:00	SPY	ETF	439.05	439.05	439.01	439.01	2100.0
2021-07-26 06:20:00	SPY	ETF	438.96	439.01	438.9	438.92	6400.0
2021-07-26 06:25:00	SPY	ETF	438.98	438.98	438.91	438.91	1100.0
2021-07-26 06:30:00	SPY	ETF	438.9	438.99	438.9	438.94	1978.0
2021-07-26 06:35:00	SPY	ETF	438.89	438.89	438.88	438.88	300.0
2021-07-26 06:40:00	SPY	ETF	438.83	438.96	438.83	438.96	366.0
2021-07-26 06:50:00	SPY	ETF	438.9	438.93	438.86	438.86	2342.0
2021-07-26 06:55:00	SPY	ETF	438.75	438.75	438.55	438.55	3567.0
2021-07-26 07:00:00	SPY	ETF	438.55	438.8	438.55	438.8	6612.0
2021-07-26 07:05:00	SPY	ETF	438.8	438.87	438.72	438.72	4710.0
2021-07-26 07:10:00	SPY	ETF	438.74	438.74	438.59	438.68	15207.0
2021-07-26 07:15:00	SPY	ETF	438.7	438.79	438.69	438.76	4680.0
2021-07-26 07:20:00	SPY	ETF	438.75	438.75	438.55	438.69	25434.0
2021-07-26 07:25:00	SPY	ETF	438.76	438.8	438.68	438.74	12460.0
2021-07-26 07:30:00	SPY	ETF	438.76	438.83	438.76	438.81	3380.0
2021-07-26 07:35:00	SPY	ETF	438.83	439.24	438.83	439.2	22885.0
2021-07-26 07:40:00	SPY	ETF	439.2	439.34	439.16	439.19	25307.0
2021-07-26 07:45:00	SPY	ETF	439.16	439.18	439.09	439.13	58929.0
2021-07-26 07:50:00	SPY	ETF	439.09	439.12	438.95	439.07	27554.0
2021-07-26 07:55:00	SPY	ETF	438.93	439.11	438.88	439.11	11279.0
2021-07-26 08:00:00	SPY	ETF	438.6801	439.26	438.0	439.2	46504.0
2021-07-26 08:05:00	SPY	ETF	439.17	439.21	439.0	439.12	20027.0
2021-07-26 08:10:00	SPY	ETF	439.17	439.25	439.13	439.15	10335.0
2021-07-26 08:15:00	SPY	ETF	439.17	439.2	439.09	439.1	4075.0
2021-07-26 08:20:00	SPY	ETF	439.11	439.27	439.11	439.2589	15126.0
2021-07-26 08:25:00	SPY	ETF	439.24	439.25	439.15	439.15	6079.0
2021-07-26 08:30:00	SPY	ETF	439.11	439.11	438.85	438.86	20475.0

> showing 50 of 80,463 rows — these rows as CSV

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