PREVIEW / etf_1min / 2012-03-19

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-03-19.parquet
  size:    2.0 MB
  rows:    104,930

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-19 04:00:00	SPY	ETF	140.5	140.5	140.06	140.06	1880.0
2012-03-19 04:13:00	SPY	ETF	140.12	140.12	140.12	140.12	200.0
2012-03-19 04:14:00	SPY	ETF	140.1	140.15	140.1	140.15	1600.0
2012-03-19 04:22:00	SPY	ETF	140.05	140.05	140.05	140.05	980.0
2012-03-19 04:23:00	SPY	ETF	140.02	140.02	140.02	140.02	100.0
2012-03-19 04:24:00	SPY	ETF	140.04	140.05	140.04	140.05	5000.0
2012-03-19 04:25:00	SPY	ETF	140.04	140.04	140.04	140.04	10000.0
2012-03-19 04:26:00	SPY	ETF	140.04	140.04	140.04	140.04	5000.0
2012-03-19 04:27:00	SPY	ETF	140.02	140.02	140.02	140.02	5300.0
2012-03-19 04:29:00	SPY	ETF	140.01	140.01	140.0	140.0	2300.0
2012-03-19 04:30:00	SPY	ETF	139.94	139.94	139.94	139.94	15000.0
2012-03-19 04:31:00	SPY	ETF	139.92	139.92	139.92	139.92	300.0
2012-03-19 04:32:00	SPY	ETF	139.9	139.9	139.9	139.9	5000.0
2012-03-19 04:33:00	SPY	ETF	139.92	139.92	139.92	139.92	5000.0
2012-03-19 04:36:00	SPY	ETF	139.9	139.9	139.9	139.9	5000.0
2012-03-19 04:37:00	SPY	ETF	139.89	139.89	139.85	139.85	15000.0
2012-03-19 04:38:00	SPY	ETF	139.89	139.9	139.89	139.9	5000.0
2012-03-19 04:55:00	SPY	ETF	139.97	139.97	139.97	139.97	2480.0
2012-03-19 04:58:00	SPY	ETF	139.92	139.92	139.92	139.92	1000.0
2012-03-19 05:30:00	SPY	ETF	140.04	140.04	140.04	140.04	1000.0
2012-03-19 05:32:00	SPY	ETF	140.03	140.03	140.03	140.03	1000.0
2012-03-19 05:38:00	SPY	ETF	140.08	140.08	140.08	140.08	3980.0
2012-03-19 05:40:00	SPY	ETF	140.09	140.09	140.09	140.09	2000.0
2012-03-19 05:42:00	SPY	ETF	140.09	140.09	140.09	140.09	8000.0
2012-03-19 06:06:00	SPY	ETF	140.01	140.01	140.01	140.01	100.0
2012-03-19 06:10:00	SPY	ETF	140.09	140.1	140.09	140.1	10100.0
2012-03-19 06:11:00	SPY	ETF	140.09	140.09	140.06	140.06	200.0
2012-03-19 06:12:00	SPY	ETF	140.05	140.05	140.05	140.05	4000.0
2012-03-19 06:13:00	SPY	ETF	140.04	140.04	140.04	140.04	100.0
2012-03-19 06:20:00	SPY	ETF	140.0	140.0	140.0	140.0	1000.0
2012-03-19 06:21:00	SPY	ETF	139.97	139.97	139.97	139.97	500.0
2012-03-19 06:25:00	SPY	ETF	140.03	140.03	140.03	140.03	500.0
2012-03-19 06:32:00	SPY	ETF	139.96	139.96	139.96	139.96	600.0
2012-03-19 06:58:00	SPY	ETF	140.12	140.12	140.07	140.07	380.0
2012-03-19 07:00:00	SPY	ETF	140.09	140.12	140.09	140.12	5200.0
2012-03-19 07:01:00	SPY	ETF	140.09	140.09	140.09	140.09	3900.0
2012-03-19 07:02:00	SPY	ETF	140.06	140.09	140.06	140.09	1500.0
2012-03-19 07:03:00	SPY	ETF	140.06	140.08	140.02	140.07	10758.0
2012-03-19 07:04:00	SPY	ETF	140.07	140.07	140.07	140.07	200.0
2012-03-19 07:05:00	SPY	ETF	140.07	140.07	140.07	140.07	550.0
2012-03-19 07:06:00	SPY	ETF	140.05	140.05	140.03	140.03	200.0
2012-03-19 07:07:00	SPY	ETF	140.07	140.07	140.07	140.07	100.0
2012-03-19 07:08:00	SPY	ETF	140.03	140.07	140.02	140.07	9100.0
2012-03-19 07:09:00	SPY	ETF	140.03	140.03	140.03	140.03	100.0
2012-03-19 07:10:00	SPY	ETF	140.03	140.03	140.03	140.03	1000.0
2012-03-19 07:11:00	SPY	ETF	140.02	140.02	140.02	140.02	1000.0
2012-03-19 07:15:00	SPY	ETF	140.11	140.11	140.1	140.1	10139.0
2012-03-19 07:16:00	SPY	ETF	140.1	140.1	140.1	140.1	200.0
2012-03-19 07:17:00	SPY	ETF	140.11	140.11	140.11	140.11	200.0
2012-03-19 07:18:00	SPY	ETF	140.12	140.12	140.1	140.1	600.0

> showing 50 of 104,930 rows — these rows as CSV

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