PREVIEW / etf_1min / 2008-07-29

all etf 1-min files

  file:    by_date/etf_1min/2008/2008-07-29.parquet
  size:    1.1 MB
  rows:    69,326

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-29 04:15:00	SPY	ETF	123.84	123.84	123.84	123.84	100.0
2008-07-29 05:23:00	SPY	ETF	123.92	123.92	123.92	123.92	100.0
2008-07-29 06:02:00	SPY	ETF	123.28	123.28	123.28	123.28	1000.0
2008-07-29 06:25:00	SPY	ETF	123.56	123.56	123.56	123.56	1000.0
2008-07-29 06:36:00	SPY	ETF	123.49	123.49	123.49	123.49	100.0
2008-07-29 06:48:00	SPY	ETF	123.58	123.58	123.55	123.55	25000.0
2008-07-29 07:00:00	SPY	ETF	123.74	123.75	123.74	123.75	28570.0
2008-07-29 07:01:00	SPY	ETF	123.73	123.73	123.71	123.72	4300.0
2008-07-29 07:02:00	SPY	ETF	123.7	123.74	123.68	123.74	30000.0
2008-07-29 07:03:00	SPY	ETF	123.69	123.69	123.69	123.69	1000.0
2008-07-29 07:04:00	SPY	ETF	123.69	123.71	123.69	123.71	11000.0
2008-07-29 07:05:00	SPY	ETF	123.67	123.67	123.67	123.67	1000.0
2008-07-29 07:06:00	SPY	ETF	123.78	123.78	123.78	123.78	100.0
2008-07-29 07:07:00	SPY	ETF	123.79	123.79	123.79	123.79	100.0
2008-07-29 07:09:00	SPY	ETF	123.79	123.89	123.79	123.89	31700.0
2008-07-29 07:10:00	SPY	ETF	123.92	124.02	123.92	124.02	43500.0
2008-07-29 07:11:00	SPY	ETF	124.01	124.01	123.84	123.84	38000.0
2008-07-29 07:13:00	SPY	ETF	123.95	124.0	123.95	124.0	84200.0
2008-07-29 07:14:00	SPY	ETF	124.0	124.0	124.0	124.0	19000.0
2008-07-29 07:15:00	SPY	ETF	124.0	124.04	124.0	124.03	35839.0
2008-07-29 07:16:00	SPY	ETF	124.06	124.07	124.03	124.06	51500.0
2008-07-29 07:17:00	SPY	ETF	124.08	124.08	124.08	124.08	100.0
2008-07-29 07:18:00	SPY	ETF	124.08	124.08	124.03	124.03	11400.0
2008-07-29 07:19:00	SPY	ETF	124.05	124.05	124.02	124.02	30000.0
2008-07-29 07:20:00	SPY	ETF	124.07	124.07	124.07	124.07	300.0
2008-07-29 07:21:00	SPY	ETF	124.07	124.07	124.04	124.04	53700.0
2008-07-29 07:22:00	SPY	ETF	124.02	124.02	123.96	123.96	43839.0
2008-07-29 07:23:00	SPY	ETF	124.01	124.01	123.95	123.95	12500.0
2008-07-29 07:24:00	SPY	ETF	123.85	123.85	123.8	123.81	85400.0
2008-07-29 07:25:00	SPY	ETF	123.86	123.96	123.86	123.96	2400.0
2008-07-29 07:26:00	SPY	ETF	123.97	123.97	123.91	123.91	2100.0
2008-07-29 07:27:00	SPY	ETF	123.98	123.98	123.98	123.98	2000.0
2008-07-29 07:28:00	SPY	ETF	123.98	123.99	123.98	123.99	2500.0
2008-07-29 07:29:00	SPY	ETF	123.95	123.95	123.88	123.88	1600.0
2008-07-29 07:30:00	SPY	ETF	123.88	123.99	123.88	123.99	243274.0
2008-07-29 07:31:00	SPY	ETF	123.95	123.95	123.95	123.95	121000.0
2008-07-29 07:32:00	SPY	ETF	123.98	124.07	123.98	124.07	15100.0
2008-07-29 07:33:00	SPY	ETF	124.09	124.15	124.08	124.12	29200.0
2008-07-29 07:34:00	SPY	ETF	124.07	124.07	124.0	124.02	36049.0
2008-07-29 07:35:00	SPY	ETF	124.03	124.06	123.97	123.97	73676.0
2008-07-29 07:36:00	SPY	ETF	123.98	124.02	123.95	123.95	59372.0
2008-07-29 07:37:00	SPY	ETF	123.96	123.96	123.95	123.95	65224.0
2008-07-29 07:38:00	SPY	ETF	123.95	123.96	123.93	123.94	25560.0
2008-07-29 07:39:00	SPY	ETF	123.93	123.93	123.91	123.92	11500.0
2008-07-29 07:40:00	SPY	ETF	123.92	123.92	123.91	123.91	10900.0
2008-07-29 07:42:00	SPY	ETF	123.91	123.92	123.91	123.92	3000.0
2008-07-29 07:43:00	SPY	ETF	123.94	123.94	123.94	123.94	5000.0
2008-07-29 07:44:00	SPY	ETF	123.91	123.91	123.91	123.91	500.0
2008-07-29 07:46:00	SPY	ETF	123.92	123.92	123.91	123.91	10999.0
2008-07-29 07:47:00	SPY	ETF	123.91	123.91	123.91	123.91	27500.0

> showing 50 of 69,326 rows — these rows as CSV

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