PREVIEW / etf_1min / 2012-01-23

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-01-23.parquet
  size:    2.1 MB
  rows:    106,697

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
2012-01-23 04:00:00	SPY	ETF	131.16	131.2	131.16	131.2	549.0
2012-01-23 04:01:00	SPY	ETF	131.16	131.16	131.16	131.16	300.0
2012-01-23 04:03:00	SPY	ETF	131.15	131.15	131.11	131.11	200.0
2012-01-23 04:05:00	SPY	ETF	131.15	131.15	131.15	131.15	3000.0
2012-01-23 04:07:00	SPY	ETF	131.31	131.32	131.31	131.32	2400.0
2012-01-23 04:14:00	SPY	ETF	131.09	131.09	131.09	131.09	100.0
2012-01-23 04:32:00	SPY	ETF	131.29	131.29	131.29	131.29	530.0
2012-01-23 04:48:00	SPY	ETF	131.1	131.1	131.08	131.08	600.0
2012-01-23 05:02:00	SPY	ETF	131.21	131.21	131.21	131.21	200.0
2012-01-23 05:43:00	SPY	ETF	131.37	131.37	131.37	131.37	100.0
2012-01-23 05:48:00	SPY	ETF	131.45	131.45	131.45	131.45	500.0
2012-01-23 05:49:00	SPY	ETF	131.48	131.48	131.48	131.48	100.0
2012-01-23 05:57:00	SPY	ETF	131.42	131.42	131.4	131.4	20000.0
2012-01-23 06:09:00	SPY	ETF	131.65	131.65	131.65	131.65	10000.0
2012-01-23 06:10:00	SPY	ETF	131.73	131.73	131.73	131.73	200.0
2012-01-23 06:15:00	SPY	ETF	131.74	131.78	131.74	131.78	1300.0
2012-01-23 06:17:00	SPY	ETF	131.75	131.75	131.73	131.73	1200.0
2012-01-23 06:22:00	SPY	ETF	131.75	131.75	131.75	131.75	10000.0
2012-01-23 06:23:00	SPY	ETF	131.78	131.78	131.78	131.78	4000.0
2012-01-23 06:24:00	SPY	ETF	131.73	131.73	131.73	131.73	2500.0
2012-01-23 06:25:00	SPY	ETF	131.76	131.76	131.76	131.76	2500.0
2012-01-23 06:31:00	SPY	ETF	131.7	131.7	131.7	131.7	500.0
2012-01-23 06:39:00	SPY	ETF	131.8	131.8	131.8	131.8	185.0
2012-01-23 06:41:00	SPY	ETF	131.8	131.8	131.8	131.8	2500.0
2012-01-23 06:48:00	SPY	ETF	131.8	131.8	131.8	131.8	2500.0
2012-01-23 06:57:00	SPY	ETF	131.67	131.67	131.66	131.66	25000.0
2012-01-23 06:58:00	SPY	ETF	131.65	131.65	131.61	131.65	20900.0
2012-01-23 06:59:00	SPY	ETF	131.59	131.62	131.59	131.61	23990.0
2012-01-23 07:00:00	SPY	ETF	131.63	131.63	131.61	131.61	7084.0
2012-01-23 07:01:00	SPY	ETF	131.61	131.61	131.61	131.61	2782.0
2012-01-23 07:02:00	SPY	ETF	131.6	131.6	131.6	131.6	4995.0
2012-01-23 07:03:00	SPY	ETF	131.65	131.65	131.58	131.58	14200.0
2012-01-23 07:04:00	SPY	ETF	131.59	131.59	131.59	131.59	100.0
2012-01-23 07:07:00	SPY	ETF	131.65	131.65	131.65	131.65	2500.0
2012-01-23 07:10:00	SPY	ETF	131.65	131.65	131.65	131.65	10000.0
2012-01-23 07:11:00	SPY	ETF	131.61	131.61	131.6	131.6	4500.0
2012-01-23 07:12:00	SPY	ETF	131.6	131.6	131.6	131.6	100.0
2012-01-23 07:13:00	SPY	ETF	131.59	131.6	131.59	131.6	1400.0
2012-01-23 07:14:00	SPY	ETF	131.6	131.6	131.57	131.57	11100.0
2012-01-23 07:15:00	SPY	ETF	131.64	131.64	131.64	131.64	100.0
2012-01-23 07:16:00	SPY	ETF	131.63	131.66	131.63	131.63	11000.0
2012-01-23 07:17:00	SPY	ETF	131.63	131.63	131.63	131.63	100.0
2012-01-23 07:18:00	SPY	ETF	131.67	131.67	131.67	131.67	4685.0
2012-01-23 07:19:00	SPY	ETF	131.63	131.63	131.63	131.63	500.0
2012-01-23 07:20:00	SPY	ETF	131.62	131.62	131.62	131.62	1000.0
2012-01-23 07:22:00	SPY	ETF	131.61	131.62	131.59	131.59	11900.0
2012-01-23 07:24:00	SPY	ETF	131.6	131.6	131.59	131.6	5100.0
2012-01-23 07:25:00	SPY	ETF	131.59	131.59	131.58	131.58	27000.0
2012-01-23 07:26:00	SPY	ETF	131.59	131.6	131.59	131.6	2000.0
2012-01-23 07:27:00	SPY	ETF	131.63	131.64	131.63	131.64	8200.0

> showing 50 of 106,697 rows — these rows as CSV

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