PREVIEW / etf_1min / 2012-04-27

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-04-27.parquet
  size:    1.8 MB
  rows:    95,391

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-04-27 04:00:00	SPY	ETF	139.65	139.88	139.65	139.88	609.0
2012-04-27 04:22:00	SPY	ETF	139.9	139.9	139.87	139.87	2400.0
2012-04-27 04:29:00	SPY	ETF	139.9	139.9	139.9	139.9	190.0
2012-04-27 04:30:00	SPY	ETF	139.88	139.88	139.88	139.88	500.0
2012-04-27 04:41:00	SPY	ETF	139.87	139.87	139.85	139.87	300.0
2012-04-27 04:42:00	SPY	ETF	139.85	139.92	139.85	139.92	200.0
2012-04-27 04:52:00	SPY	ETF	139.85	139.85	139.85	139.85	100.0
2012-04-27 05:03:00	SPY	ETF	139.98	140.1	139.98	140.1	600.0
2012-04-27 05:04:00	SPY	ETF	140.08	140.08	140.0	140.0	200.0
2012-04-27 05:06:00	SPY	ETF	140.04	140.04	140.04	140.04	200.0
2012-04-27 05:13:00	SPY	ETF	140.18	140.18	140.18	140.18	100.0
2012-04-27 05:24:00	SPY	ETF	140.05	140.05	140.05	140.05	100.0
2012-04-27 05:27:00	SPY	ETF	140.12	140.12	140.12	140.12	2500.0
2012-04-27 05:28:00	SPY	ETF	140.15	140.15	140.15	140.15	100.0
2012-04-27 05:30:00	SPY	ETF	140.19	140.19	140.19	140.19	300.0
2012-04-27 05:32:00	SPY	ETF	140.2	140.2	140.2	140.2	100.0
2012-04-27 05:33:00	SPY	ETF	140.2	140.2	140.2	140.2	1000.0
2012-04-27 05:34:00	SPY	ETF	140.18	140.18	140.18	140.18	1700.0
2012-04-27 05:35:00	SPY	ETF	140.2	140.2	140.2	140.2	200.0
2012-04-27 05:38:00	SPY	ETF	140.2	140.2	140.2	140.2	1500.0
2012-04-27 05:41:00	SPY	ETF	140.18	140.18	140.17	140.17	400.0
2012-04-27 05:42:00	SPY	ETF	140.16	140.17	140.15	140.15	300.0
2012-04-27 05:43:00	SPY	ETF	140.14	140.14	140.14	140.14	200.0
2012-04-27 05:44:00	SPY	ETF	140.08	140.08	140.08	140.08	300.0
2012-04-27 05:45:00	SPY	ETF	140.1	140.1	140.1	140.1	300.0
2012-04-27 05:51:00	SPY	ETF	140.11	140.11	140.11	140.11	200.0
2012-04-27 05:53:00	SPY	ETF	140.05	140.05	140.05	140.05	100.0
2012-04-27 05:55:00	SPY	ETF	140.05	140.05	140.05	140.05	5500.0
2012-04-27 06:03:00	SPY	ETF	140.01	140.01	140.01	140.01	500.0
2012-04-27 06:07:00	SPY	ETF	140.02	140.02	140.02	140.02	5000.0
2012-04-27 06:10:00	SPY	ETF	139.99	139.99	139.99	139.99	200.0
2012-04-27 06:15:00	SPY	ETF	140.07	140.07	140.07	140.07	2500.0
2012-04-27 06:27:00	SPY	ETF	140.09	140.09	140.09	140.09	100.0
2012-04-27 06:28:00	SPY	ETF	140.1	140.1	140.1	140.1	2500.0
2012-04-27 06:30:00	SPY	ETF	140.13	140.13	140.13	140.13	500.0
2012-04-27 06:33:00	SPY	ETF	140.17	140.17	140.17	140.17	5000.0
2012-04-27 06:34:00	SPY	ETF	140.15	140.15	140.15	140.15	25000.0
2012-04-27 06:35:00	SPY	ETF	140.16	140.2	140.16	140.2	10000.0
2012-04-27 06:36:00	SPY	ETF	140.22	140.22	140.22	140.22	15000.0
2012-04-27 06:39:00	SPY	ETF	140.2	140.2	140.2	140.2	2000.0
2012-04-27 06:41:00	SPY	ETF	140.2	140.2	140.18	140.18	4000.0
2012-04-27 06:43:00	SPY	ETF	140.19	140.19	140.19	140.19	500.0
2012-04-27 06:45:00	SPY	ETF	140.2	140.2	140.2	140.2	222.0
2012-04-27 06:46:00	SPY	ETF	140.26	140.28	140.26	140.27	10200.0
2012-04-27 06:48:00	SPY	ETF	140.22	140.22	140.22	140.22	2900.0
2012-04-27 06:53:00	SPY	ETF	140.18	140.18	140.18	140.18	200.0
2012-04-27 06:55:00	SPY	ETF	140.22	140.24	140.2	140.2	53900.0
2012-04-27 06:56:00	SPY	ETF	140.2	140.2	140.2	140.2	200.0
2012-04-27 06:57:00	SPY	ETF	140.24	140.24	140.24	140.24	191.0
2012-04-27 07:00:00	SPY	ETF	140.2	140.3	140.2	140.27	42901.0

> showing 50 of 95,391 rows — these rows as CSV

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