PREVIEW / etf_1min / 2012-05-03

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-05-03.parquet
  size:    1.9 MB
  rows:    100,213

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-05-03 04:00:00	SPY	ETF	140.73	140.73	140.47	140.47	350.0
2012-05-03 04:07:00	SPY	ETF	140.45	140.45	140.45	140.45	150.0
2012-05-03 04:42:00	SPY	ETF	140.36	140.36	140.36	140.36	1000.0
2012-05-03 04:46:00	SPY	ETF	140.24	140.24	140.24	140.24	1000.0
2012-05-03 04:51:00	SPY	ETF	140.22	140.22	140.22	140.22	1000.0
2012-05-03 04:52:00	SPY	ETF	140.21	140.21	140.21	140.21	4000.0
2012-05-03 04:53:00	SPY	ETF	140.15	140.15	140.15	140.15	1000.0
2012-05-03 05:09:00	SPY	ETF	140.3	140.3	140.3	140.3	200.0
2012-05-03 05:11:00	SPY	ETF	140.32	140.32	140.32	140.32	300.0
2012-05-03 05:43:00	SPY	ETF	140.31	140.32	140.31	140.32	40000.0
2012-05-03 06:04:00	SPY	ETF	140.51	140.51	140.44	140.44	10022.0
2012-05-03 06:11:00	SPY	ETF	140.48	140.49	140.48	140.49	2400.0
2012-05-03 06:12:00	SPY	ETF	140.46	140.46	140.46	140.46	250.0
2012-05-03 06:14:00	SPY	ETF	140.46	140.46	140.46	140.46	250.0
2012-05-03 06:15:00	SPY	ETF	140.46	140.48	140.46	140.48	600.0
2012-05-03 06:30:00	SPY	ETF	140.53	140.53	140.53	140.53	500.0
2012-05-03 06:32:00	SPY	ETF	140.57	140.57	140.57	140.57	1000.0
2012-05-03 06:45:00	SPY	ETF	140.56	140.56	140.56	140.56	7000.0
2012-05-03 06:46:00	SPY	ETF	140.54	140.54	140.54	140.54	100.0
2012-05-03 06:47:00	SPY	ETF	140.49	140.49	140.49	140.49	400.0
2012-05-03 06:49:00	SPY	ETF	140.57	140.57	140.57	140.57	100.0
2012-05-03 06:51:00	SPY	ETF	140.52	140.52	140.52	140.52	10000.0
2012-05-03 06:52:00	SPY	ETF	140.54	140.54	140.54	140.54	2500.0
2012-05-03 07:00:00	SPY	ETF	140.56	140.56	140.56	140.56	300.0
2012-05-03 07:01:00	SPY	ETF	140.56	140.58	140.56	140.56	5600.0
2012-05-03 07:02:00	SPY	ETF	140.58	140.62	140.56	140.62	51150.0
2012-05-03 07:03:00	SPY	ETF	140.6	140.6	140.6	140.6	25600.0
2012-05-03 07:04:00	SPY	ETF	140.63	140.65	140.63	140.63	5500.0
2012-05-03 07:05:00	SPY	ETF	140.6	140.6	140.6	140.6	600.0
2012-05-03 07:06:00	SPY	ETF	140.61	140.61	140.6	140.6	4900.0
2012-05-03 07:07:00	SPY	ETF	140.64	140.64	140.64	140.64	5000.0
2012-05-03 07:09:00	SPY	ETF	140.63	140.63	140.63	140.63	200.0
2012-05-03 07:10:00	SPY	ETF	140.62	140.65	140.62	140.64	3960.0
2012-05-03 07:11:00	SPY	ETF	140.61	140.61	140.61	140.61	100.0
2012-05-03 07:12:00	SPY	ETF	140.64	140.64	140.64	140.64	11500.0
2012-05-03 07:14:00	SPY	ETF	140.64	140.64	140.63	140.63	11000.0
2012-05-03 07:15:00	SPY	ETF	140.61	140.61	140.61	140.61	1030.0
2012-05-03 07:16:00	SPY	ETF	140.62	140.62	140.62	140.62	200.0
2012-05-03 07:17:00	SPY	ETF	140.63	140.63	140.63	140.63	625.0
2012-05-03 07:18:00	SPY	ETF	140.62	140.62	140.57	140.57	11800.0
2012-05-03 07:21:00	SPY	ETF	140.57	140.57	140.57	140.57	4700.0
2012-05-03 07:22:00	SPY	ETF	140.58	140.58	140.58	140.58	2000.0
2012-05-03 07:25:00	SPY	ETF	140.6	140.6	140.6	140.6	2000.0
2012-05-03 07:27:00	SPY	ETF	140.62	140.62	140.62	140.62	100.0
2012-05-03 07:28:00	SPY	ETF	140.63	140.63	140.63	140.63	1200.0
2012-05-03 07:33:00	SPY	ETF	140.58	140.58	140.58	140.58	400.0
2012-05-03 07:35:00	SPY	ETF	140.58	140.6	140.58	140.6	1000.0
2012-05-03 07:36:00	SPY	ETF	140.6	140.6	140.6	140.6	100.0
2012-05-03 07:37:00	SPY	ETF	140.61	140.62	140.61	140.62	1600.0
2012-05-03 07:38:00	SPY	ETF	140.62	140.62	140.62	140.62	500.0

> showing 50 of 100,213 rows — these rows as CSV

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