PREVIEW / etf_5min / 2021-07-22

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-22.parquet
  size:    1.6 MB
  rows:    76,473

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-22 04:00:00	SPY	ETF	435.04	435.06	435.03	435.04	915.0
2021-07-22 04:05:00	SPY	ETF	435.24	435.24	435.19	435.19	700.0
2021-07-22 04:10:00	SPY	ETF	435.22	435.23	435.1	435.13	7200.0
2021-07-22 04:15:00	SPY	ETF	435.07	435.09	435.06	435.09	3497.0
2021-07-22 04:20:00	SPY	ETF	435.09	435.12	435.06	435.12	6000.0
2021-07-22 04:25:00	SPY	ETF	435.24	435.24	435.24	435.24	300.0
2021-07-22 04:30:00	SPY	ETF	435.21	435.21	435.21	435.21	100.0
2021-07-22 04:35:00	SPY	ETF	435.24	435.25	435.17	435.17	2300.0
2021-07-22 04:40:00	SPY	ETF	435.19	435.19	435.19	435.19	1600.0
2021-07-22 04:45:00	SPY	ETF	435.26	435.29	435.19	435.19	1896.0
2021-07-22 04:50:00	SPY	ETF	435.11	435.11	435.11	435.11	100.0
2021-07-22 04:55:00	SPY	ETF	435.18	435.21	435.15	435.21	1100.0
2021-07-22 05:00:00	SPY	ETF	435.19	435.19	435.18	435.18	400.0
2021-07-22 05:10:00	SPY	ETF	435.19	435.21	435.19	435.21	300.0
2021-07-22 05:15:00	SPY	ETF	435.25	435.25	435.25	435.25	100.0
2021-07-22 05:20:00	SPY	ETF	435.27	435.29	435.27	435.29	700.0
2021-07-22 05:25:00	SPY	ETF	435.3	435.36	435.27	435.36	1450.0
2021-07-22 05:30:00	SPY	ETF	435.38	435.38	435.31	435.31	1298.0
2021-07-22 05:35:00	SPY	ETF	435.27	435.4	435.27	435.4	400.0
2021-07-22 05:40:00	SPY	ETF	435.37	435.38	435.35	435.38	2600.0
2021-07-22 05:45:00	SPY	ETF	435.4	435.41	435.39	435.41	3050.0
2021-07-22 05:55:00	SPY	ETF	435.4	435.4	435.33	435.33	3730.0
2021-07-22 06:00:00	SPY	ETF	435.34	435.34	435.33	435.33	974.0
2021-07-22 06:05:00	SPY	ETF	435.25	435.25	435.25	435.25	100.0
2021-07-22 06:20:00	SPY	ETF	435.31	435.34	435.31	435.34	3600.0
2021-07-22 06:25:00	SPY	ETF	435.29	435.31	435.28	435.3	10484.0
2021-07-22 06:30:00	SPY	ETF	435.3	435.32	435.3	435.3	11462.0
2021-07-22 06:35:00	SPY	ETF	435.35	435.35	435.35	435.35	700.0
2021-07-22 06:40:00	SPY	ETF	435.33	435.41	435.33	435.41	3800.0
2021-07-22 06:45:00	SPY	ETF	435.45	435.5	435.45	435.5	3886.0
2021-07-22 06:50:00	SPY	ETF	435.56	435.59	435.56	435.59	422.0
2021-07-22 06:55:00	SPY	ETF	435.53	435.56	435.51	435.51	3040.0
2021-07-22 07:00:00	SPY	ETF	435.5	435.51	435.35	435.35	39697.0
2021-07-22 07:05:00	SPY	ETF	435.35	435.36	435.31	435.36	9149.0
2021-07-22 07:10:00	SPY	ETF	435.32	435.32	435.25	435.29	2780.0
2021-07-22 07:15:00	SPY	ETF	435.33	435.37	435.23	435.24	4940.0
2021-07-22 07:20:00	SPY	ETF	435.24	435.24	435.15	435.16	5503.0
2021-07-22 07:25:00	SPY	ETF	435.15	435.15	435.01	435.06	3775.0
2021-07-22 07:30:00	SPY	ETF	435.04	435.11	435.04	435.11	2925.0
2021-07-22 07:35:00	SPY	ETF	435.19	435.2	435.11	435.2	3894.0
2021-07-22 07:40:00	SPY	ETF	435.19	435.19	434.89	434.95	8917.0
2021-07-22 07:45:00	SPY	ETF	434.96	435.15	434.94	435.03	16867.0
2021-07-22 07:50:00	SPY	ETF	434.98	435.09	434.98	435.05	14784.0
2021-07-22 07:55:00	SPY	ETF	435.09	435.18	435.06	435.16	13889.0
2021-07-22 08:00:00	SPY	ETF	435.45	435.5296	434.88	434.88	34031.0
2021-07-22 08:05:00	SPY	ETF	434.89	434.95	434.76	434.82	28722.0
2021-07-22 08:10:00	SPY	ETF	434.89	434.98	434.77	434.96	8969.0
2021-07-22 08:15:00	SPY	ETF	434.97	434.98	434.94	434.98	3950.0
2021-07-22 08:20:00	SPY	ETF	434.98	435.06	434.96	435.04	5967.0
2021-07-22 08:25:00	SPY	ETF	435.04	435.06	434.9	434.98	7015.0

> showing 50 of 76,473 rows — these rows as CSV

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