PREVIEW / stock_5min / 2014-03-14

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-03-14.parquet
  size:    5.4 MB
  rows:    360,335
  symbols: 3,543

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-03-14 04:00:00	AAPL	Stock	18.8925	18.9286	18.8925	18.9286	11200.0
2014-03-14 04:05:00	AAPL	Stock	18.8929	18.8929	18.8929	18.8929	5600.0
2014-03-14 06:35:00	AAPL	Stock	18.9071	18.9071	18.9071	18.9071	2800.0
2014-03-14 06:45:00	AAPL	Stock	18.9018	18.9018	18.9018	18.9018	2800.0
2014-03-14 07:00:00	AAPL	Stock	18.9071	18.925	18.9071	18.925	19600.0
2014-03-14 07:05:00	AAPL	Stock	18.9246	18.9246	18.9246	18.9246	2800.0
2014-03-14 07:10:00	AAPL	Stock	18.9089	18.9089	18.9036	18.9036	11200.0
2014-03-14 07:15:00	AAPL	Stock	18.9229	18.9371	18.9229	18.9286	42896.0
2014-03-14 07:20:00	AAPL	Stock	18.9286	18.9286	18.9286	18.9286	19600.0
2014-03-14 07:30:00	AAPL	Stock	18.9143	18.9143	18.9143	18.9143	5600.0
2014-03-14 07:35:00	AAPL	Stock	18.9107	18.9107	18.9107	18.9107	14000.0
2014-03-14 07:40:00	AAPL	Stock	18.8968	18.8968	18.8968	18.8968	5600.0
2014-03-14 07:45:00	AAPL	Stock	18.9104	18.9129	18.9104	18.9107	19012.0
2014-03-14 07:55:00	AAPL	Stock	18.9114	18.9114	18.9114	18.9114	2800.0
2014-03-14 08:00:00	AAPL	Stock	18.9196	18.9286	18.9	18.9218	79856.0
2014-03-14 08:05:00	AAPL	Stock	18.9139	18.9243	18.9139	18.9243	39200.0
2014-03-14 08:10:00	AAPL	Stock	18.9175	18.9182	18.9161	18.9161	37688.0
2014-03-14 08:25:00	AAPL	Stock	18.9057	18.9057	18.9029	18.9029	11200.0
2014-03-14 08:30:00	AAPL	Stock	18.8996	18.8996	18.8904	18.8904	49784.0
2014-03-14 08:35:00	AAPL	Stock	18.895	18.9007	18.885	18.89	51520.0
2014-03-14 08:40:00	AAPL	Stock	18.8839	18.8839	18.8786	18.8786	29568.0
2014-03-14 08:45:00	AAPL	Stock	18.8861	18.8861	18.8821	18.8839	28000.0
2014-03-14 08:50:00	AAPL	Stock	18.8854	18.8857	18.8854	18.8857	7280.0
2014-03-14 08:55:00	AAPL	Stock	18.885	18.885	18.885	18.885	2800.0
2014-03-14 09:00:00	AAPL	Stock	18.8929	18.8929	18.8929	18.8929	5600.0
2014-03-14 09:05:00	AAPL	Stock	18.9018	18.9161	18.9018	18.9161	5600.0
2014-03-14 09:10:00	AAPL	Stock	18.9029	18.9046	18.8929	18.8929	25200.0
2014-03-14 09:20:00	AAPL	Stock	18.8914	18.8932	18.8914	18.8932	5600.0
2014-03-14 09:25:00	AAPL	Stock	18.8893	18.9107	18.8589	18.8779	216608.0
2014-03-14 09:30:00	AAPL	Stock	18.8646	18.9604	18.8632	18.8857	9295720.0
2014-03-14 09:35:00	AAPL	Stock	18.9004	18.9214	18.8786	18.912	3445764.0
2014-03-14 09:40:00	AAPL	Stock	18.9111	18.9286	18.8754	18.9082	3477880.0
2014-03-14 09:45:00	AAPL	Stock	18.9	18.9172	18.8504	18.8714	3900904.0
2014-03-14 09:50:00	AAPL	Stock	18.87	18.8821	18.7939	18.8225	6003144.0
2014-03-14 09:55:00	AAPL	Stock	18.8218	18.8368	18.795	18.8089	3861424.0
2014-03-14 10:00:00	AAPL	Stock	18.8046	18.8393	18.8036	18.82	4221560.0
2014-03-14 10:05:00	AAPL	Stock	18.8261	18.8555	18.8196	18.8507	4206328.0
2014-03-14 10:10:00	AAPL	Stock	18.8539	18.86	18.8196	18.8216	2718296.0
2014-03-14 10:15:00	AAPL	Stock	18.82	18.8439	18.7964	18.8382	5540024.0
2014-03-14 10:20:00	AAPL	Stock	18.8382	18.8389	18.7536	18.8036	7524300.0
2014-03-14 10:25:00	AAPL	Stock	18.8032	18.8039	18.7618	18.7737	3129084.0
2014-03-14 10:30:00	AAPL	Stock	18.7722	18.7925	18.7643	18.7818	2060576.0
2014-03-14 10:35:00	AAPL	Stock	18.7795	18.781	18.7314	18.7446	5637268.0
2014-03-14 10:40:00	AAPL	Stock	18.7429	18.7536	18.7236	18.7246	2874088.0
2014-03-14 10:45:00	AAPL	Stock	18.7239	18.7743	18.7239	18.7443	2955232.0
2014-03-14 10:50:00	AAPL	Stock	18.7464	18.7539	18.7271	18.7275	2432304.0
2014-03-14 10:55:00	AAPL	Stock	18.7262	18.7471	18.7057	18.73	3167136.0
2014-03-14 11:00:00	AAPL	Stock	18.7307	18.7346	18.703	18.7214	3039792.0
2014-03-14 11:05:00	AAPL	Stock	18.7216	18.7236	18.6911	18.7043	4412660.0
2014-03-14 11:10:00	AAPL	Stock	18.7014	18.7043	18.6786	18.6862	3994704.0

> showing 50 of 360,335 rows — these rows as CSV

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