PREVIEW / etf_1min / 2007-04-20

all etf 1-min files

  file:    by_date/etf_1min/2007/2007-04-20.parquet
  size:    600 KB
  rows:    36,276

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-04-20 05:52:00	SPY	ETF	147.66	147.66	147.66	147.66	8000.0
2007-04-20 05:54:00	SPY	ETF	147.66	147.66	147.66	147.66	11000.0
2007-04-20 06:11:00	SPY	ETF	147.69	147.69	147.69	147.69	25000.0
2007-04-20 06:24:00	SPY	ETF	147.75	147.75	147.75	147.75	100.0
2007-04-20 06:59:00	SPY	ETF	147.77	147.77	147.77	147.77	10000.0
2007-04-20 07:00:00	SPY	ETF	147.72	147.73	147.7	147.73	11000.0
2007-04-20 07:01:00	SPY	ETF	147.78	147.78	147.78	147.78	100.0
2007-04-20 07:02:00	SPY	ETF	147.77	147.81	147.77	147.81	2600.0
2007-04-20 07:03:00	SPY	ETF	147.82	147.82	147.81	147.82	35000.0
2007-04-20 07:04:00	SPY	ETF	147.83	147.83	147.83	147.83	100.0
2007-04-20 07:05:00	SPY	ETF	147.82	147.83	147.82	147.83	1000.0
2007-04-20 07:06:00	SPY	ETF	147.81	147.87	147.81	147.87	1700.0
2007-04-20 07:07:00	SPY	ETF	147.88	147.89	147.85	147.85	3500.0
2007-04-20 07:08:00	SPY	ETF	147.86	147.86	147.86	147.86	1700.0
2007-04-20 07:09:00	SPY	ETF	147.89	147.89	147.89	147.89	3200.0
2007-04-20 07:10:00	SPY	ETF	147.88	147.9	147.88	147.9	2100.0
2007-04-20 07:11:00	SPY	ETF	147.94	147.95	147.94	147.95	40600.0
2007-04-20 07:13:00	SPY	ETF	147.88	147.88	147.83	147.83	26500.0
2007-04-20 07:14:00	SPY	ETF	147.83	147.85	147.83	147.85	47500.0
2007-04-20 07:17:00	SPY	ETF	147.85	147.85	147.85	147.85	400.0
2007-04-20 07:18:00	SPY	ETF	147.85	147.85	147.85	147.85	1100.0
2007-04-20 07:19:00	SPY	ETF	147.85	147.85	147.85	147.85	1100.0
2007-04-20 07:20:00	SPY	ETF	147.8	147.8	147.74	147.74	168800.0
2007-04-20 07:21:00	SPY	ETF	147.73	147.76	147.73	147.76	65700.0
2007-04-20 07:23:00	SPY	ETF	147.78	147.78	147.78	147.78	2000.0
2007-04-20 07:24:00	SPY	ETF	147.78	147.8	147.78	147.8	6600.0
2007-04-20 07:25:00	SPY	ETF	147.8	147.8	147.8	147.8	5000.0
2007-04-20 07:26:00	SPY	ETF	147.8	147.8	147.8	147.8	10000.0
2007-04-20 07:27:00	SPY	ETF	147.8	147.8	147.8	147.8	5000.0
2007-04-20 07:28:00	SPY	ETF	147.8	147.8	147.78	147.78	105000.0
2007-04-20 07:29:00	SPY	ETF	147.8	147.8	147.8	147.8	6000.0
2007-04-20 07:30:00	SPY	ETF	147.8	147.8	147.8	147.8	5500.0
2007-04-20 07:31:00	SPY	ETF	147.84	147.85	147.84	147.85	5200.0
2007-04-20 07:32:00	SPY	ETF	147.85	147.89	147.84	147.89	69000.0
2007-04-20 07:33:00	SPY	ETF	147.9	147.91	147.89	147.91	35900.0
2007-04-20 07:34:00	SPY	ETF	147.9	147.91	147.9	147.91	24100.0
2007-04-20 07:35:00	SPY	ETF	147.92	147.92	147.92	147.92	5000.0
2007-04-20 07:36:00	SPY	ETF	147.9	147.9	147.9	147.9	1000.0
2007-04-20 07:37:00	SPY	ETF	147.9	147.9	147.9	147.9	200.0
2007-04-20 07:40:00	SPY	ETF	147.9	147.9	147.9	147.9	3800.0
2007-04-20 07:43:00	SPY	ETF	147.92	147.98	147.92	147.98	510000.0
2007-04-20 07:44:00	SPY	ETF	147.95	147.96	147.95	147.96	3400.0
2007-04-20 07:45:00	SPY	ETF	147.96	147.96	147.96	147.96	100.0
2007-04-20 07:46:00	SPY	ETF	147.94	147.96	147.94	147.96	23100.0
2007-04-20 07:47:00	SPY	ETF	147.96	147.98	147.96	147.98	21300.0
2007-04-20 07:48:00	SPY	ETF	147.97	147.98	147.97	147.97	32400.0
2007-04-20 07:49:00	SPY	ETF	147.98	147.99	147.98	147.99	2000.0
2007-04-20 07:50:00	SPY	ETF	147.99	147.99	147.94	147.94	5000.0
2007-04-20 07:51:00	SPY	ETF	147.95	147.96	147.95	147.96	10100.0
2007-04-20 07:52:00	SPY	ETF	147.95	147.95	147.95	147.95	800.0

> showing 50 of 36,276 rows — these rows as CSV

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