PREVIEW / etf_1min / 2009-01-29

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-01-29.parquet
  size:    1.5 MB
  rows:    85,425

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
2009-01-29 04:05:00	SPY	ETF	86.6	86.6	86.6	86.6	3000.0
2009-01-29 04:15:00	SPY	ETF	86.42	86.43	86.37	86.37	8200.0
2009-01-29 04:16:00	SPY	ETF	86.35	86.35	86.35	86.35	100.0
2009-01-29 04:17:00	SPY	ETF	86.33	86.33	86.33	86.33	200.0
2009-01-29 04:19:00	SPY	ETF	86.35	86.35	86.35	86.35	1100.0
2009-01-29 04:24:00	SPY	ETF	86.33	86.33	86.3	86.3	600.0
2009-01-29 04:25:00	SPY	ETF	86.25	86.25	86.25	86.25	100.0
2009-01-29 04:26:00	SPY	ETF	86.2	86.2	86.12	86.12	200.0
2009-01-29 04:27:00	SPY	ETF	86.16	86.16	86.15	86.15	850.0
2009-01-29 04:28:00	SPY	ETF	86.08	86.08	86.08	86.08	100.0
2009-01-29 04:29:00	SPY	ETF	86.15	86.15	86.15	86.15	500.0
2009-01-29 04:30:00	SPY	ETF	86.14	86.14	86.14	86.14	750.0
2009-01-29 04:36:00	SPY	ETF	86.1	86.1	86.1	86.1	200.0
2009-01-29 04:39:00	SPY	ETF	86.15	86.15	86.15	86.15	500.0
2009-01-29 04:44:00	SPY	ETF	86.15	86.15	86.15	86.15	100.0
2009-01-29 04:45:00	SPY	ETF	86.2	86.22	86.2	86.22	200.0
2009-01-29 04:46:00	SPY	ETF	86.2	86.2	86.2	86.2	1000.0
2009-01-29 04:47:00	SPY	ETF	86.15	86.15	86.15	86.15	1000.0
2009-01-29 04:48:00	SPY	ETF	86.18	86.23	86.18	86.23	200.0
2009-01-29 04:49:00	SPY	ETF	86.2	86.2	86.2	86.2	100.0
2009-01-29 04:50:00	SPY	ETF	86.23	86.23	86.2	86.2	600.0
2009-01-29 04:55:00	SPY	ETF	86.3	86.3	86.25	86.25	200.0
2009-01-29 05:04:00	SPY	ETF	86.53	86.53	86.53	86.53	100.0
2009-01-29 05:06:00	SPY	ETF	86.58	86.58	86.58	86.58	100.0
2009-01-29 05:08:00	SPY	ETF	86.51	86.51	86.51	86.51	500.0
2009-01-29 05:13:00	SPY	ETF	86.56	86.56	86.56	86.56	100.0
2009-01-29 05:23:00	SPY	ETF	86.45	86.45	86.45	86.45	100.0
2009-01-29 05:24:00	SPY	ETF	86.46	86.46	86.46	86.46	1000.0
2009-01-29 05:28:00	SPY	ETF	86.45	86.45	86.45	86.45	400.0
2009-01-29 05:33:00	SPY	ETF	86.45	86.45	86.45	86.45	100.0
2009-01-29 05:36:00	SPY	ETF	86.53	86.53	86.53	86.53	100.0
2009-01-29 05:47:00	SPY	ETF	86.57	86.57	86.57	86.57	100.0
2009-01-29 06:00:00	SPY	ETF	86.67	86.68	86.67	86.68	10000.0
2009-01-29 06:05:00	SPY	ETF	86.45	86.45	86.45	86.45	100.0
2009-01-29 06:06:00	SPY	ETF	86.46	86.53	86.46	86.53	500.0
2009-01-29 06:10:00	SPY	ETF	86.43	86.43	86.4	86.4	400.0
2009-01-29 06:12:00	SPY	ETF	86.48	86.48	86.48	86.48	1800.0
2009-01-29 06:14:00	SPY	ETF	86.51	86.51	86.51	86.51	100.0
2009-01-29 06:19:00	SPY	ETF	86.55	86.55	86.55	86.55	7500.0
2009-01-29 06:24:00	SPY	ETF	86.43	86.43	86.43	86.43	100.0
2009-01-29 06:27:00	SPY	ETF	86.39	86.39	86.39	86.39	100.0
2009-01-29 06:29:00	SPY	ETF	86.45	86.45	86.45	86.45	1500.0
2009-01-29 06:31:00	SPY	ETF	86.47	86.47	86.47	86.47	500.0
2009-01-29 06:32:00	SPY	ETF	86.5	86.5	86.5	86.5	1000.0
2009-01-29 06:34:00	SPY	ETF	86.44	86.44	86.44	86.44	500.0
2009-01-29 06:35:00	SPY	ETF	86.43	86.43	86.43	86.43	500.0
2009-01-29 06:36:00	SPY	ETF	86.46	86.46	86.41	86.41	26000.0
2009-01-29 06:37:00	SPY	ETF	86.39	86.39	86.33	86.33	1100.0
2009-01-29 06:38:00	SPY	ETF	86.31	86.31	86.31	86.31	100.0
2009-01-29 06:40:00	SPY	ETF	86.41	86.41	86.41	86.41	500.0

> showing 50 of 85,425 rows — these rows as CSV

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