PREVIEW / etf_1min / 2007-11-09

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-11-09.parquet
  size:    1003 KB
  rows:    62,799

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-11-09 04:14:00	SPY	ETF	147.54	147.54	147.54	147.54	2000.0
2007-11-09 04:22:00	SPY	ETF	147.54	147.54	147.54	147.54	3000.0
2007-11-09 04:54:00	SPY	ETF	147.27	147.27	147.27	147.27	1000.0
2007-11-09 05:29:00	SPY	ETF	147.12	147.12	147.12	147.12	1000.0
2007-11-09 05:42:00	SPY	ETF	146.81	146.81	146.81	146.81	10000.0
2007-11-09 05:43:00	SPY	ETF	146.73	146.73	146.73	146.73	4000.0
2007-11-09 05:49:00	SPY	ETF	146.51	146.51	146.51	146.51	20000.0
2007-11-09 05:51:00	SPY	ETF	146.56	146.56	146.56	146.56	5000.0
2007-11-09 06:06:00	SPY	ETF	146.56	146.56	146.56	146.56	1000.0
2007-11-09 06:09:00	SPY	ETF	146.34	146.34	146.34	146.34	1000.0
2007-11-09 06:10:00	SPY	ETF	146.37	146.37	146.37	146.37	3000.0
2007-11-09 06:12:00	SPY	ETF	146.32	146.32	146.32	146.32	1000.0
2007-11-09 06:16:00	SPY	ETF	146.37	146.37	146.37	146.37	1000.0
2007-11-09 06:17:00	SPY	ETF	146.26	146.26	146.2	146.2	2000.0
2007-11-09 06:18:00	SPY	ETF	146.13	146.13	146.13	146.13	1000.0
2007-11-09 06:20:00	SPY	ETF	146.02	146.02	146.02	146.02	1000.0
2007-11-09 06:21:00	SPY	ETF	146.0	146.1	146.0	146.1	3500.0
2007-11-09 06:23:00	SPY	ETF	146.08	146.08	146.08	146.08	1000.0
2007-11-09 06:25:00	SPY	ETF	146.08	146.08	146.08	146.08	1000.0
2007-11-09 06:26:00	SPY	ETF	146.04	146.04	146.04	146.04	500.0
2007-11-09 06:27:00	SPY	ETF	146.05	146.05	146.05	146.05	32000.0
2007-11-09 06:28:00	SPY	ETF	146.01	146.01	146.0	146.0	2000.0
2007-11-09 06:29:00	SPY	ETF	145.95	145.95	145.95	145.95	1000.0
2007-11-09 06:31:00	SPY	ETF	145.91	145.91	145.72	145.72	10500.0
2007-11-09 06:32:00	SPY	ETF	145.72	145.72	145.66	145.66	4000.0
2007-11-09 06:33:00	SPY	ETF	145.65	145.65	145.6	145.6	16000.0
2007-11-09 06:36:00	SPY	ETF	145.75	145.77	145.75	145.77	8000.0
2007-11-09 06:37:00	SPY	ETF	145.8	145.8	145.8	145.8	11000.0
2007-11-09 06:38:00	SPY	ETF	145.81	145.81	145.8	145.81	15500.0
2007-11-09 06:41:00	SPY	ETF	145.81	145.81	145.81	145.81	1500.0
2007-11-09 06:42:00	SPY	ETF	145.8	145.8	145.65	145.65	17500.0
2007-11-09 06:43:00	SPY	ETF	145.6	145.6	145.6	145.6	4300.0
2007-11-09 06:44:00	SPY	ETF	145.79	145.79	145.74	145.77	10500.0
2007-11-09 06:45:00	SPY	ETF	145.74	145.74	145.73	145.73	12500.0
2007-11-09 06:49:00	SPY	ETF	145.75	145.75	145.75	145.75	50000.0
2007-11-09 06:50:00	SPY	ETF	145.75	145.76	145.72	145.72	50600.0
2007-11-09 06:51:00	SPY	ETF	145.7	145.7	145.65	145.65	146900.0
2007-11-09 06:52:00	SPY	ETF	145.66	145.78	145.65	145.78	5800.0
2007-11-09 06:54:00	SPY	ETF	145.8	145.8	145.8	145.8	1200.0
2007-11-09 06:56:00	SPY	ETF	145.75	145.75	145.7	145.7	13300.0
2007-11-09 06:57:00	SPY	ETF	145.7	145.7	145.7	145.7	2000.0
2007-11-09 06:58:00	SPY	ETF	145.7	145.74	145.68	145.74	104000.0
2007-11-09 07:00:00	SPY	ETF	145.83	145.89	145.7	145.82	116400.0
2007-11-09 07:01:00	SPY	ETF	145.82	145.83	145.8	145.83	32400.0
2007-11-09 07:02:00	SPY	ETF	145.92	145.94	145.92	145.94	3100.0
2007-11-09 07:03:00	SPY	ETF	145.94	146.02	145.94	146.02	8900.0
2007-11-09 07:04:00	SPY	ETF	146.12	146.12	146.12	146.12	1600.0
2007-11-09 07:05:00	SPY	ETF	146.13	146.16	146.1	146.1	10300.0
2007-11-09 07:06:00	SPY	ETF	146.05	146.05	146.0	146.0	1100.0
2007-11-09 07:07:00	SPY	ETF	145.96	145.97	145.96	145.96	7500.0

> showing 50 of 62,799 rows — these rows as CSV

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