PREVIEW / etf_5min / 2012-09-20

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-09-20.parquet
  size:    876 KB
  rows:    36,786

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-20 04:00:00	SPY	ETF	146.19	146.19	146.0	146.0	3116.0
2012-09-20 04:30:00	SPY	ETF	146.19	146.19	146.15	146.15	300.0
2012-09-20 04:50:00	SPY	ETF	146.12	146.14	146.12	146.14	200.0
2012-09-20 05:00:00	SPY	ETF	146.15	146.15	146.07	146.07	1220.0
2012-09-20 05:10:00	SPY	ETF	146.03	146.03	146.03	146.03	100.0
2012-09-20 05:15:00	SPY	ETF	146.03	146.03	146.01	146.01	10200.0
2012-09-20 05:20:00	SPY	ETF	145.98	145.99	145.98	145.99	15000.0
2012-09-20 05:25:00	SPY	ETF	146.03	146.03	146.03	146.03	5000.0
2012-09-20 05:35:00	SPY	ETF	146.09	146.1	146.09	146.1	500.0
2012-09-20 05:40:00	SPY	ETF	146.15	146.15	146.15	146.15	3500.0
2012-09-20 06:00:00	SPY	ETF	146.15	146.15	146.15	146.15	5000.0
2012-09-20 06:10:00	SPY	ETF	146.14	146.15	146.14	146.15	8400.0
2012-09-20 06:15:00	SPY	ETF	146.15	146.2	146.15	146.16	8600.0
2012-09-20 06:20:00	SPY	ETF	146.15	146.15	146.15	146.15	100.0
2012-09-20 06:25:00	SPY	ETF	146.17	146.18	146.17	146.18	4000.0
2012-09-20 06:30:00	SPY	ETF	146.21	146.25	146.2	146.23	10800.0
2012-09-20 06:35:00	SPY	ETF	146.25	146.25	146.21	146.25	11450.0
2012-09-20 06:40:00	SPY	ETF	146.23	146.23	146.21	146.21	5000.0
2012-09-20 06:45:00	SPY	ETF	146.19	146.19	146.19	146.19	500.0
2012-09-20 06:50:00	SPY	ETF	146.19	146.19	146.18	146.18	24889.0
2012-09-20 06:55:00	SPY	ETF	146.2	146.2	146.19	146.19	1100.0
2012-09-20 07:00:00	SPY	ETF	146.17	146.19	146.17	146.19	51100.0
2012-09-20 07:05:00	SPY	ETF	146.19	146.23	146.19	146.22	6125.0
2012-09-20 07:10:00	SPY	ETF	146.22	146.28	146.22	146.27	26175.0
2012-09-20 07:15:00	SPY	ETF	146.24	146.28	146.22	146.28	3300.0
2012-09-20 07:20:00	SPY	ETF	146.3	146.3	146.23	146.23	2700.0
2012-09-20 07:25:00	SPY	ETF	146.23	146.26	146.21	146.21	9866.0
2012-09-20 07:30:00	SPY	ETF	146.21	146.21	146.15	146.17	122800.0
2012-09-20 07:35:00	SPY	ETF	146.18	146.18	146.13	146.14	17500.0
2012-09-20 07:40:00	SPY	ETF	146.15	146.15	146.1	146.13	36450.0
2012-09-20 07:45:00	SPY	ETF	146.12	146.19	146.12	146.19	5550.0
2012-09-20 07:50:00	SPY	ETF	146.18	146.2	146.15	146.18	5100.0
2012-09-20 07:55:00	SPY	ETF	146.19	146.19	146.18	146.18	6400.0
2012-09-20 08:00:00	SPY	ETF	146.18	146.21	146.15	146.2	104245.0
2012-09-20 08:05:00	SPY	ETF	146.2	146.2	146.18	146.18	4471.0
2012-09-20 08:10:00	SPY	ETF	146.18	146.18	146.13	146.13	82590.0
2012-09-20 08:15:00	SPY	ETF	146.13	146.15	146.08	146.13	37861.0
2012-09-20 08:20:00	SPY	ETF	146.1	146.15	146.1	146.13	11770.0
2012-09-20 08:25:00	SPY	ETF	146.11	146.19	146.1	146.15	38239.0
2012-09-20 08:30:00	SPY	ETF	146.15	146.15	146.03	146.06	125210.0
2012-09-20 08:35:00	SPY	ETF	146.06	146.06	145.97	145.97	153354.0
2012-09-20 08:40:00	SPY	ETF	145.97	145.99	145.93	145.96	199647.0
2012-09-20 08:45:00	SPY	ETF	145.96	145.97	145.89	145.9	175916.0
2012-09-20 08:50:00	SPY	ETF	145.9	145.94	145.86	145.9	177000.0
2012-09-20 08:55:00	SPY	ETF	145.91	146.02	145.9	146.01	86967.0
2012-09-20 09:00:00	SPY	ETF	146.02	146.03	145.98	146.0	173533.0
2012-09-20 09:05:00	SPY	ETF	146.0	146.06	145.96	145.97	53950.0
2012-09-20 09:10:00	SPY	ETF	145.97	146.03	145.97	145.98	73950.0
2012-09-20 09:15:00	SPY	ETF	145.99	146.03	145.97	146.03	155977.0
2012-09-20 09:20:00	SPY	ETF	146.02	146.08	146.0	146.04	194191.0

> showing 50 of 36,786 rows — these rows as CSV

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