PREVIEW / etf_1min / 2012-08-07

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-08-07.parquet
  size:    1.9 MB
  rows:    101,803

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-08-07 04:30:00	SPY	ETF	140.02	140.02	140.02	140.02	234.0
2012-08-07 04:53:00	SPY	ETF	139.89	139.89	139.89	139.89	357.0
2012-08-07 05:27:00	SPY	ETF	139.9	139.9	139.9	139.9	400.0
2012-08-07 05:30:00	SPY	ETF	139.91	139.91	139.91	139.91	100.0
2012-08-07 05:37:00	SPY	ETF	139.89	139.89	139.89	139.89	1000.0
2012-08-07 05:41:00	SPY	ETF	139.8	139.8	139.8	139.8	700.0
2012-08-07 05:44:00	SPY	ETF	139.8	139.8	139.8	139.8	300.0
2012-08-07 05:47:00	SPY	ETF	139.75	139.75	139.75	139.75	2000.0
2012-08-07 05:48:00	SPY	ETF	139.79	139.83	139.79	139.83	4000.0
2012-08-07 06:07:00	SPY	ETF	139.69	139.69	139.69	139.69	100.0
2012-08-07 06:08:00	SPY	ETF	139.65	139.65	139.65	139.65	1500.0
2012-08-07 06:16:00	SPY	ETF	139.81	139.81	139.81	139.81	100.0
2012-08-07 06:17:00	SPY	ETF	139.86	139.87	139.86	139.87	5000.0
2012-08-07 06:18:00	SPY	ETF	139.86	139.86	139.86	139.86	500.0
2012-08-07 06:25:00	SPY	ETF	139.98	139.99	139.97	139.99	2800.0
2012-08-07 06:26:00	SPY	ETF	140.0	140.0	140.0	140.0	100.0
2012-08-07 06:32:00	SPY	ETF	139.97	139.97	139.96	139.96	6000.0
2012-08-07 06:33:00	SPY	ETF	139.96	139.96	139.96	139.96	500.0
2012-08-07 06:34:00	SPY	ETF	139.96	139.96	139.96	139.96	3500.0
2012-08-07 06:36:00	SPY	ETF	140.0	140.0	140.0	140.0	200.0
2012-08-07 06:37:00	SPY	ETF	140.01	140.01	140.01	140.01	4900.0
2012-08-07 06:38:00	SPY	ETF	139.96	139.96	139.96	139.96	5000.0
2012-08-07 06:40:00	SPY	ETF	139.96	139.96	139.96	139.96	5000.0
2012-08-07 06:41:00	SPY	ETF	139.98	140.0	139.98	140.0	925.0
2012-08-07 06:42:00	SPY	ETF	140.01	140.01	139.96	139.96	6000.0
2012-08-07 06:45:00	SPY	ETF	140.0	140.01	140.0	140.01	2200.0
2012-08-07 06:48:00	SPY	ETF	140.0	140.02	140.0	140.02	3400.0
2012-08-07 06:59:00	SPY	ETF	140.0	140.0	140.0	140.0	100.0
2012-08-07 07:00:00	SPY	ETF	140.0	140.01	140.0	140.01	26100.0
2012-08-07 07:01:00	SPY	ETF	140.01	140.04	140.0	140.04	3000.0
2012-08-07 07:02:00	SPY	ETF	140.02	140.02	139.99	139.99	5400.0
2012-08-07 07:04:00	SPY	ETF	140.01	140.01	140.0	140.0	4700.0
2012-08-07 07:08:00	SPY	ETF	140.0	140.0	140.0	140.0	325.0
2012-08-07 07:12:00	SPY	ETF	140.03	140.03	140.0	140.0	1175.0
2012-08-07 07:13:00	SPY	ETF	139.97	139.99	139.97	139.99	6300.0
2012-08-07 07:16:00	SPY	ETF	140.01	140.01	140.01	140.01	400.0
2012-08-07 07:17:00	SPY	ETF	140.02	140.02	140.02	140.02	300.0
2012-08-07 07:18:00	SPY	ETF	139.99	139.99	139.99	139.99	100.0
2012-08-07 07:19:00	SPY	ETF	139.97	139.97	139.96	139.96	500.0
2012-08-07 07:20:00	SPY	ETF	139.95	139.95	139.95	139.95	600.0
2012-08-07 07:21:00	SPY	ETF	139.99	139.99	139.99	139.99	300.0
2012-08-07 07:23:00	SPY	ETF	140.01	140.01	139.99	139.99	1000.0
2012-08-07 07:24:00	SPY	ETF	140.01	140.01	140.01	140.01	700.0
2012-08-07 07:25:00	SPY	ETF	140.0	140.0	140.0	140.0	100.0
2012-08-07 07:26:00	SPY	ETF	140.03	140.1	140.03	140.09	2600.0
2012-08-07 07:27:00	SPY	ETF	140.08	140.08	140.08	140.08	19000.0
2012-08-07 07:28:00	SPY	ETF	140.08	140.08	140.08	140.08	100.0
2012-08-07 07:29:00	SPY	ETF	140.09	140.09	140.08	140.08	45100.0
2012-08-07 07:30:00	SPY	ETF	140.08	140.13	140.08	140.1	26000.0
2012-08-07 07:31:00	SPY	ETF	140.11	140.11	140.11	140.11	10000.0

> showing 50 of 101,803 rows — these rows as CSV

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