PREVIEW / etf_1min / 2012-07-31

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-07-31.parquet
  size:    1.8 MB
  rows:    100,311

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-07-31 04:05:00	SPY	ETF	138.78	138.78	138.78	138.78	1000.0
2012-07-31 04:06:00	SPY	ETF	138.77	138.77	138.77	138.77	800.0
2012-07-31 04:34:00	SPY	ETF	138.93	138.93	138.93	138.93	394.0
2012-07-31 04:35:00	SPY	ETF	138.94	138.94	138.94	138.94	2400.0
2012-07-31 04:49:00	SPY	ETF	138.88	138.88	138.88	138.88	100.0
2012-07-31 05:00:00	SPY	ETF	138.9	138.9	138.9	138.9	100.0
2012-07-31 05:06:00	SPY	ETF	138.98	138.98	138.98	138.98	100.0
2012-07-31 05:24:00	SPY	ETF	138.97	138.97	138.97	138.97	250.0
2012-07-31 05:33:00	SPY	ETF	138.94	138.94	138.94	138.94	1500.0
2012-07-31 05:35:00	SPY	ETF	138.95	138.95	138.95	138.95	200.0
2012-07-31 05:44:00	SPY	ETF	139.02	139.02	139.02	139.02	1000.0
2012-07-31 05:53:00	SPY	ETF	139.01	139.01	139.01	139.01	1000.0
2012-07-31 06:00:00	SPY	ETF	139.06	139.11	139.06	139.11	802.0
2012-07-31 06:04:00	SPY	ETF	139.1	139.1	139.1	139.1	152.0
2012-07-31 06:18:00	SPY	ETF	138.96	138.96	138.96	138.96	600.0
2012-07-31 06:24:00	SPY	ETF	138.97	138.97	138.97	138.97	100.0
2012-07-31 06:38:00	SPY	ETF	138.91	138.91	138.91	138.91	200.0
2012-07-31 06:47:00	SPY	ETF	138.88	138.88	138.88	138.88	100.0
2012-07-31 06:53:00	SPY	ETF	138.85	138.85	138.85	138.85	700.0
2012-07-31 07:02:00	SPY	ETF	138.88	138.9	138.87	138.9	10350.0
2012-07-31 07:03:00	SPY	ETF	138.89	138.92	138.89	138.92	14800.0
2012-07-31 07:04:00	SPY	ETF	138.95	138.95	138.94	138.94	300.0
2012-07-31 07:05:00	SPY	ETF	138.93	138.97	138.92	138.96	17500.0
2012-07-31 07:06:00	SPY	ETF	138.97	139.0	138.97	139.0	8800.0
2012-07-31 07:08:00	SPY	ETF	138.95	138.96	138.95	138.96	7500.0
2012-07-31 07:09:00	SPY	ETF	138.99	138.99	138.99	138.99	16100.0
2012-07-31 07:11:00	SPY	ETF	138.94	138.94	138.94	138.94	200.0
2012-07-31 07:14:00	SPY	ETF	138.93	138.93	138.93	138.93	100.0
2012-07-31 07:15:00	SPY	ETF	138.92	138.94	138.92	138.94	200.0
2012-07-31 07:16:00	SPY	ETF	138.93	138.93	138.93	138.93	7005.0
2012-07-31 07:17:00	SPY	ETF	138.93	138.93	138.93	138.93	300.0
2012-07-31 07:18:00	SPY	ETF	138.89	138.89	138.89	138.89	5600.0
2012-07-31 07:19:00	SPY	ETF	138.9	138.9	138.9	138.9	1800.0
2012-07-31 07:20:00	SPY	ETF	138.9	138.9	138.88	138.88	2200.0
2012-07-31 07:21:00	SPY	ETF	138.88	138.88	138.88	138.88	3000.0
2012-07-31 07:22:00	SPY	ETF	138.87	138.87	138.87	138.87	100.0
2012-07-31 07:23:00	SPY	ETF	138.86	138.87	138.86	138.87	6875.0
2012-07-31 07:24:00	SPY	ETF	138.87	138.87	138.87	138.87	1000.0
2012-07-31 07:25:00	SPY	ETF	138.88	138.88	138.88	138.88	100.0
2012-07-31 07:26:00	SPY	ETF	138.87	138.87	138.82	138.82	5265.0
2012-07-31 07:30:00	SPY	ETF	138.82	138.82	138.82	138.82	4000.0
2012-07-31 07:31:00	SPY	ETF	138.83	138.83	138.83	138.83	200.0
2012-07-31 07:32:00	SPY	ETF	138.8	138.8	138.79	138.79	200.0
2012-07-31 07:34:00	SPY	ETF	138.77	138.77	138.77	138.77	2500.0
2012-07-31 07:35:00	SPY	ETF	138.79	138.79	138.79	138.79	700.0
2012-07-31 07:37:00	SPY	ETF	138.81	138.81	138.81	138.81	400.0
2012-07-31 07:39:00	SPY	ETF	138.84	138.84	138.84	138.84	200.0
2012-07-31 07:40:00	SPY	ETF	138.84	138.84	138.81	138.83	972.0
2012-07-31 07:42:00	SPY	ETF	138.84	138.84	138.84	138.84	500.0
2012-07-31 07:44:00	SPY	ETF	138.84	138.84	138.84	138.84	860.0

> showing 50 of 100,311 rows — these rows as CSV

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