PREVIEW / etf_5min / 2012-07-17

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-07-17.parquet
  size:    846 KB
  rows:    34,833

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-07-17 04:00:00	SPY	ETF	135.93	135.93	135.93	135.93	100.0
2012-07-17 04:05:00	SPY	ETF	135.96	135.96	135.95	135.95	500.0
2012-07-17 04:10:00	SPY	ETF	135.99	136.04	135.99	136.04	630.0
2012-07-17 04:15:00	SPY	ETF	136.0	136.0	136.0	136.0	100.0
2012-07-17 04:30:00	SPY	ETF	136.0	136.0	135.99	135.99	1100.0
2012-07-17 04:40:00	SPY	ETF	136.01	136.01	136.01	136.01	200.0
2012-07-17 04:45:00	SPY	ETF	136.0	136.0	135.99	135.99	400.0
2012-07-17 04:50:00	SPY	ETF	135.95	135.95	135.95	135.95	100.0
2012-07-17 05:00:00	SPY	ETF	135.89	135.89	135.85	135.85	1900.0
2012-07-17 05:05:00	SPY	ETF	135.99	136.01	135.99	136.01	200.0
2012-07-17 05:10:00	SPY	ETF	136.01	136.01	136.01	136.01	100.0
2012-07-17 05:35:00	SPY	ETF	135.91	135.91	135.91	135.91	100.0
2012-07-17 05:40:00	SPY	ETF	135.91	135.91	135.91	135.91	100.0
2012-07-17 05:50:00	SPY	ETF	135.89	135.89	135.89	135.89	200.0
2012-07-17 05:55:00	SPY	ETF	135.88	135.88	135.84	135.84	6100.0
2012-07-17 06:20:00	SPY	ETF	135.8	135.8	135.8	135.8	175.0
2012-07-17 06:30:00	SPY	ETF	135.78	135.78	135.78	135.78	100.0
2012-07-17 06:35:00	SPY	ETF	135.83	135.83	135.83	135.83	2000.0
2012-07-17 06:45:00	SPY	ETF	135.89	135.89	135.89	135.89	100.0
2012-07-17 06:55:00	SPY	ETF	135.85	135.85	135.81	135.81	950.0
2012-07-17 07:00:00	SPY	ETF	135.74	135.86	135.74	135.86	8650.0
2012-07-17 07:05:00	SPY	ETF	135.88	135.89	135.85	135.85	104400.0
2012-07-17 07:10:00	SPY	ETF	135.88	135.9	135.88	135.9	1775.0
2012-07-17 07:15:00	SPY	ETF	135.9	135.93	135.9	135.93	46500.0
2012-07-17 07:20:00	SPY	ETF	135.9	135.95	135.9	135.92	57900.0
2012-07-17 07:25:00	SPY	ETF	135.94	135.94	135.92	135.92	400.0
2012-07-17 07:30:00	SPY	ETF	135.9	135.9	135.82	135.86	28628.0
2012-07-17 07:35:00	SPY	ETF	135.88	136.0	135.88	135.97	54241.0
2012-07-17 07:40:00	SPY	ETF	135.97	136.0	135.96	136.0	17500.0
2012-07-17 07:45:00	SPY	ETF	136.01	136.05	135.97	136.01	98750.0
2012-07-17 07:50:00	SPY	ETF	136.01	136.03	136.0	136.03	18457.0
2012-07-17 07:55:00	SPY	ETF	136.0	136.0	135.94	136.0	81075.0
2012-07-17 08:00:00	SPY	ETF	136.0	136.16	135.83	135.83	836986.0
2012-07-17 08:05:00	SPY	ETF	135.85	135.94	135.85	135.93	20721.0
2012-07-17 08:10:00	SPY	ETF	135.94	135.97	135.94	135.96	21700.0
2012-07-17 08:15:00	SPY	ETF	135.96	136.0	135.94	135.96	34050.0
2012-07-17 08:20:00	SPY	ETF	135.98	136.0	135.9	135.91	29660.0
2012-07-17 08:25:00	SPY	ETF	135.91	136.01	135.75	135.78	84482.0
2012-07-17 08:30:00	SPY	ETF	135.84	135.88	135.8	135.84	38570.0
2012-07-17 08:35:00	SPY	ETF	135.82	135.92	135.82	135.91	1028502.0
2012-07-17 08:40:00	SPY	ETF	135.89	135.92	135.88	135.91	15970.0
2012-07-17 08:45:00	SPY	ETF	135.93	135.94	135.87	135.89	18200.0
2012-07-17 08:50:00	SPY	ETF	135.91	135.91	135.87	135.87	57550.0
2012-07-17 08:55:00	SPY	ETF	135.87	135.98	135.86	135.89	20500.0
2012-07-17 09:00:00	SPY	ETF	135.88	135.89	135.82	135.89	62200.0
2012-07-17 09:05:00	SPY	ETF	135.9	135.9	135.87	135.88	14792.0
2012-07-17 09:10:00	SPY	ETF	135.88	135.95	135.88	135.9	27819.0
2012-07-17 09:15:00	SPY	ETF	135.89	135.98	135.88	135.97	84569.0
2012-07-17 09:20:00	SPY	ETF	135.97	135.99	135.94	135.96	44458.0
2012-07-17 09:25:00	SPY	ETF	135.96	136.01	135.95	135.98	195345.0

> showing 50 of 34,833 rows — these rows as CSV

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