PREVIEW / etf_5min / 2011-07-18

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-07-18.parquet
  size:    887 KB
  rows:    37,267

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
2011-07-18 04:00:00	SPY	ETF	131.85	131.85	131.05	131.08	5833.0
2011-07-18 04:05:00	SPY	ETF	131.15	131.17	131.12	131.15	1245.0
2011-07-18 04:10:00	SPY	ETF	131.1	131.1	131.0	131.0	4100.0
2011-07-18 04:30:00	SPY	ETF	131.2	131.2	131.2	131.2	250.0
2011-07-18 05:10:00	SPY	ETF	131.06	131.12	131.06	131.12	550.0
2011-07-18 05:15:00	SPY	ETF	131.11	131.11	131.11	131.11	200.0
2011-07-18 05:20:00	SPY	ETF	131.15	131.15	131.15	131.15	200.0
2011-07-18 05:25:00	SPY	ETF	131.15	131.15	131.15	131.15	300.0
2011-07-18 05:30:00	SPY	ETF	131.15	131.15	131.15	131.15	300.0
2011-07-18 05:40:00	SPY	ETF	131.21	131.21	131.21	131.21	10300.0
2011-07-18 05:45:00	SPY	ETF	131.15	131.15	131.1	131.1	1900.0
2011-07-18 05:55:00	SPY	ETF	131.09	131.12	131.05	131.05	11800.0
2011-07-18 06:00:00	SPY	ETF	131.04	131.11	131.0	131.0	12268.0
2011-07-18 06:05:00	SPY	ETF	131.07	131.08	131.07	131.08	300.0
2011-07-18 06:10:00	SPY	ETF	131.07	131.07	131.07	131.07	100.0
2011-07-18 06:15:00	SPY	ETF	131.07	131.07	130.9	130.9	5400.0
2011-07-18 06:20:00	SPY	ETF	131.04	131.12	131.0	131.0	2400.0
2011-07-18 06:25:00	SPY	ETF	131.11	131.11	131.11	131.11	600.0
2011-07-18 06:30:00	SPY	ETF	131.04	131.04	131.01	131.01	300.0
2011-07-18 06:35:00	SPY	ETF	130.92	130.92	130.9	130.9	2200.0
2011-07-18 06:40:00	SPY	ETF	130.99	130.99	130.99	130.99	5000.0
2011-07-18 06:45:00	SPY	ETF	130.95	131.0	130.89	130.9	8350.0
2011-07-18 06:50:00	SPY	ETF	130.91	130.91	130.85	130.9	3150.0
2011-07-18 06:55:00	SPY	ETF	130.9	130.96	130.85	130.96	11900.0
2011-07-18 07:00:00	SPY	ETF	130.98	131.01	130.92	130.94	60715.0
2011-07-18 07:05:00	SPY	ETF	130.98	131.06	130.95	130.95	28300.0
2011-07-18 07:10:00	SPY	ETF	130.96	131.01	130.92	131.01	62775.0
2011-07-18 07:15:00	SPY	ETF	131.01	131.02	130.96	130.97	251800.0
2011-07-18 07:20:00	SPY	ETF	130.97	130.97	130.74	130.74	765780.0
2011-07-18 07:25:00	SPY	ETF	130.74	130.79	130.6	130.73	506391.0
2011-07-18 07:30:00	SPY	ETF	130.73	130.81	130.7	130.8	219988.0
2011-07-18 07:35:00	SPY	ETF	130.8	130.86	130.8	130.84	30830.0
2011-07-18 07:40:00	SPY	ETF	130.88	130.88	130.83	130.87	47740.0
2011-07-18 07:45:00	SPY	ETF	130.89	130.99	130.89	130.95	31000.0
2011-07-18 07:50:00	SPY	ETF	130.95	131.05	130.95	131.01	47000.0
2011-07-18 07:55:00	SPY	ETF	131.03	131.14	131.03	131.03	122500.0
2011-07-18 08:00:00	SPY	ETF	131.03	131.17	130.88	130.88	1740452.0
2011-07-18 08:05:00	SPY	ETF	130.83	131.11	130.83	131.09	1966286.0
2011-07-18 08:10:00	SPY	ETF	131.09	131.14	131.04	131.04	119300.0
2011-07-18 08:15:00	SPY	ETF	131.05	131.05	130.98	131.0	295522.0
2011-07-18 08:20:00	SPY	ETF	131.0	131.13	131.0	131.09	72028.0
2011-07-18 08:25:00	SPY	ETF	131.09	131.09	130.91	131.06	81131.0
2011-07-18 08:30:00	SPY	ETF	131.08	131.14	131.07	131.11	1108539.0
2011-07-18 08:35:00	SPY	ETF	131.11	131.11	131.05	131.07	66668.0
2011-07-18 08:40:00	SPY	ETF	131.07	131.1	131.04	131.08	108269.0
2011-07-18 08:45:00	SPY	ETF	131.08	131.13	131.05	131.09	87666.0
2011-07-18 08:50:00	SPY	ETF	131.08	131.15	131.05	131.14	72513.0
2011-07-18 08:55:00	SPY	ETF	131.14	131.15	131.08	131.15	34501.0
2011-07-18 09:00:00	SPY	ETF	131.15	131.29	131.12	131.25	168375.0
2011-07-18 09:05:00	SPY	ETF	131.25	131.26	131.2	131.26	33132.0

> showing 50 of 37,267 rows — these rows as CSV

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