PREVIEW / etf_1min / 2012-03-20

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-03-20.parquet
  size:    2.0 MB
  rows:    106,559

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-20 04:05:00	SPY	ETF	140.57	140.57	140.57	140.57	190.0
2012-03-20 04:10:00	SPY	ETF	140.56	140.56	140.56	140.56	1000.0
2012-03-20 04:12:00	SPY	ETF	140.56	140.56	140.56	140.56	200.0
2012-03-20 04:13:00	SPY	ETF	140.52	140.52	140.51	140.51	500.0
2012-03-20 04:15:00	SPY	ETF	140.57	140.57	140.57	140.57	2000.0
2012-03-20 04:16:00	SPY	ETF	140.58	140.58	140.58	140.58	500.0
2012-03-20 04:18:00	SPY	ETF	140.57	140.57	140.44	140.44	3392.0
2012-03-20 04:20:00	SPY	ETF	140.56	140.56	140.56	140.56	1400.0
2012-03-20 04:21:00	SPY	ETF	140.56	140.56	140.56	140.56	1000.0
2012-03-20 04:25:00	SPY	ETF	140.56	140.56	140.56	140.56	1000.0
2012-03-20 04:26:00	SPY	ETF	140.53	140.53	140.53	140.53	2000.0
2012-03-20 04:27:00	SPY	ETF	140.53	140.53	140.52	140.52	1100.0
2012-03-20 04:28:00	SPY	ETF	140.48	140.48	140.48	140.48	1000.0
2012-03-20 04:30:00	SPY	ETF	140.51	140.51	140.51	140.51	2000.0
2012-03-20 04:34:00	SPY	ETF	140.43	140.43	140.43	140.43	100.0
2012-03-20 05:00:00	SPY	ETF	140.63	140.63	140.63	140.63	300.0
2012-03-20 05:06:00	SPY	ETF	140.61	140.61	140.61	140.61	5000.0
2012-03-20 05:08:00	SPY	ETF	140.61	140.61	140.61	140.61	2500.0
2012-03-20 05:09:00	SPY	ETF	140.62	140.63	140.62	140.63	2000.0
2012-03-20 05:10:00	SPY	ETF	140.63	140.63	140.63	140.63	2000.0
2012-03-20 05:11:00	SPY	ETF	140.54	140.54	140.54	140.54	2800.0
2012-03-20 05:13:00	SPY	ETF	140.54	140.54	140.54	140.54	200.0
2012-03-20 05:24:00	SPY	ETF	140.43	140.43	140.42	140.42	1700.0
2012-03-20 05:26:00	SPY	ETF	140.4	140.4	140.32	140.32	2000.0
2012-03-20 05:27:00	SPY	ETF	140.26	140.26	140.25	140.25	350.0
2012-03-20 05:28:00	SPY	ETF	140.28	140.28	140.28	140.28	7500.0
2012-03-20 05:34:00	SPY	ETF	140.15	140.15	140.15	140.15	200.0
2012-03-20 05:37:00	SPY	ETF	140.18	140.18	140.1	140.1	1000.0
2012-03-20 05:40:00	SPY	ETF	140.05	140.05	140.01	140.01	1500.0
2012-03-20 05:43:00	SPY	ETF	140.1	140.11	140.1	140.11	520.0
2012-03-20 05:44:00	SPY	ETF	140.08	140.08	140.08	140.08	477.0
2012-03-20 05:46:00	SPY	ETF	140.07	140.07	140.07	140.07	100.0
2012-03-20 05:50:00	SPY	ETF	140.08	140.08	140.08	140.08	100.0
2012-03-20 05:55:00	SPY	ETF	140.13	140.13	140.13	140.13	2000.0
2012-03-20 06:10:00	SPY	ETF	140.12	140.13	140.12	140.13	5100.0
2012-03-20 06:13:00	SPY	ETF	140.12	140.13	140.12	140.13	5000.0
2012-03-20 06:14:00	SPY	ETF	140.1	140.1	140.1	140.1	200.0
2012-03-20 06:15:00	SPY	ETF	140.12	140.14	140.12	140.14	2400.0
2012-03-20 06:16:00	SPY	ETF	140.11	140.11	140.11	140.11	3400.0
2012-03-20 06:17:00	SPY	ETF	140.1	140.1	140.1	140.1	2300.0
2012-03-20 06:19:00	SPY	ETF	140.07	140.07	140.07	140.07	200.0
2012-03-20 06:23:00	SPY	ETF	140.04	140.04	140.04	140.04	500.0
2012-03-20 06:25:00	SPY	ETF	140.08	140.08	140.08	140.08	400.0
2012-03-20 06:30:00	SPY	ETF	140.06	140.06	140.01	140.01	14350.0
2012-03-20 06:31:00	SPY	ETF	140.0	140.01	139.99	140.01	5500.0
2012-03-20 06:33:00	SPY	ETF	140.01	140.01	140.01	140.01	500.0
2012-03-20 06:34:00	SPY	ETF	140.01	140.01	140.01	140.01	125.0
2012-03-20 06:35:00	SPY	ETF	140.08	140.08	140.08	140.08	5000.0
2012-03-20 06:36:00	SPY	ETF	140.01	140.01	140.01	140.01	5000.0
2012-03-20 06:39:00	SPY	ETF	140.1	140.1	140.1	140.1	600.0

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

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