PREVIEW / stock_5min / 2014-04-28

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-04-28.parquet
  size:    5.5 MB
  rows:    365,678
  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-04-28 04:00:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	2800.0
2014-04-28 04:10:00	AAPL	Stock	20.4464	20.4793	20.4464	20.4793	10640.0
2014-04-28 04:50:00	AAPL	Stock	20.4679	20.4786	20.4679	20.4786	14000.0
2014-04-28 05:00:00	AAPL	Stock	20.475	20.475	20.475	20.475	19600.0
2014-04-28 05:05:00	AAPL	Stock	20.475	20.475	20.475	20.475	58576.0
2014-04-28 05:40:00	AAPL	Stock	20.475	20.475	20.475	20.475	8400.0
2014-04-28 05:45:00	AAPL	Stock	20.4532	20.4532	20.445	20.445	8400.0
2014-04-28 05:50:00	AAPL	Stock	20.4286	20.4293	20.4218	20.4218	51408.0
2014-04-28 05:55:00	AAPL	Stock	20.4339	20.4339	20.4339	20.4339	2800.0
2014-04-28 06:10:00	AAPL	Stock	20.4339	20.4339	20.4339	20.4339	2800.0
2014-04-28 07:00:00	AAPL	Stock	20.4636	20.4643	20.4636	20.4643	25872.0
2014-04-28 07:05:00	AAPL	Stock	20.4643	20.4668	20.4643	20.4668	11200.0
2014-04-28 07:10:00	AAPL	Stock	20.4696	20.475	20.4696	20.475	14000.0
2014-04-28 07:15:00	AAPL	Stock	20.4768	20.4768	20.4718	20.475	25956.0
2014-04-28 07:20:00	AAPL	Stock	20.475	20.475	20.4686	20.4718	26124.0
2014-04-28 07:25:00	AAPL	Stock	20.4686	20.4768	20.4686	20.4768	69216.0
2014-04-28 07:30:00	AAPL	Stock	20.47	20.4786	20.4643	20.4782	214284.0
2014-04-28 07:35:00	AAPL	Stock	20.4711	20.4761	20.4696	20.4696	42000.0
2014-04-28 07:40:00	AAPL	Stock	20.47	20.4743	20.47	20.4732	21000.0
2014-04-28 07:45:00	AAPL	Stock	20.4693	20.4732	20.4557	20.4729	23800.0
2014-04-28 07:50:00	AAPL	Stock	20.4729	20.4729	20.4643	20.4643	5600.0
2014-04-28 07:55:00	AAPL	Stock	20.4564	20.4725	20.4554	20.4725	14000.0
2014-04-28 08:00:00	AAPL	Stock	20.4679	20.4746	20.4396	20.4464	319200.0
2014-04-28 08:05:00	AAPL	Stock	20.4354	20.4443	20.4275	20.4386	126896.0
2014-04-28 08:10:00	AAPL	Stock	20.4286	20.4375	20.4061	20.4286	261772.0
2014-04-28 08:15:00	AAPL	Stock	20.4286	20.4618	20.4286	20.4468	108920.0
2014-04-28 08:20:00	AAPL	Stock	20.4564	20.4614	20.4482	20.4614	89600.0
2014-04-28 08:25:00	AAPL	Stock	20.4596	20.4618	20.4439	20.4446	218484.0
2014-04-28 08:30:00	AAPL	Stock	20.4464	20.4464	20.4464	20.4464	2800.0
2014-04-28 08:35:00	AAPL	Stock	20.4446	20.4464	20.4346	20.4346	95816.0
2014-04-28 08:40:00	AAPL	Stock	20.445	20.4464	20.4379	20.4454	30800.0
2014-04-28 08:45:00	AAPL	Stock	20.4464	20.4514	20.4407	20.4486	107744.0
2014-04-28 08:50:00	AAPL	Stock	20.4536	20.4536	20.4425	20.4489	237076.0
2014-04-28 08:55:00	AAPL	Stock	20.4504	20.4564	20.4486	20.4536	149744.0
2014-04-28 09:00:00	AAPL	Stock	20.4536	20.4536	20.4311	20.4311	254240.0
2014-04-28 09:05:00	AAPL	Stock	20.4361	20.4496	20.4361	20.4464	110992.0
2014-04-28 09:10:00	AAPL	Stock	20.45	20.4536	20.4468	20.45	76328.0
2014-04-28 09:15:00	AAPL	Stock	20.45	20.4589	20.4482	20.4571	43960.0
2014-04-28 09:20:00	AAPL	Stock	20.4571	20.4693	20.4571	20.4639	267848.0
2014-04-28 09:25:00	AAPL	Stock	20.4629	20.4643	20.4429	20.4554	562184.0
2014-04-28 09:30:00	AAPL	Stock	20.4571	20.5261	20.4482	20.5232	19797708.0
2014-04-28 09:35:00	AAPL	Stock	20.5236	20.5482	20.4907	20.5186	13886656.0
2014-04-28 09:40:00	AAPL	Stock	20.5189	20.5868	20.5004	20.5843	9787064.0
2014-04-28 09:45:00	AAPL	Stock	20.5867	20.6925	20.5775	20.6579	15654688.0
2014-04-28 09:50:00	AAPL	Stock	20.66	20.7264	20.6579	20.7214	14158200.0
2014-04-28 09:55:00	AAPL	Stock	20.7157	20.8214	20.7061	20.8021	14481712.0
2014-04-28 10:00:00	AAPL	Stock	20.8068	20.8682	20.7839	20.8179	15309504.0
2014-04-28 10:05:00	AAPL	Stock	20.8182	20.8989	20.7979	20.8771	10912104.0
2014-04-28 10:10:00	AAPL	Stock	20.8804	21.0082	20.8679	20.9957	12590788.0
2014-04-28 10:15:00	AAPL	Stock	20.9996	21.0811	20.9561	20.9587	19743192.0

> showing 50 of 365,678 rows — these rows as CSV

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