PREVIEW / etf_1min / 2007-09-05

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-09-05.parquet
  size:    706 KB
  rows:    47,967

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-09-05 04:09:00	SPY	ETF	148.42	148.42	148.42	148.42	3000.0
2007-09-05 04:19:00	SPY	ETF	148.5	148.5	148.5	148.5	3000.0
2007-09-05 04:23:00	SPY	ETF	148.5	148.5	148.5	148.5	1000.0
2007-09-05 06:00:00	SPY	ETF	148.21	148.21	148.21	148.21	1000.0
2007-09-05 06:20:00	SPY	ETF	148.41	148.41	148.41	148.41	1900.0
2007-09-05 06:21:00	SPY	ETF	148.4	148.4	148.4	148.4	4900.0
2007-09-05 06:22:00	SPY	ETF	148.45	148.48	148.45	148.45	10600.0
2007-09-05 06:24:00	SPY	ETF	148.43	148.43	148.43	148.43	2000.0
2007-09-05 06:31:00	SPY	ETF	148.33	148.33	148.33	148.33	1000.0
2007-09-05 06:32:00	SPY	ETF	148.31	148.31	148.31	148.31	8100.0
2007-09-05 06:37:00	SPY	ETF	148.27	148.27	147.97	147.97	24500.0
2007-09-05 06:38:00	SPY	ETF	148.03	148.03	148.03	148.03	200.0
2007-09-05 06:39:00	SPY	ETF	148.06	148.06	148.03	148.03	2700.0
2007-09-05 06:40:00	SPY	ETF	148.01	148.01	148.01	148.01	100.0
2007-09-05 06:43:00	SPY	ETF	148.11	148.11	148.11	148.11	2000.0
2007-09-05 06:47:00	SPY	ETF	148.03	148.03	147.98	147.98	2100.0
2007-09-05 06:48:00	SPY	ETF	148.01	148.01	147.97	147.97	13400.0
2007-09-05 06:52:00	SPY	ETF	148.07	148.07	148.07	148.07	1000.0
2007-09-05 06:56:00	SPY	ETF	148.09	148.09	148.09	148.09	300.0
2007-09-05 06:57:00	SPY	ETF	148.09	148.09	148.09	148.09	5000.0
2007-09-05 06:58:00	SPY	ETF	148.07	148.07	148.07	148.07	100.0
2007-09-05 07:00:00	SPY	ETF	148.09	148.11	148.08	148.08	87200.0
2007-09-05 07:01:00	SPY	ETF	148.01	148.02	148.01	148.02	5600.0
2007-09-05 07:02:00	SPY	ETF	148.02	148.02	148.0	148.0	3200.0
2007-09-05 07:03:00	SPY	ETF	147.96	148.05	147.9	148.05	37500.0
2007-09-05 07:04:00	SPY	ETF	148.05	148.07	148.0	148.0	36600.0
2007-09-05 07:05:00	SPY	ETF	148.04	148.07	148.04	148.07	66200.0
2007-09-05 07:06:00	SPY	ETF	148.07	148.07	148.05	148.05	3000.0
2007-09-05 07:07:00	SPY	ETF	148.04	148.04	148.02	148.02	1700.0
2007-09-05 07:08:00	SPY	ETF	147.99	148.02	147.99	147.99	52000.0
2007-09-05 07:09:00	SPY	ETF	147.98	148.04	147.97	148.04	8000.0
2007-09-05 07:10:00	SPY	ETF	148.03	148.03	148.03	148.03	25700.0
2007-09-05 07:11:00	SPY	ETF	148.0	148.0	148.0	148.0	5300.0
2007-09-05 07:13:00	SPY	ETF	148.08	148.14	148.08	148.12	3700.0
2007-09-05 07:14:00	SPY	ETF	148.12	148.14	148.1	148.1	5600.0
2007-09-05 07:15:00	SPY	ETF	148.12	148.12	148.12	148.12	25000.0
2007-09-05 07:16:00	SPY	ETF	148.09	148.09	148.09	148.09	5000.0
2007-09-05 07:17:00	SPY	ETF	148.07	148.07	148.05	148.05	200.0
2007-09-05 07:18:00	SPY	ETF	148.02	148.09	148.02	148.09	22500.0
2007-09-05 07:19:00	SPY	ETF	148.1	148.12	148.1	148.12	101200.0
2007-09-05 07:20:00	SPY	ETF	148.12	148.12	148.12	148.12	2000.0
2007-09-05 07:21:00	SPY	ETF	148.1	148.1	148.1	148.1	3200.0
2007-09-05 07:22:00	SPY	ETF	148.1	148.1	148.02	148.02	6200.0
2007-09-05 07:23:00	SPY	ETF	148.03	148.03	148.02	148.02	5000.0
2007-09-05 07:24:00	SPY	ETF	148.04	148.05	148.02	148.05	300.0
2007-09-05 07:25:00	SPY	ETF	148.01	148.01	148.0	148.0	11900.0
2007-09-05 07:26:00	SPY	ETF	147.97	147.97	147.97	147.97	500.0
2007-09-05 07:27:00	SPY	ETF	147.98	147.99	147.97	147.97	27500.0
2007-09-05 07:28:00	SPY	ETF	148.04	148.04	147.99	148.0	38300.0
2007-09-05 07:29:00	SPY	ETF	147.99	147.99	147.95	147.95	9400.0

> showing 50 of 47,967 rows — these rows as CSV

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