PREVIEW / etf_1min / 2012-11-02

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-11-02.parquet
  size:    1.9 MB
  rows:    98,828

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-11-02 04:20:00	SPY	ETF	142.82	142.82	142.82	142.82	2500.0
2012-11-02 04:30:00	SPY	ETF	142.86	142.86	142.86	142.86	15000.0
2012-11-02 04:34:00	SPY	ETF	142.81	142.81	142.81	142.81	10500.0
2012-11-02 04:48:00	SPY	ETF	142.73	142.73	142.73	142.73	100.0
2012-11-02 04:58:00	SPY	ETF	142.78	142.78	142.78	142.78	140.0
2012-11-02 04:59:00	SPY	ETF	142.75	142.75	142.69	142.69	200.0
2012-11-02 05:01:00	SPY	ETF	142.74	142.74	142.74	142.74	500.0
2012-11-02 05:03:00	SPY	ETF	142.74	142.74	142.74	142.74	300.0
2012-11-02 05:05:00	SPY	ETF	142.68	142.68	142.68	142.68	200.0
2012-11-02 05:24:00	SPY	ETF	142.76	142.76	142.76	142.76	100.0
2012-11-02 05:46:00	SPY	ETF	142.76	142.76	142.76	142.76	100.0
2012-11-02 06:08:00	SPY	ETF	142.93	142.93	142.93	142.93	200.0
2012-11-02 06:22:00	SPY	ETF	142.98	142.98	142.98	142.98	500.0
2012-11-02 06:53:00	SPY	ETF	142.96	142.96	142.96	142.96	500.0
2012-11-02 07:06:00	SPY	ETF	142.98	142.98	142.95	142.95	600.0
2012-11-02 07:12:00	SPY	ETF	142.96	142.96	142.96	142.96	100.0
2012-11-02 07:13:00	SPY	ETF	142.96	142.96	142.95	142.95	20000.0
2012-11-02 07:20:00	SPY	ETF	142.97	142.97	142.97	142.97	100.0
2012-11-02 07:23:00	SPY	ETF	142.93	143.0	142.92	143.0	6180.0
2012-11-02 07:25:00	SPY	ETF	142.98	143.01	142.98	143.01	10000.0
2012-11-02 07:26:00	SPY	ETF	143.01	143.01	143.01	143.01	700.0
2012-11-02 07:31:00	SPY	ETF	142.97	142.97	142.97	142.97	300.0
2012-11-02 07:35:00	SPY	ETF	142.97	142.97	142.97	142.97	1700.0
2012-11-02 07:36:00	SPY	ETF	142.97	142.97	142.97	142.97	100.0
2012-11-02 07:38:00	SPY	ETF	142.97	142.99	142.96	142.99	700.0
2012-11-02 07:40:00	SPY	ETF	143.0	143.0	143.0	143.0	200.0
2012-11-02 07:41:00	SPY	ETF	143.0	143.0	143.0	143.0	300.0
2012-11-02 07:42:00	SPY	ETF	143.0	143.01	143.0	143.0	7275.0
2012-11-02 07:47:00	SPY	ETF	142.99	142.99	142.99	142.99	200.0
2012-11-02 07:48:00	SPY	ETF	142.99	142.99	142.99	142.99	1400.0
2012-11-02 07:49:00	SPY	ETF	142.99	142.99	142.99	142.99	8600.0
2012-11-02 07:51:00	SPY	ETF	142.98	142.98	142.94	142.94	2900.0
2012-11-02 07:52:00	SPY	ETF	143.0	143.0	142.99	142.99	200.0
2012-11-02 07:53:00	SPY	ETF	142.96	142.96	142.96	142.96	200.0
2012-11-02 07:54:00	SPY	ETF	142.98	142.98	142.94	142.94	25125.0
2012-11-02 07:55:00	SPY	ETF	142.98	142.98	142.97	142.97	6100.0
2012-11-02 07:59:00	SPY	ETF	142.94	142.94	142.94	142.94	5000.0
2012-11-02 08:00:00	SPY	ETF	142.94	142.94	142.94	142.94	1075.0
2012-11-02 08:01:00	SPY	ETF	142.99	142.99	142.92	142.92	6140.0
2012-11-02 08:02:00	SPY	ETF	142.92	142.92	142.92	142.92	500.0
2012-11-02 08:04:00	SPY	ETF	142.93	142.93	142.93	142.93	360.0
2012-11-02 08:05:00	SPY	ETF	142.9	142.97	142.9	142.91	275000.0
2012-11-02 08:06:00	SPY	ETF	142.9	142.9	142.82	142.82	9050.0
2012-11-02 08:07:00	SPY	ETF	142.88	142.88	142.84	142.85	17900.0
2012-11-02 08:08:00	SPY	ETF	142.85	142.85	142.81	142.85	28530.0
2012-11-02 08:09:00	SPY	ETF	142.87	142.87	142.87	142.87	100.0
2012-11-02 08:10:00	SPY	ETF	142.86	142.87	142.83	142.83	1800.0
2012-11-02 08:11:00	SPY	ETF	142.84	142.84	142.84	142.84	200.0
2012-11-02 08:12:00	SPY	ETF	142.87	142.87	142.87	142.87	1250.0
2012-11-02 08:13:00	SPY	ETF	142.86	142.86	142.84	142.84	2175.0

> showing 50 of 98,828 rows — these rows as CSV

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