PREVIEW / etf_1min / 2008-10-09

all etf 1-min files

  file:    by_date/etf_1min/2008/2008-10-09.parquet
  size:    1.4 MB
  rows:    86,370

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-10-09 04:15:00	SPY	ETF	100.27	100.27	100.22	100.22	1400.0
2008-10-09 04:16:00	SPY	ETF	100.29	100.3	100.29	100.3	2700.0
2008-10-09 04:19:00	SPY	ETF	100.33	100.33	100.33	100.33	100.0
2008-10-09 04:21:00	SPY	ETF	100.23	100.23	100.2	100.2	200.0
2008-10-09 04:29:00	SPY	ETF	100.08	100.08	100.08	100.08	100.0
2008-10-09 04:33:00	SPY	ETF	100.2	100.2	100.2	100.2	100.0
2008-10-09 04:42:00	SPY	ETF	100.2	100.23	100.2	100.23	1100.0
2008-10-09 04:43:00	SPY	ETF	100.15	100.15	100.15	100.15	1000.0
2008-10-09 04:55:00	SPY	ETF	100.47	100.47	100.47	100.47	2500.0
2008-10-09 04:57:00	SPY	ETF	100.4	100.4	100.4	100.4	1100.0
2008-10-09 05:02:00	SPY	ETF	100.4	100.4	100.4	100.4	1400.0
2008-10-09 05:03:00	SPY	ETF	100.3	100.3	100.3	100.3	2500.0
2008-10-09 05:04:00	SPY	ETF	100.25	100.25	100.25	100.25	2500.0
2008-10-09 05:14:00	SPY	ETF	100.17	100.17	100.17	100.17	100.0
2008-10-09 05:20:00	SPY	ETF	100.0	100.0	100.0	100.0	100.0
2008-10-09 05:23:00	SPY	ETF	99.9	99.9	99.9	99.9	200.0
2008-10-09 05:24:00	SPY	ETF	99.75	99.75	99.75	99.75	2500.0
2008-10-09 05:27:00	SPY	ETF	99.75	99.75	99.75	99.75	100.0
2008-10-09 05:32:00	SPY	ETF	99.95	99.95	99.95	99.95	10000.0
2008-10-09 05:37:00	SPY	ETF	99.82	99.82	99.82	99.82	5000.0
2008-10-09 05:45:00	SPY	ETF	99.5	99.5	99.5	99.5	2600.0
2008-10-09 05:48:00	SPY	ETF	99.25	99.25	99.25	99.25	2500.0
2008-10-09 05:49:00	SPY	ETF	99.23	99.23	99.23	99.23	200.0
2008-10-09 05:57:00	SPY	ETF	99.5	99.5	99.5	99.5	100.0
2008-10-09 05:58:00	SPY	ETF	99.46	99.47	99.46	99.47	1900.0
2008-10-09 05:59:00	SPY	ETF	99.47	99.47	99.47	99.47	100.0
2008-10-09 06:01:00	SPY	ETF	99.4	99.4	99.4	99.4	1500.0
2008-10-09 06:06:00	SPY	ETF	99.48	99.48	99.47	99.47	12800.0
2008-10-09 06:07:00	SPY	ETF	99.47	99.47	99.47	99.47	13700.0
2008-10-09 06:08:00	SPY	ETF	99.47	99.47	99.47	99.47	8100.0
2008-10-09 06:09:00	SPY	ETF	99.47	99.62	99.47	99.62	16400.0
2008-10-09 06:19:00	SPY	ETF	99.33	99.33	99.33	99.33	100.0
2008-10-09 06:24:00	SPY	ETF	99.0	99.0	99.0	99.0	2500.0
2008-10-09 06:28:00	SPY	ETF	99.22	99.22	99.22	99.22	1000.0
2008-10-09 06:29:00	SPY	ETF	99.28	99.28	99.19	99.19	2000.0
2008-10-09 06:30:00	SPY	ETF	99.17	99.2	99.1	99.1	9500.0
2008-10-09 06:31:00	SPY	ETF	99.16	99.16	99.08	99.08	7000.0
2008-10-09 06:36:00	SPY	ETF	99.07	99.07	99.04	99.04	3000.0
2008-10-09 06:37:00	SPY	ETF	99.09	99.27	99.09	99.27	1100.0
2008-10-09 06:38:00	SPY	ETF	99.16	99.19	99.16	99.19	1100.0
2008-10-09 06:48:00	SPY	ETF	99.13	99.13	99.08	99.08	10000.0
2008-10-09 06:51:00	SPY	ETF	99.0	99.0	99.0	99.0	10000.0
2008-10-09 06:52:00	SPY	ETF	99.15	99.15	99.15	99.15	100.0
2008-10-09 06:53:00	SPY	ETF	99.28	99.28	99.25	99.25	5000.0
2008-10-09 06:54:00	SPY	ETF	99.28	99.34	99.28	99.34	10100.0
2008-10-09 06:55:00	SPY	ETF	99.33	99.45	99.33	99.45	10000.0
2008-10-09 06:56:00	SPY	ETF	99.35	99.38	99.35	99.38	5000.0
2008-10-09 06:58:00	SPY	ETF	99.36	99.39	99.36	99.39	4000.0
2008-10-09 06:59:00	SPY	ETF	99.28	99.44	99.28	99.44	3500.0
2008-10-09 07:00:00	SPY	ETF	99.5	99.5	99.3	99.3	20000.0

> showing 50 of 86,370 rows — these rows as CSV

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