PREVIEW / etf_1min / 2014-01-07

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-01-07.parquet
  size:    2.2 MB
  rows:    118,616

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
2014-01-07 04:10:00	SPY	ETF	182.83	182.83	182.83	182.83	100.0
2014-01-07 04:12:00	SPY	ETF	182.86	182.86	182.86	182.86	120.0
2014-01-07 04:14:00	SPY	ETF	182.82	182.82	182.82	182.82	1000.0
2014-01-07 04:15:00	SPY	ETF	182.82	182.82	182.82	182.82	1000.0
2014-01-07 04:18:00	SPY	ETF	182.87	182.87	182.87	182.87	100.0
2014-01-07 04:20:00	SPY	ETF	182.87	182.87	182.87	182.87	900.0
2014-01-07 04:21:00	SPY	ETF	182.87	182.88	182.87	182.88	2216.0
2014-01-07 04:22:00	SPY	ETF	182.9	182.9	182.9	182.9	500.0
2014-01-07 04:23:00	SPY	ETF	182.9	182.9	182.9	182.9	500.0
2014-01-07 04:24:00	SPY	ETF	182.88	182.88	182.88	182.88	500.0
2014-01-07 04:25:00	SPY	ETF	182.87	182.87	182.87	182.87	600.0
2014-01-07 04:27:00	SPY	ETF	182.87	182.87	182.87	182.87	794.0
2014-01-07 04:37:00	SPY	ETF	182.84	182.84	182.84	182.84	300.0
2014-01-07 04:50:00	SPY	ETF	182.89	182.89	182.89	182.89	100.0
2014-01-07 04:58:00	SPY	ETF	182.9	182.9	182.9	182.9	366.0
2014-01-07 05:00:00	SPY	ETF	182.9	182.9	182.9	182.9	1000.0
2014-01-07 05:02:00	SPY	ETF	182.9	182.9	182.9	182.9	200.0
2014-01-07 05:04:00	SPY	ETF	182.9	182.9	182.9	182.9	200.0
2014-01-07 05:09:00	SPY	ETF	182.92	182.92	182.92	182.92	200.0
2014-01-07 05:18:00	SPY	ETF	182.95	182.95	182.95	182.95	200.0
2014-01-07 05:20:00	SPY	ETF	182.96	183.01	182.96	182.99	11500.0
2014-01-07 05:22:00	SPY	ETF	183.01	183.01	183.01	183.01	1000.0
2014-01-07 05:24:00	SPY	ETF	183.06	183.06	183.06	183.06	100.0
2014-01-07 05:25:00	SPY	ETF	183.06	183.06	183.06	183.06	1000.0
2014-01-07 05:26:00	SPY	ETF	183.05	183.05	183.05	183.05	200.0
2014-01-07 05:27:00	SPY	ETF	183.06	183.06	183.06	183.06	200.0
2014-01-07 05:28:00	SPY	ETF	183.09	183.09	183.09	183.09	900.0
2014-01-07 05:32:00	SPY	ETF	183.14	183.14	183.14	183.14	181.0
2014-01-07 05:34:00	SPY	ETF	183.1	183.1	183.1	183.1	10000.0
2014-01-07 05:35:00	SPY	ETF	183.1	183.1	183.1	183.1	100.0
2014-01-07 05:36:00	SPY	ETF	183.1	183.1	183.1	183.1	100.0
2014-01-07 05:37:00	SPY	ETF	183.1	183.12	183.1	183.12	5100.0
2014-01-07 05:50:00	SPY	ETF	183.05	183.05	183.05	183.05	100.0
2014-01-07 05:51:00	SPY	ETF	183.09	183.09	183.09	183.09	2000.0
2014-01-07 05:53:00	SPY	ETF	183.05	183.05	183.05	183.05	100.0
2014-01-07 05:56:00	SPY	ETF	183.1	183.1	183.1	183.1	765.0
2014-01-07 05:59:00	SPY	ETF	183.12	183.12	183.12	183.12	114.0
2014-01-07 06:03:00	SPY	ETF	183.1	183.1	183.1	183.1	5000.0
2014-01-07 06:05:00	SPY	ETF	183.1	183.1	183.1	183.1	10000.0
2014-01-07 06:08:00	SPY	ETF	183.1	183.1	183.1	183.1	25000.0
2014-01-07 06:10:00	SPY	ETF	183.14	183.14	183.14	183.14	100.0
2014-01-07 06:14:00	SPY	ETF	183.11	183.11	183.11	183.11	200.0
2014-01-07 06:18:00	SPY	ETF	183.1	183.1	183.1	183.1	25625.0
2014-01-07 06:20:00	SPY	ETF	183.11	183.11	183.11	183.11	10000.0
2014-01-07 06:23:00	SPY	ETF	183.05	183.05	183.05	183.05	200.0
2014-01-07 06:25:00	SPY	ETF	183.0	183.0	183.0	183.0	100.0
2014-01-07 06:26:00	SPY	ETF	183.01	183.01	183.01	183.01	1500.0
2014-01-07 06:33:00	SPY	ETF	182.96	182.96	182.96	182.96	200.0
2014-01-07 06:35:00	SPY	ETF	182.97	182.97	182.97	182.97	1395.0
2014-01-07 06:38:00	SPY	ETF	182.96	182.96	182.96	182.96	100.0

> showing 50 of 118,616 rows — these rows as CSV

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