PREVIEW / etf_5min / 2012-09-14

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-09-14.parquet
  size:    1002 KB
  rows:    42,510

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-09-14 04:00:00	SPY	ETF	146.8	146.8	146.8	146.8	100.0
2012-09-14 04:20:00	SPY	ETF	146.67	146.67	146.67	146.67	1000.0
2012-09-14 04:25:00	SPY	ETF	146.65	146.65	146.65	146.65	200.0
2012-09-14 04:35:00	SPY	ETF	146.77	146.78	146.77	146.78	300.0
2012-09-14 04:40:00	SPY	ETF	146.78	146.78	146.78	146.78	100.0
2012-09-14 05:00:00	SPY	ETF	146.78	146.78	146.77	146.77	22950.0
2012-09-14 05:10:00	SPY	ETF	146.77	146.85	146.77	146.85	1800.0
2012-09-14 05:15:00	SPY	ETF	146.87	146.87	146.87	146.87	200.0
2012-09-14 05:20:00	SPY	ETF	146.84	146.84	146.84	146.84	200.0
2012-09-14 05:25:00	SPY	ETF	146.87	146.9	146.87	146.9	500.0
2012-09-14 05:30:00	SPY	ETF	146.9	146.9	146.9	146.9	100.0
2012-09-14 05:35:00	SPY	ETF	146.9	146.92	146.9	146.92	25100.0
2012-09-14 05:40:00	SPY	ETF	146.97	146.98	146.97	146.98	5100.0
2012-09-14 05:45:00	SPY	ETF	146.95	146.99	146.95	146.99	14800.0
2012-09-14 05:50:00	SPY	ETF	146.99	146.99	146.98	146.98	8200.0
2012-09-14 05:55:00	SPY	ETF	146.98	147.0	146.98	146.99	15900.0
2012-09-14 06:00:00	SPY	ETF	146.95	146.95	146.95	146.95	400.0
2012-09-14 06:05:00	SPY	ETF	146.97	146.98	146.97	146.98	700.0
2012-09-14 06:10:00	SPY	ETF	147.1	147.12	147.1	147.12	17600.0
2012-09-14 06:15:00	SPY	ETF	147.1	147.12	147.05	147.1	8670.0
2012-09-14 06:20:00	SPY	ETF	147.1	147.1	147.06	147.07	5600.0
2012-09-14 06:25:00	SPY	ETF	147.03	147.03	147.01	147.01	9950.0
2012-09-14 06:30:00	SPY	ETF	147.02	147.07	147.02	147.07	20575.0
2012-09-14 06:40:00	SPY	ETF	147.06	147.07	147.01	147.07	2570.0
2012-09-14 06:45:00	SPY	ETF	147.07	147.11	147.07	147.11	700.0
2012-09-14 06:50:00	SPY	ETF	147.11	147.13	147.1	147.12	5600.0
2012-09-14 06:55:00	SPY	ETF	147.13	147.13	147.12	147.12	7200.0
2012-09-14 07:00:00	SPY	ETF	147.11	147.14	147.09	147.12	21052.0
2012-09-14 07:05:00	SPY	ETF	147.12	147.12	147.1	147.1	36500.0
2012-09-14 07:10:00	SPY	ETF	147.1	147.1	147.08	147.08	15570.0
2012-09-14 07:15:00	SPY	ETF	147.05	147.12	147.05	147.12	28529.0
2012-09-14 07:20:00	SPY	ETF	147.14	147.17	147.14	147.16	15185.0
2012-09-14 07:25:00	SPY	ETF	147.15	147.15	147.08	147.09	17606.0
2012-09-14 07:30:00	SPY	ETF	147.08	147.11	147.08	147.11	11441.0
2012-09-14 07:35:00	SPY	ETF	147.1	147.1	147.05	147.05	19765.0
2012-09-14 07:40:00	SPY	ETF	147.05	147.07	147.02	147.02	46325.0
2012-09-14 07:45:00	SPY	ETF	147.03	147.06	147.0	147.0	36790.0
2012-09-14 07:50:00	SPY	ETF	147.01	147.01	146.96	146.97	22648.0
2012-09-14 07:55:00	SPY	ETF	146.97	146.99	146.91	146.93	60550.0
2012-09-14 08:00:00	SPY	ETF	146.95	147.12	146.86	146.92	492865.0
2012-09-14 08:05:00	SPY	ETF	146.93	147.02	146.89	147.02	167304.0
2012-09-14 08:10:00	SPY	ETF	147.03	147.04	146.98	147.01	292499.0
2012-09-14 08:15:00	SPY	ETF	147.02	147.04	147.01	147.01	176298.0
2012-09-14 08:20:00	SPY	ETF	147.02	147.04	147.0	147.0	139588.0
2012-09-14 08:25:00	SPY	ETF	146.98	147.0	146.96	146.99	28779.0
2012-09-14 08:30:00	SPY	ETF	147.16	147.17	146.81	146.82	214857.0
2012-09-14 08:35:00	SPY	ETF	146.81	146.86	146.72	146.83	215556.0
2012-09-14 08:40:00	SPY	ETF	146.83	146.84	146.79	146.79	64001.0
2012-09-14 08:45:00	SPY	ETF	146.79	146.79	146.68	146.69	153226.0
2012-09-14 08:50:00	SPY	ETF	146.69	146.78	146.69	146.77	175551.0

> showing 50 of 42,510 rows — these rows as CSV

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