PREVIEW / etf_1min / 2007-01-22

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-01-22.parquet
  size:    601 KB
  rows:    36,355

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
2007-01-22 07:00:00	SPY	ETF	143.1	143.1	143.1	143.1	7000.0
2007-01-22 07:08:00	SPY	ETF	143.11	143.11	143.11	143.11	4900.0
2007-01-22 07:16:00	SPY	ETF	143.1	143.1	143.1	143.1	100.0
2007-01-22 07:19:00	SPY	ETF	143.13	143.13	143.13	143.13	3000.0
2007-01-22 08:00:00	SPY	ETF	143.12	143.12	143.12	143.12	400.0
2007-01-22 08:01:00	SPY	ETF	143.12	143.12	143.1	143.1	800.0
2007-01-22 08:03:00	SPY	ETF	143.15	143.15	143.11	143.12	25000.0
2007-01-22 08:09:00	SPY	ETF	143.1	143.1	143.1	143.1	3200.0
2007-01-22 08:13:00	SPY	ETF	143.04	143.04	143.04	143.04	100.0
2007-01-22 08:16:00	SPY	ETF	143.06	143.06	143.06	143.06	300.0
2007-01-22 08:17:00	SPY	ETF	143.09	143.09	143.09	143.09	49500.0
2007-01-22 08:18:00	SPY	ETF	143.1	143.1	143.1	143.1	25500.0
2007-01-22 08:20:00	SPY	ETF	143.12	143.13	143.12	143.13	9000.0
2007-01-22 08:21:00	SPY	ETF	143.13	143.13	143.13	143.13	2000.0
2007-01-22 08:22:00	SPY	ETF	143.06	143.06	143.06	143.06	200.0
2007-01-22 08:26:00	SPY	ETF	143.07	143.07	143.07	143.07	600.0
2007-01-22 08:27:00	SPY	ETF	143.08	143.08	143.08	143.08	300.0
2007-01-22 08:30:00	SPY	ETF	143.06	143.06	143.04	143.05	5900.0
2007-01-22 08:31:00	SPY	ETF	143.09	143.09	143.09	143.09	5000.0
2007-01-22 08:32:00	SPY	ETF	143.1	143.1	143.1	143.1	1000.0
2007-01-22 08:33:00	SPY	ETF	143.08	143.08	143.06	143.06	3000.0
2007-01-22 08:34:00	SPY	ETF	143.09	143.09	143.09	143.09	1000.0
2007-01-22 08:35:00	SPY	ETF	143.05	143.11	143.05	143.1	250200.0
2007-01-22 08:38:00	SPY	ETF	143.07	143.07	143.07	143.07	300.0
2007-01-22 08:44:00	SPY	ETF	143.05	143.05	143.05	143.05	100.0
2007-01-22 08:46:00	SPY	ETF	143.06	143.06	143.06	143.06	1100.0
2007-01-22 08:48:00	SPY	ETF	143.07	143.07	143.07	143.07	5000.0
2007-01-22 08:49:00	SPY	ETF	143.08	143.08	143.08	143.08	3000.0
2007-01-22 08:57:00	SPY	ETF	143.07	143.07	143.07	143.07	200.0
2007-01-22 09:00:00	SPY	ETF	143.1	143.1	143.1	143.1	3000.0
2007-01-22 09:03:00	SPY	ETF	143.07	143.1	143.07	143.08	2400.0
2007-01-22 09:04:00	SPY	ETF	143.1	143.1	143.1	143.1	25000.0
2007-01-22 09:05:00	SPY	ETF	143.09	143.09	143.08	143.08	4000.0
2007-01-22 09:06:00	SPY	ETF	143.06	143.06	143.06	143.06	2500.0
2007-01-22 09:08:00	SPY	ETF	143.07	143.08	143.07	143.08	10200.0
2007-01-22 09:10:00	SPY	ETF	143.06	143.06	143.06	143.06	200.0
2007-01-22 09:13:00	SPY	ETF	143.07	143.07	143.07	143.07	200.0
2007-01-22 09:15:00	SPY	ETF	143.06	143.07	143.05	143.05	7500.0
2007-01-22 09:17:00	SPY	ETF	143.04	143.04	143.04	143.04	12700.0
2007-01-22 09:22:00	SPY	ETF	143.04	143.04	143.04	143.04	1000.0
2007-01-22 09:24:00	SPY	ETF	143.04	143.04	143.04	143.04	1000.0
2007-01-22 09:25:00	SPY	ETF	143.04	143.04	143.04	143.04	1300.0
2007-01-22 09:26:00	SPY	ETF	143.06	143.06	143.05	143.05	3200.0
2007-01-22 09:29:00	SPY	ETF	143.06	143.06	143.06	143.06	19000.0
2007-01-22 09:30:00	SPY	ETF	143.07	143.09	142.95	142.98	247100.0
2007-01-22 09:31:00	SPY	ETF	142.98	143.02	142.96	143.0	262800.0
2007-01-22 09:32:00	SPY	ETF	143.01	143.1	143.0	143.07	132600.0
2007-01-22 09:33:00	SPY	ETF	143.07	143.09	143.03	143.04	119100.0
2007-01-22 09:34:00	SPY	ETF	143.04	143.04	142.95	142.95	100700.0
2007-01-22 09:35:00	SPY	ETF	142.95	143.0	142.9	142.9626	167800.0

> showing 50 of 36,355 rows — these rows as CSV

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