PREVIEW / etf_1min / 2007-08-20

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-08-20.parquet
  size:    788 KB
  rows:    50,263

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-08-20 05:57:00	SPY	ETF	145.0	145.0	145.0	145.0	500.0
2007-08-20 05:59:00	SPY	ETF	144.88	144.88	144.88	144.88	500.0
2007-08-20 06:01:00	SPY	ETF	144.9	144.9	144.9	144.9	500.0
2007-08-20 06:04:00	SPY	ETF	144.93	144.93	144.93	144.93	300.0
2007-08-20 06:09:00	SPY	ETF	144.8	144.8	144.8	144.8	4900.0
2007-08-20 06:14:00	SPY	ETF	144.8	144.8	144.8	144.8	100.0
2007-08-20 06:23:00	SPY	ETF	144.92	144.95	144.92	144.95	8000.0
2007-08-20 06:25:00	SPY	ETF	144.95	144.95	144.95	144.95	2500.0
2007-08-20 06:30:00	SPY	ETF	145.13	145.13	145.13	145.13	500.0
2007-08-20 06:32:00	SPY	ETF	145.2	145.2	145.2	145.2	8000.0
2007-08-20 06:47:00	SPY	ETF	145.27	145.27	145.27	145.27	5000.0
2007-08-20 06:48:00	SPY	ETF	145.27	145.27	145.27	145.27	15000.0
2007-08-20 06:53:00	SPY	ETF	145.32	145.32	145.32	145.32	1500.0
2007-08-20 06:56:00	SPY	ETF	145.37	145.37	145.37	145.37	3000.0
2007-08-20 07:01:00	SPY	ETF	145.27	145.27	145.25	145.27	11000.0
2007-08-20 07:02:00	SPY	ETF	145.22	145.22	145.22	145.22	500.0
2007-08-20 07:03:00	SPY	ETF	145.27	145.27	145.27	145.27	1700.0
2007-08-20 07:04:00	SPY	ETF	145.33	145.33	145.33	145.33	200.0
2007-08-20 07:05:00	SPY	ETF	145.25	145.25	145.25	145.25	1000.0
2007-08-20 07:06:00	SPY	ETF	145.22	145.22	145.22	145.22	900.0
2007-08-20 07:07:00	SPY	ETF	145.22	145.22	145.07	145.07	5800.0
2007-08-20 07:10:00	SPY	ETF	145.1	145.1	145.1	145.1	3500.0
2007-08-20 07:11:00	SPY	ETF	145.15	145.15	145.12	145.12	2000.0
2007-08-20 07:12:00	SPY	ETF	145.1	145.1	145.08	145.08	700.0
2007-08-20 07:13:00	SPY	ETF	144.97	144.97	144.92	144.92	28000.0
2007-08-20 07:14:00	SPY	ETF	144.97	144.97	144.97	144.97	1500.0
2007-08-20 07:15:00	SPY	ETF	144.93	144.93	144.9	144.9	13500.0
2007-08-20 07:16:00	SPY	ETF	144.95	144.98	144.9	144.98	20000.0
2007-08-20 07:17:00	SPY	ETF	144.98	145.0	144.98	145.0	2900.0
2007-08-20 07:18:00	SPY	ETF	144.99	144.99	144.99	144.99	2800.0
2007-08-20 07:19:00	SPY	ETF	144.99	145.0	144.99	144.99	1500.0
2007-08-20 07:20:00	SPY	ETF	144.97	144.97	144.97	144.97	5000.0
2007-08-20 07:21:00	SPY	ETF	144.9	144.9	144.9	144.9	10000.0
2007-08-20 07:22:00	SPY	ETF	144.95	144.95	144.95	144.95	500.0
2007-08-20 07:23:00	SPY	ETF	144.96	144.96	144.96	144.96	1000.0
2007-08-20 07:24:00	SPY	ETF	144.96	144.96	144.95	144.96	2900.0
2007-08-20 07:25:00	SPY	ETF	144.97	145.0	144.97	145.0	12200.0
2007-08-20 07:28:00	SPY	ETF	145.05	145.12	145.05	145.1	55500.0
2007-08-20 07:31:00	SPY	ETF	145.14	145.18	145.14	145.17	15900.0
2007-08-20 07:32:00	SPY	ETF	145.17	145.17	145.17	145.17	100.0
2007-08-20 07:33:00	SPY	ETF	145.11	145.11	145.1	145.11	51900.0
2007-08-20 07:34:00	SPY	ETF	145.03	145.03	145.0	145.0	2700.0
2007-08-20 07:35:00	SPY	ETF	145.05	145.05	145.05	145.05	100.0
2007-08-20 07:36:00	SPY	ETF	145.05	145.05	145.05	145.05	100.0
2007-08-20 07:37:00	SPY	ETF	145.05	145.05	145.05	145.05	12500.0
2007-08-20 07:38:00	SPY	ETF	145.1	145.1	145.1	145.1	22900.0
2007-08-20 07:39:00	SPY	ETF	145.11	145.12	145.11	145.12	2600.0
2007-08-20 07:40:00	SPY	ETF	145.12	145.12	145.04	145.05	24800.0
2007-08-20 07:41:00	SPY	ETF	145.03	145.03	145.03	145.03	1500.0
2007-08-20 07:42:00	SPY	ETF	145.07	145.07	145.07	145.07	500.0

> showing 50 of 50,263 rows — these rows as CSV

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