PREVIEW / etf_1min / 2012-03-27

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-03-27.parquet
  size:    1.9 MB
  rows:    104,832

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-27 04:10:00	SPY	ETF	142.29	142.29	142.29	142.29	210.0
2012-03-27 04:11:00	SPY	ETF	142.3	142.31	142.3	142.31	400.0
2012-03-27 04:26:00	SPY	ETF	142.35	142.35	142.35	142.35	100.0
2012-03-27 04:30:00	SPY	ETF	142.3	142.3	142.3	142.3	100.0
2012-03-27 04:48:00	SPY	ETF	142.25	142.25	142.25	142.25	100.0
2012-03-27 05:08:00	SPY	ETF	142.3	142.33	142.3	142.33	400.0
2012-03-27 05:09:00	SPY	ETF	142.39	142.39	142.38	142.38	700.0
2012-03-27 05:11:00	SPY	ETF	142.35	142.35	142.35	142.35	100.0
2012-03-27 05:12:00	SPY	ETF	142.36	142.36	142.36	142.36	200.0
2012-03-27 05:24:00	SPY	ETF	142.27	142.27	142.27	142.27	200.0
2012-03-27 05:27:00	SPY	ETF	142.24	142.24	142.24	142.24	200.0
2012-03-27 05:35:00	SPY	ETF	142.2	142.2	142.2	142.2	15000.0
2012-03-27 05:36:00	SPY	ETF	142.2	142.2	142.2	142.2	200.0
2012-03-27 05:41:00	SPY	ETF	142.15	142.15	142.15	142.15	100.0
2012-03-27 05:42:00	SPY	ETF	142.15	142.15	142.15	142.15	258.0
2012-03-27 05:45:00	SPY	ETF	142.06	142.06	142.05	142.05	1200.0
2012-03-27 05:49:00	SPY	ETF	142.09	142.09	142.09	142.09	200.0
2012-03-27 05:50:00	SPY	ETF	142.1	142.1	142.1	142.1	450.0
2012-03-27 05:53:00	SPY	ETF	142.05	142.05	142.05	142.05	20000.0
2012-03-27 05:57:00	SPY	ETF	142.07	142.07	142.07	142.07	2600.0
2012-03-27 05:58:00	SPY	ETF	142.03	142.03	142.03	142.03	300.0
2012-03-27 06:14:00	SPY	ETF	142.03	142.03	142.03	142.03	32000.0
2012-03-27 06:19:00	SPY	ETF	142.04	142.04	142.04	142.04	200.0
2012-03-27 06:25:00	SPY	ETF	142.1	142.1	142.1	142.1	1000.0
2012-03-27 06:27:00	SPY	ETF	142.07	142.07	142.07	142.07	100.0
2012-03-27 06:29:00	SPY	ETF	142.08	142.08	142.08	142.08	200.0
2012-03-27 06:30:00	SPY	ETF	142.08	142.08	142.08	142.08	200.0
2012-03-27 06:32:00	SPY	ETF	142.03	142.03	142.03	142.03	100.0
2012-03-27 06:37:00	SPY	ETF	141.97	141.97	141.97	141.97	5000.0
2012-03-27 06:46:00	SPY	ETF	141.99	141.99	141.99	141.99	4000.0
2012-03-27 06:47:00	SPY	ETF	141.97	141.97	141.97	141.97	300.0
2012-03-27 06:48:00	SPY	ETF	141.99	142.02	141.99	142.02	600.0
2012-03-27 06:59:00	SPY	ETF	142.05	142.1	142.05	142.1	5000.0
2012-03-27 07:00:00	SPY	ETF	141.96	141.96	141.96	141.96	139.0
2012-03-27 07:01:00	SPY	ETF	141.97	141.97	141.97	141.97	600.0
2012-03-27 07:02:00	SPY	ETF	141.97	141.97	141.97	141.97	200.0
2012-03-27 07:03:00	SPY	ETF	141.97	141.97	141.97	141.97	600.0
2012-03-27 07:04:00	SPY	ETF	141.97	142.0	141.97	141.97	3800.0
2012-03-27 07:05:00	SPY	ETF	141.97	141.97	141.97	141.97	300.0
2012-03-27 07:06:00	SPY	ETF	142.02	142.02	142.02	142.02	500.0
2012-03-27 07:08:00	SPY	ETF	142.02	142.02	141.97	141.97	2600.0
2012-03-27 07:09:00	SPY	ETF	141.97	141.97	141.97	141.97	100.0
2012-03-27 07:13:00	SPY	ETF	141.96	141.98	141.96	141.98	2200.0
2012-03-27 07:14:00	SPY	ETF	141.95	141.96	141.95	141.96	1100.0
2012-03-27 07:17:00	SPY	ETF	141.96	141.96	141.96	141.96	1000.0
2012-03-27 07:20:00	SPY	ETF	142.01	142.01	142.01	142.01	200.0
2012-03-27 07:21:00	SPY	ETF	142.02	142.02	142.02	142.02	1300.0
2012-03-27 07:22:00	SPY	ETF	142.04	142.04	142.04	142.04	400.0
2012-03-27 07:23:00	SPY	ETF	142.05	142.05	142.05	142.05	400.0
2012-03-27 07:24:00	SPY	ETF	142.04	142.04	142.04	142.04	100.0

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

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