PREVIEW / etf_1min / 2012-10-23

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-10-23.parquet
  size:    2.1 MB
  rows:    110,190

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-10-23 04:00:00	SPY	ETF	142.71	142.71	142.54	142.54	1145.0
2012-10-23 04:04:00	SPY	ETF	142.69	142.69	142.69	142.69	120.0
2012-10-23 04:06:00	SPY	ETF	142.63	142.63	142.63	142.63	200.0
2012-10-23 04:07:00	SPY	ETF	142.63	142.63	142.61	142.61	609.0
2012-10-23 04:08:00	SPY	ETF	142.57	142.57	142.57	142.57	30000.0
2012-10-23 04:09:00	SPY	ETF	142.54	142.56	142.54	142.56	300.0
2012-10-23 04:10:00	SPY	ETF	142.57	142.57	142.54	142.54	675.0
2012-10-23 04:11:00	SPY	ETF	142.54	142.54	142.54	142.54	200.0
2012-10-23 04:14:00	SPY	ETF	142.57	142.57	142.57	142.57	200.0
2012-10-23 04:19:00	SPY	ETF	142.66	142.66	142.66	142.66	100.0
2012-10-23 04:20:00	SPY	ETF	142.65	142.65	142.65	142.65	100.0
2012-10-23 04:33:00	SPY	ETF	142.66	142.66	142.66	142.66	100.0
2012-10-23 04:35:00	SPY	ETF	142.58	142.58	142.58	142.58	200.0
2012-10-23 04:52:00	SPY	ETF	142.63	142.63	142.63	142.63	300.0
2012-10-23 05:08:00	SPY	ETF	142.51	142.51	142.49	142.49	1100.0
2012-10-23 05:13:00	SPY	ETF	142.5	142.5	142.5	142.5	11500.0
2012-10-23 05:15:00	SPY	ETF	142.65	142.65	142.65	142.65	500.0
2012-10-23 05:19:00	SPY	ETF	142.68	142.68	142.68	142.68	13500.0
2012-10-23 05:22:00	SPY	ETF	142.71	142.75	142.71	142.75	5100.0
2012-10-23 05:30:00	SPY	ETF	142.64	142.64	142.64	142.64	1000.0
2012-10-23 05:32:00	SPY	ETF	142.64	142.64	142.63	142.63	5000.0
2012-10-23 05:41:00	SPY	ETF	142.6	142.6	142.6	142.6	2000.0
2012-10-23 05:42:00	SPY	ETF	142.6	142.6	142.6	142.6	1950.0
2012-10-23 05:44:00	SPY	ETF	142.58	142.58	142.55	142.55	3700.0
2012-10-23 05:47:00	SPY	ETF	142.55	142.55	142.55	142.55	1000.0
2012-10-23 05:49:00	SPY	ETF	142.49	142.49	142.49	142.49	300.0
2012-10-23 05:50:00	SPY	ETF	142.47	142.47	142.47	142.47	5000.0
2012-10-23 05:53:00	SPY	ETF	142.61	142.68	142.61	142.68	32008.0
2012-10-23 05:54:00	SPY	ETF	142.7	142.7	142.7	142.7	2000.0
2012-10-23 06:00:00	SPY	ETF	142.68	142.71	142.68	142.69	13659.0
2012-10-23 06:01:00	SPY	ETF	142.68	142.68	142.68	142.68	100.0
2012-10-23 06:02:00	SPY	ETF	142.65	142.65	142.65	142.65	1000.0
2012-10-23 06:03:00	SPY	ETF	142.63	142.65	142.63	142.64	9100.0
2012-10-23 06:04:00	SPY	ETF	142.67	142.67	142.62	142.62	7200.0
2012-10-23 06:05:00	SPY	ETF	142.59	142.59	142.59	142.59	200.0
2012-10-23 06:07:00	SPY	ETF	142.54	142.57	142.54	142.57	1000.0
2012-10-23 06:08:00	SPY	ETF	142.58	142.58	142.58	142.58	170.0
2012-10-23 06:10:00	SPY	ETF	142.59	142.59	142.59	142.59	450.0
2012-10-23 06:11:00	SPY	ETF	142.54	142.54	142.52	142.52	13500.0
2012-10-23 06:12:00	SPY	ETF	142.48	142.48	142.45	142.45	2700.0
2012-10-23 06:15:00	SPY	ETF	142.49	142.49	142.49	142.49	100.0
2012-10-23 06:17:00	SPY	ETF	142.45	142.45	142.45	142.45	100.0
2012-10-23 06:19:00	SPY	ETF	142.44	142.44	142.44	142.44	100.0
2012-10-23 06:20:00	SPY	ETF	142.45	142.49	142.45	142.49	1500.0
2012-10-23 06:25:00	SPY	ETF	142.49	142.49	142.49	142.49	200.0
2012-10-23 06:30:00	SPY	ETF	142.45	142.45	142.45	142.45	200.0
2012-10-23 06:31:00	SPY	ETF	142.42	142.42	142.42	142.42	5000.0
2012-10-23 06:32:00	SPY	ETF	142.39	142.39	142.39	142.39	998.0
2012-10-23 06:33:00	SPY	ETF	142.41	142.41	142.41	142.41	200.0
2012-10-23 06:34:00	SPY	ETF	142.4	142.41	142.37	142.4	31395.0

> showing 50 of 110,190 rows — these rows as CSV

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