PREVIEW / etf_1min / 2008-07-23

all etf 1-min files

  file:    by_date/etf_1min/2008/2008-07-23.parquet
  size:    1.3 MB
  rows:    78,306

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
2008-07-23 04:17:00	SPY	ETF	127.97	127.97	127.97	127.97	1000.0
2008-07-23 04:49:00	SPY	ETF	128.22	128.22	128.21	128.21	42000.0
2008-07-23 04:50:00	SPY	ETF	128.21	128.21	128.21	128.21	24000.0
2008-07-23 04:51:00	SPY	ETF	128.23	128.25	128.23	128.25	81100.0
2008-07-23 05:52:00	SPY	ETF	128.13	128.14	128.13	128.14	5000.0
2008-07-23 05:57:00	SPY	ETF	128.15	128.15	128.15	128.15	3000.0
2008-07-23 06:10:00	SPY	ETF	128.2	128.2	128.2	128.2	800.0
2008-07-23 06:11:00	SPY	ETF	128.24	128.24	128.24	128.24	4200.0
2008-07-23 06:12:00	SPY	ETF	128.25	128.25	128.25	128.25	30000.0
2008-07-23 06:13:00	SPY	ETF	128.19	128.19	128.19	128.19	2000.0
2008-07-23 06:15:00	SPY	ETF	128.19	128.19	128.19	128.19	500.0
2008-07-23 06:16:00	SPY	ETF	128.17	128.17	128.14	128.14	21500.0
2008-07-23 06:17:00	SPY	ETF	128.17	128.17	128.15	128.15	8100.0
2008-07-23 06:18:00	SPY	ETF	128.17	128.17	128.14	128.14	7500.0
2008-07-23 06:24:00	SPY	ETF	128.16	128.19	128.16	128.19	5000.0
2008-07-23 06:27:00	SPY	ETF	128.16	128.16	128.16	128.16	25000.0
2008-07-23 06:28:00	SPY	ETF	128.16	128.16	128.16	128.16	300.0
2008-07-23 06:29:00	SPY	ETF	128.18	128.19	128.11	128.18	2500.0
2008-07-23 06:30:00	SPY	ETF	128.14	128.17	128.14	128.14	1700.0
2008-07-23 06:31:00	SPY	ETF	128.2	128.2	128.2	128.2	400.0
2008-07-23 06:33:00	SPY	ETF	128.16	128.16	128.16	128.16	1000.0
2008-07-23 06:35:00	SPY	ETF	128.14	128.14	128.14	128.14	400.0
2008-07-23 06:37:00	SPY	ETF	128.18	128.18	128.15	128.15	900.0
2008-07-23 06:38:00	SPY	ETF	128.13	128.15	128.07	128.11	3400.0
2008-07-23 06:39:00	SPY	ETF	128.04	128.04	128.04	128.04	3000.0
2008-07-23 06:41:00	SPY	ETF	128.1	128.17	128.1	128.17	25000.0
2008-07-23 06:48:00	SPY	ETF	128.11	128.11	128.11	128.11	200.0
2008-07-23 06:49:00	SPY	ETF	128.12	128.13	128.12	128.13	5000.0
2008-07-23 06:50:00	SPY	ETF	128.05	128.05	128.05	128.05	200.0
2008-07-23 06:54:00	SPY	ETF	128.09	128.09	128.09	128.09	500.0
2008-07-23 06:55:00	SPY	ETF	128.09	128.13	128.09	128.13	2700.0
2008-07-23 06:57:00	SPY	ETF	128.06	128.1	128.05	128.1	1400.0
2008-07-23 06:58:00	SPY	ETF	128.05	128.12	128.05	128.05	2500.0
2008-07-23 06:59:00	SPY	ETF	128.08	128.08	128.08	128.08	2000.0
2008-07-23 07:00:00	SPY	ETF	127.99	128.05	127.99	128.04	90000.0
2008-07-23 07:01:00	SPY	ETF	128.04	128.04	128.04	128.04	18200.0
2008-07-23 07:02:00	SPY	ETF	128.01	128.11	128.01	128.11	19700.0
2008-07-23 07:03:00	SPY	ETF	128.1	128.1	128.1	128.1	1000.0
2008-07-23 07:04:00	SPY	ETF	128.06	128.08	128.06	128.08	568.0
2008-07-23 07:05:00	SPY	ETF	128.08	128.08	128.08	128.08	1000.0
2008-07-23 07:06:00	SPY	ETF	128.05	128.05	128.02	128.02	17000.0
2008-07-23 07:07:00	SPY	ETF	128.02	128.06	128.02	128.06	291.0
2008-07-23 07:10:00	SPY	ETF	128.03	128.03	128.03	128.03	25286.0
2008-07-23 07:11:00	SPY	ETF	128.03	128.03	128.02	128.03	27000.0
2008-07-23 07:12:00	SPY	ETF	128.04	128.04	128.03	128.03	25604.0
2008-07-23 07:13:00	SPY	ETF	128.03	128.03	127.99	128.03	5418.0
2008-07-23 07:14:00	SPY	ETF	128.01	128.05	128.01	128.05	16800.0
2008-07-23 07:15:00	SPY	ETF	128.05	128.06	128.05	128.06	1100.0
2008-07-23 07:16:00	SPY	ETF	128.09	128.09	128.01	128.06	75167.0
2008-07-23 07:17:00	SPY	ETF	128.07	128.07	128.06	128.07	8300.0

> showing 50 of 78,306 rows — these rows as CSV

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