PREVIEW / etf_1min / 2007-05-24

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-05-24.parquet
  size:    744 KB
  rows:    45,445

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-05-24 04:15:00	SPY	ETF	152.15	152.15	152.15	152.15	100.0
2007-05-24 06:09:00	SPY	ETF	152.27	152.27	152.27	152.27	5000.0
2007-05-24 07:02:00	SPY	ETF	152.27	152.27	152.27	152.27	5000.0
2007-05-24 07:03:00	SPY	ETF	152.26	152.29	152.26	152.29	5100.0
2007-05-24 07:05:00	SPY	ETF	152.33	152.33	152.33	152.33	25000.0
2007-05-24 07:06:00	SPY	ETF	152.33	152.33	152.33	152.33	5000.0
2007-05-24 07:07:00	SPY	ETF	152.3	152.3	152.3	152.3	44700.0
2007-05-24 07:09:00	SPY	ETF	152.33	152.33	152.33	152.33	35000.0
2007-05-24 07:10:00	SPY	ETF	152.33	152.35	152.33	152.35	10000.0
2007-05-24 07:13:00	SPY	ETF	152.35	152.36	152.35	152.35	8200.0
2007-05-24 07:15:00	SPY	ETF	152.36	152.36	152.36	152.36	3000.0
2007-05-24 07:17:00	SPY	ETF	152.36	152.36	152.32	152.32	5500.0
2007-05-24 07:18:00	SPY	ETF	152.37	152.37	152.37	152.37	10000.0
2007-05-24 07:19:00	SPY	ETF	152.34	152.34	152.34	152.34	1000.0
2007-05-24 07:20:00	SPY	ETF	152.37	152.37	152.36	152.36	103300.0
2007-05-24 07:21:00	SPY	ETF	152.36	152.36	152.36	152.36	4700.0
2007-05-24 07:23:00	SPY	ETF	152.39	152.39	152.39	152.39	7500.0
2007-05-24 07:24:00	SPY	ETF	152.37	152.37	152.37	152.37	500.0
2007-05-24 07:26:00	SPY	ETF	152.41	152.41	152.41	152.41	500.0
2007-05-24 07:27:00	SPY	ETF	152.4	152.4	152.4	152.4	300.0
2007-05-24 07:28:00	SPY	ETF	152.37	152.37	152.37	152.37	700.0
2007-05-24 07:33:00	SPY	ETF	152.37	152.37	152.37	152.37	100.0
2007-05-24 07:38:00	SPY	ETF	152.34	152.34	152.32	152.32	7600.0
2007-05-24 07:39:00	SPY	ETF	152.35	152.35	152.35	152.35	500.0
2007-05-24 07:40:00	SPY	ETF	152.33	152.33	152.3	152.3	2100.0
2007-05-24 07:41:00	SPY	ETF	152.3	152.3	152.3	152.3	1000.0
2007-05-24 07:42:00	SPY	ETF	152.3	152.3	152.3	152.3	600.0
2007-05-24 07:43:00	SPY	ETF	152.3	152.3	152.3	152.3	1700.0
2007-05-24 07:44:00	SPY	ETF	152.29	152.29	152.29	152.29	4500.0
2007-05-24 07:45:00	SPY	ETF	152.29	152.3	152.29	152.3	500.0
2007-05-24 07:46:00	SPY	ETF	152.31	152.31	152.31	152.31	3000.0
2007-05-24 07:47:00	SPY	ETF	152.3	152.3	152.29	152.29	5500.0
2007-05-24 07:50:00	SPY	ETF	152.29	152.29	152.29	152.29	4900.0
2007-05-24 07:53:00	SPY	ETF	152.35	152.35	152.35	152.35	6600.0
2007-05-24 07:54:00	SPY	ETF	152.35	152.35	152.35	152.35	100.0
2007-05-24 07:55:00	SPY	ETF	152.35	152.35	152.35	152.35	2500.0
2007-05-24 07:56:00	SPY	ETF	152.35	152.35	152.35	152.35	24800.0
2007-05-24 07:57:00	SPY	ETF	152.35	152.35	152.34	152.34	3800.0
2007-05-24 07:58:00	SPY	ETF	152.33	152.33	152.33	152.33	1000.0
2007-05-24 07:59:00	SPY	ETF	152.32	152.32	152.31	152.32	5000.0
2007-05-24 08:00:00	SPY	ETF	152.24	152.35	152.24	152.35	191200.0
2007-05-24 08:01:00	SPY	ETF	152.29	152.3	152.29	152.3	2500.0
2007-05-24 08:02:00	SPY	ETF	152.27	152.27	152.27	152.27	5000.0
2007-05-24 08:03:00	SPY	ETF	152.27	152.3	152.27	152.28	33100.0
2007-05-24 08:04:00	SPY	ETF	152.28	152.28	152.28	152.28	5000.0
2007-05-24 08:05:00	SPY	ETF	152.28	152.28	152.28	152.28	2500.0
2007-05-24 08:06:00	SPY	ETF	152.33	152.33	152.33	152.33	1100.0
2007-05-24 08:08:00	SPY	ETF	152.26	152.26	152.26	152.26	1500.0
2007-05-24 08:09:00	SPY	ETF	152.28	152.28	152.28	152.28	500.0
2007-05-24 08:11:00	SPY	ETF	152.28	152.28	152.28	152.28	200.0

> showing 50 of 45,445 rows — these rows as CSV

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