PREVIEW / etf_1min / 2014-07-11

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-07-11.parquet
  size:    1.9 MB
  rows:    99,964

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
2014-07-11 04:04:00	SPY	ETF	196.75	196.75	196.75	196.75	600.0
2014-07-11 04:05:00	SPY	ETF	196.79	196.79	196.79	196.79	100.0
2014-07-11 04:06:00	SPY	ETF	196.79	196.79	196.79	196.79	4381.0
2014-07-11 04:33:00	SPY	ETF	196.67	196.67	196.67	196.67	191.0
2014-07-11 04:35:00	SPY	ETF	196.7	196.7	196.7	196.7	1619.0
2014-07-11 04:52:00	SPY	ETF	196.68	196.68	196.68	196.68	100.0
2014-07-11 04:56:00	SPY	ETF	196.68	196.68	196.68	196.68	100.0
2014-07-11 04:58:00	SPY	ETF	196.71	196.71	196.71	196.71	200.0
2014-07-11 05:06:00	SPY	ETF	196.69	196.7	196.69	196.7	1600.0
2014-07-11 05:20:00	SPY	ETF	196.65	196.65	196.65	196.65	100.0
2014-07-11 05:35:00	SPY	ETF	196.61	196.63	196.59	196.63	2400.0
2014-07-11 05:49:00	SPY	ETF	196.59	196.59	196.59	196.59	100.0
2014-07-11 05:51:00	SPY	ETF	196.63	196.63	196.63	196.63	100.0
2014-07-11 05:52:00	SPY	ETF	196.63	196.63	196.63	196.63	650.0
2014-07-11 05:53:00	SPY	ETF	196.65	196.65	196.65	196.65	1053.0
2014-07-11 06:09:00	SPY	ETF	196.65	196.65	196.65	196.65	2800.0
2014-07-11 06:18:00	SPY	ETF	196.67	196.67	196.67	196.67	200.0
2014-07-11 06:25:00	SPY	ETF	196.7	196.7	196.7	196.7	100.0
2014-07-11 06:30:00	SPY	ETF	196.71	196.71	196.71	196.71	171.0
2014-07-11 06:32:00	SPY	ETF	196.72	196.72	196.7	196.7	1000.0
2014-07-11 06:34:00	SPY	ETF	196.67	196.67	196.66	196.66	10300.0
2014-07-11 06:43:00	SPY	ETF	196.6	196.6	196.59	196.59	757.0
2014-07-11 06:44:00	SPY	ETF	196.62	196.62	196.59	196.59	25343.0
2014-07-11 06:49:00	SPY	ETF	196.57	196.57	196.57	196.57	100.0
2014-07-11 06:50:00	SPY	ETF	196.55	196.55	196.49	196.49	1500.0
2014-07-11 06:55:00	SPY	ETF	196.47	196.48	196.47	196.47	300.0
2014-07-11 06:56:00	SPY	ETF	196.49	196.49	196.43	196.43	650.0
2014-07-11 06:57:00	SPY	ETF	196.43	196.43	196.43	196.43	100.0
2014-07-11 06:59:00	SPY	ETF	196.47	196.47	196.47	196.47	200.0
2014-07-11 07:00:00	SPY	ETF	196.49	196.5	196.49	196.49	6000.0
2014-07-11 07:01:00	SPY	ETF	196.51	196.53	196.51	196.53	400.0
2014-07-11 07:02:00	SPY	ETF	196.56	196.56	196.56	196.56	371.0
2014-07-11 07:03:00	SPY	ETF	196.58	196.59	196.58	196.58	6200.0
2014-07-11 07:04:00	SPY	ETF	196.57	196.63	196.57	196.57	2405.0
2014-07-11 07:05:00	SPY	ETF	196.57	196.57	196.57	196.57	3500.0
2014-07-11 07:06:00	SPY	ETF	196.58	196.58	196.58	196.58	240.0
2014-07-11 07:09:00	SPY	ETF	196.58	196.58	196.58	196.58	150.0
2014-07-11 07:10:00	SPY	ETF	196.57	196.57	196.57	196.57	200.0
2014-07-11 07:13:00	SPY	ETF	196.59	196.59	196.59	196.59	200.0
2014-07-11 07:15:00	SPY	ETF	196.57	196.57	196.57	196.57	3175.0
2014-07-11 07:17:00	SPY	ETF	196.57	196.58	196.56	196.57	15325.0
2014-07-11 07:19:00	SPY	ETF	196.57	196.59	196.57	196.59	740.0
2014-07-11 07:20:00	SPY	ETF	196.6	196.6	196.6	196.6	25000.0
2014-07-11 07:21:00	SPY	ETF	196.61	196.61	196.61	196.61	800.0
2014-07-11 07:22:00	SPY	ETF	196.62	196.62	196.62	196.62	1000.0
2014-07-11 07:23:00	SPY	ETF	196.62	196.62	196.62	196.62	2200.0
2014-07-11 07:24:00	SPY	ETF	196.6	196.6	196.6	196.6	100.0
2014-07-11 07:25:00	SPY	ETF	196.59	196.59	196.58	196.58	19700.0
2014-07-11 07:26:00	SPY	ETF	196.6	196.6	196.6	196.6	500.0
2014-07-11 07:27:00	SPY	ETF	196.57	196.57	196.57	196.57	5000.0

> showing 50 of 99,964 rows — these rows as CSV

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