PREVIEW / etf_1min / 2012-03-23

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-03-23.parquet
  size:    1.9 MB
  rows:    99,387

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-03-23 04:00:00	SPY	ETF	139.48	139.48	139.48	139.48	440.0
2012-03-23 04:04:00	SPY	ETF	139.66	139.66	139.66	139.66	100.0
2012-03-23 04:10:00	SPY	ETF	139.66	139.66	139.66	139.66	2500.0
2012-03-23 04:12:00	SPY	ETF	139.67	139.68	139.67	139.68	300.0
2012-03-23 04:13:00	SPY	ETF	139.7	139.7	139.7	139.7	125.0
2012-03-23 04:15:00	SPY	ETF	139.73	139.73	139.73	139.73	200.0
2012-03-23 04:18:00	SPY	ETF	139.74	139.74	139.74	139.74	100.0
2012-03-23 04:19:00	SPY	ETF	139.77	139.77	139.77	139.77	500.0
2012-03-23 04:25:00	SPY	ETF	139.81	139.81	139.81	139.81	7500.0
2012-03-23 04:30:00	SPY	ETF	139.79	139.8	139.79	139.8	8200.0
2012-03-23 04:31:00	SPY	ETF	139.82	139.82	139.82	139.82	500.0
2012-03-23 04:32:00	SPY	ETF	139.89	139.91	139.89	139.91	1000.0
2012-03-23 04:33:00	SPY	ETF	139.89	139.91	139.88	139.91	2370.0
2012-03-23 04:34:00	SPY	ETF	139.92	139.92	139.92	139.92	7500.0
2012-03-23 04:35:00	SPY	ETF	139.91	139.97	139.91	139.97	1100.0
2012-03-23 04:36:00	SPY	ETF	139.96	139.96	139.94	139.94	900.0
2012-03-23 04:37:00	SPY	ETF	139.94	139.94	139.94	139.94	5000.0
2012-03-23 04:38:00	SPY	ETF	139.91	139.91	139.91	139.91	500.0
2012-03-23 04:40:00	SPY	ETF	139.93	139.94	139.93	139.94	7331.0
2012-03-23 04:44:00	SPY	ETF	139.94	139.94	139.94	139.94	400.0
2012-03-23 04:52:00	SPY	ETF	139.8	139.8	139.8	139.8	500.0
2012-03-23 05:00:00	SPY	ETF	139.94	139.95	139.94	139.95	6500.0
2012-03-23 05:21:00	SPY	ETF	139.72	139.72	139.72	139.72	200.0
2012-03-23 05:22:00	SPY	ETF	139.65	139.65	139.65	139.65	1000.0
2012-03-23 05:24:00	SPY	ETF	139.62	139.62	139.62	139.62	7500.0
2012-03-23 05:33:00	SPY	ETF	139.6	139.6	139.6	139.6	200.0
2012-03-23 05:42:00	SPY	ETF	139.57	139.57	139.57	139.57	2500.0
2012-03-23 05:44:00	SPY	ETF	139.55	139.55	139.55	139.55	2500.0
2012-03-23 05:45:00	SPY	ETF	139.55	139.55	139.55	139.55	2500.0
2012-03-23 05:48:00	SPY	ETF	139.54	139.54	139.5	139.5	3400.0
2012-03-23 05:49:00	SPY	ETF	139.46	139.46	139.46	139.46	200.0
2012-03-23 05:50:00	SPY	ETF	139.4	139.4	139.4	139.4	1000.0
2012-03-23 05:53:00	SPY	ETF	139.41	139.41	139.41	139.41	12500.0
2012-03-23 06:14:00	SPY	ETF	139.46	139.46	139.46	139.46	1000.0
2012-03-23 06:15:00	SPY	ETF	139.45	139.45	139.41	139.41	360.0
2012-03-23 06:20:00	SPY	ETF	139.36	139.36	139.36	139.36	1940.0
2012-03-23 06:32:00	SPY	ETF	139.45	139.45	139.45	139.45	20000.0
2012-03-23 06:34:00	SPY	ETF	139.4	139.4	139.4	139.4	5000.0
2012-03-23 06:36:00	SPY	ETF	139.35	139.35	139.35	139.35	3000.0
2012-03-23 06:38:00	SPY	ETF	139.35	139.35	139.35	139.35	200.0
2012-03-23 06:47:00	SPY	ETF	139.35	139.38	139.35	139.38	600.0
2012-03-23 06:53:00	SPY	ETF	139.35	139.35	139.35	139.35	600.0
2012-03-23 06:54:00	SPY	ETF	139.31	139.31	139.31	139.31	200.0
2012-03-23 06:58:00	SPY	ETF	139.4	139.4	139.4	139.4	2950.0
2012-03-23 07:01:00	SPY	ETF	139.41	139.41	139.41	139.41	2990.0
2012-03-23 07:02:00	SPY	ETF	139.39	139.39	139.39	139.39	100.0
2012-03-23 07:03:00	SPY	ETF	139.45	139.51	139.42	139.51	502590.0
2012-03-23 07:04:00	SPY	ETF	139.48	139.52	139.48	139.52	184950.0
2012-03-23 07:05:00	SPY	ETF	139.52	139.57	139.44	139.44	220140.0
2012-03-23 07:06:00	SPY	ETF	139.41	139.41	139.41	139.41	145.0

> showing 50 of 99,387 rows — these rows as CSV

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