PREVIEW / etf_1min / 2009-08-07

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-08-07.parquet
  size:    1.8 MB
  rows:    93,567

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-08-07 04:18:00	SPY	ETF	99.55	99.55	99.55	99.55	300.0
2009-08-07 04:24:00	SPY	ETF	99.57	99.57	99.57	99.57	1450.0
2009-08-07 04:26:00	SPY	ETF	99.55	99.55	99.55	99.55	100.0
2009-08-07 04:30:00	SPY	ETF	99.5	99.5	99.5	99.5	100.0
2009-08-07 04:36:00	SPY	ETF	99.5	99.5	99.5	99.5	100.0
2009-08-07 04:47:00	SPY	ETF	99.65	99.65	99.65	99.65	100.0
2009-08-07 04:48:00	SPY	ETF	99.67	99.67	99.67	99.67	100.0
2009-08-07 04:59:00	SPY	ETF	99.54	99.54	99.54	99.54	500.0
2009-08-07 05:08:00	SPY	ETF	99.62	99.62	99.62	99.62	2000.0
2009-08-07 05:09:00	SPY	ETF	99.7	99.7	99.7	99.7	200.0
2009-08-07 05:11:00	SPY	ETF	99.6	99.6	99.6	99.6	500.0
2009-08-07 05:13:00	SPY	ETF	99.75	99.75	99.75	99.75	3000.0
2009-08-07 05:57:00	SPY	ETF	99.6	99.6	99.6	99.6	100.0
2009-08-07 06:02:00	SPY	ETF	99.5	99.5	99.5	99.5	200.0
2009-08-07 06:04:00	SPY	ETF	99.48	99.48	99.48	99.48	200.0
2009-08-07 06:13:00	SPY	ETF	99.55	99.55	99.55	99.55	300.0
2009-08-07 06:19:00	SPY	ETF	99.5	99.5	99.5	99.5	100.0
2009-08-07 06:22:00	SPY	ETF	99.45	99.45	99.45	99.45	100.0
2009-08-07 06:26:00	SPY	ETF	99.5	99.5	99.5	99.5	2000.0
2009-08-07 06:29:00	SPY	ETF	99.5	99.5	99.5	99.5	8000.0
2009-08-07 06:31:00	SPY	ETF	99.51	99.51	99.51	99.51	500.0
2009-08-07 06:40:00	SPY	ETF	99.53	99.53	99.53	99.53	500.0
2009-08-07 06:42:00	SPY	ETF	99.58	99.58	99.58	99.58	500.0
2009-08-07 06:43:00	SPY	ETF	99.6	99.6	99.6	99.6	200.0
2009-08-07 06:45:00	SPY	ETF	99.55	99.55	99.55	99.55	100.0
2009-08-07 06:50:00	SPY	ETF	99.5	99.5	99.5	99.5	100.0
2009-08-07 06:54:00	SPY	ETF	99.53	99.55	99.53	99.55	2500.0
2009-08-07 06:57:00	SPY	ETF	99.55	99.55	99.55	99.55	5000.0
2009-08-07 07:01:00	SPY	ETF	99.57	99.57	99.57	99.57	8000.0
2009-08-07 07:02:00	SPY	ETF	99.58	99.58	99.57	99.57	925.0
2009-08-07 07:03:00	SPY	ETF	99.56	99.58	99.56	99.58	675.0
2009-08-07 07:04:00	SPY	ETF	99.63	99.63	99.63	99.63	15500.0
2009-08-07 07:05:00	SPY	ETF	99.6	99.61	99.6	99.6	47000.0
2009-08-07 07:06:00	SPY	ETF	99.66	99.75	99.66	99.7	39300.0
2009-08-07 07:07:00	SPY	ETF	99.63	99.63	99.63	99.63	5000.0
2009-08-07 07:08:00	SPY	ETF	99.64	99.64	99.64	99.64	4550.0
2009-08-07 07:10:00	SPY	ETF	99.65	99.67	99.65	99.65	1200.0
2009-08-07 07:12:00	SPY	ETF	99.64	99.67	99.64	99.67	2100.0
2009-08-07 07:13:00	SPY	ETF	99.63	99.67	99.63	99.67	5100.0
2009-08-07 07:14:00	SPY	ETF	99.63	99.64	99.63	99.64	20500.0
2009-08-07 07:15:00	SPY	ETF	99.64	99.64	99.58	99.58	17100.0
2009-08-07 07:16:00	SPY	ETF	99.61	99.62	99.6	99.62	10758.0
2009-08-07 07:17:00	SPY	ETF	99.62	99.62	99.62	99.62	100.0
2009-08-07 07:18:00	SPY	ETF	99.58	99.58	99.58	99.58	2000.0
2009-08-07 07:21:00	SPY	ETF	99.6	99.6	99.6	99.6	441.0
2009-08-07 07:22:00	SPY	ETF	99.6	99.6	99.6	99.6	500.0
2009-08-07 07:23:00	SPY	ETF	99.6	99.64	99.6	99.64	13500.0
2009-08-07 07:24:00	SPY	ETF	99.65	99.68	99.65	99.68	47000.0
2009-08-07 07:25:00	SPY	ETF	99.64	99.64	99.64	99.64	100.0
2009-08-07 07:26:00	SPY	ETF	99.65	99.69	99.63	99.65	80000.0

> showing 50 of 93,567 rows — these rows as CSV

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