PREVIEW / etf_5min / 2012-04-30

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-30.parquet
  size:    802 KB
  rows:    35,232

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-04-30 04:05:00	SPY	ETF	140.38	140.38	140.38	140.38	1300.0
2012-04-30 04:20:00	SPY	ETF	140.36	140.36	140.36	140.36	300.0
2012-04-30 04:30:00	SPY	ETF	140.26	140.26	140.26	140.26	200.0
2012-04-30 05:20:00	SPY	ETF	140.2	140.2	140.2	140.2	500.0
2012-04-30 05:35:00	SPY	ETF	140.21	140.28	140.21	140.28	500.0
2012-04-30 05:40:00	SPY	ETF	140.28	140.28	140.23	140.23	200.0
2012-04-30 06:00:00	SPY	ETF	140.14	140.14	140.14	140.14	200.0
2012-04-30 06:05:00	SPY	ETF	140.14	140.14	140.14	140.14	200.0
2012-04-30 06:15:00	SPY	ETF	140.14	140.14	140.14	140.14	100.0
2012-04-30 06:20:00	SPY	ETF	140.13	140.13	140.13	140.13	100.0
2012-04-30 06:25:00	SPY	ETF	140.18	140.18	140.18	140.18	100.0
2012-04-30 06:30:00	SPY	ETF	140.2	140.2	140.18	140.18	700.0
2012-04-30 06:35:00	SPY	ETF	140.21	140.21	140.19	140.19	1200.0
2012-04-30 06:40:00	SPY	ETF	140.19	140.19	140.19	140.19	200.0
2012-04-30 06:50:00	SPY	ETF	140.26	140.26	140.25	140.25	600.0
2012-04-30 07:00:00	SPY	ETF	140.23	140.24	140.23	140.24	1740.0
2012-04-30 07:05:00	SPY	ETF	140.28	140.28	140.27	140.27	1000.0
2012-04-30 07:10:00	SPY	ETF	140.27	140.28	140.24	140.24	19960.0
2012-04-30 07:15:00	SPY	ETF	140.26	140.26	140.21	140.21	2650.0
2012-04-30 07:20:00	SPY	ETF	140.22	140.22	140.18	140.18	18650.0
2012-04-30 07:25:00	SPY	ETF	140.16	140.17	140.1	140.1	61281.0
2012-04-30 07:30:00	SPY	ETF	140.15	140.21	140.15	140.18	4750.0
2012-04-30 07:35:00	SPY	ETF	140.16	140.17	140.11	140.12	18900.0
2012-04-30 07:40:00	SPY	ETF	140.14	140.18	140.14	140.16	1510.0
2012-04-30 07:45:00	SPY	ETF	140.16	140.16	140.12	140.14	12625.0
2012-04-30 07:50:00	SPY	ETF	140.16	140.16	140.0	140.07	610348.0
2012-04-30 07:55:00	SPY	ETF	140.06	140.06	139.96	139.98	209540.0
2012-04-30 08:00:00	SPY	ETF	139.99	140.05	139.95	140.0	41380.0
2012-04-30 08:05:00	SPY	ETF	139.98	140.0	139.92	139.92	88820.0
2012-04-30 08:10:00	SPY	ETF	139.94	139.98	139.89	139.92	121650.0
2012-04-30 08:15:00	SPY	ETF	139.98	140.03	139.95	140.0	68726.0
2012-04-30 08:20:00	SPY	ETF	139.99	140.05	139.99	140.0	77600.0
2012-04-30 08:25:00	SPY	ETF	139.99	140.01	139.94	139.99	148835.0
2012-04-30 08:30:00	SPY	ETF	139.98	140.08	139.94	139.97	161009.0
2012-04-30 08:35:00	SPY	ETF	139.97	140.04	139.94	139.94	51800.0
2012-04-30 08:40:00	SPY	ETF	139.95	140.06	139.95	139.98	987199.0
2012-04-30 08:45:00	SPY	ETF	139.97	140.07	139.97	140.03	120475.0
2012-04-30 08:50:00	SPY	ETF	140.03	140.15	140.01	140.09	98636.0
2012-04-30 08:55:00	SPY	ETF	140.1	140.13	140.1	140.1	54953.0
2012-04-30 09:00:00	SPY	ETF	140.12	140.16	140.07	140.07	496713.0
2012-04-30 09:05:00	SPY	ETF	140.07	140.07	140.01	140.03	409729.0
2012-04-30 09:10:00	SPY	ETF	140.03	140.09	140.02	140.07	1404180.0
2012-04-30 09:15:00	SPY	ETF	140.07	140.12	140.06	140.1	68860.0
2012-04-30 09:20:00	SPY	ETF	140.09	140.13	140.09	140.13	59300.0
2012-04-30 09:25:00	SPY	ETF	140.13	140.13	140.05	140.09	387591.0
2012-04-30 09:30:00	SPY	ETF	140.11	140.21	140.06	140.06	2966058.0
2012-04-30 09:35:00	SPY	ETF	140.07	140.13	140.03	140.1	2010297.0
2012-04-30 09:40:00	SPY	ETF	140.09	140.1	139.75	139.79	7091583.0
2012-04-30 09:45:00	SPY	ETF	139.75	139.96	139.74	139.85	3375198.0
2012-04-30 09:50:00	SPY	ETF	139.86	139.91	139.74	139.76	1919463.0

> showing 50 of 35,232 rows — these rows as CSV

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