PREVIEW / stock_5min / 2014-03-21

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-03-21.parquet
  size:    5.7 MB
  rows:    375,870
  symbols: 3,551

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-21 05:00:00	AAPL	Stock	18.9286	18.9286	18.8821	18.8821	13160.0
2014-03-21 05:05:00	AAPL	Stock	18.9182	18.9182	18.9182	18.9182	14000.0
2014-03-21 05:10:00	AAPL	Stock	18.8843	18.8843	18.8339	18.8339	30800.0
2014-03-21 06:30:00	AAPL	Stock	18.9171	18.9171	18.9171	18.9171	2800.0
2014-03-21 06:55:00	AAPL	Stock	18.9271	18.9271	18.9271	18.9271	2800.0
2014-03-21 07:05:00	AAPL	Stock	18.9246	18.9264	18.9246	18.9264	8400.0
2014-03-21 07:10:00	AAPL	Stock	18.9264	18.9411	18.9264	18.9411	47600.0
2014-03-21 07:15:00	AAPL	Stock	18.9507	18.9571	18.9507	18.9571	16800.0
2014-03-21 07:20:00	AAPL	Stock	18.9582	18.9582	18.9582	18.9582	5600.0
2014-03-21 07:25:00	AAPL	Stock	18.9571	18.9643	18.9571	18.9643	15400.0
2014-03-21 07:30:00	AAPL	Stock	18.9571	18.9571	18.9554	18.9554	50400.0
2014-03-21 07:35:00	AAPL	Stock	18.9604	18.9604	18.9604	18.9604	2800.0
2014-03-21 07:40:00	AAPL	Stock	18.9464	18.9464	18.9429	18.9429	33600.0
2014-03-21 07:50:00	AAPL	Stock	18.9375	18.9375	18.9257	18.9279	27888.0
2014-03-21 07:55:00	AAPL	Stock	18.9089	18.9268	18.9089	18.9268	7700.0
2014-03-21 08:00:00	AAPL	Stock	18.9279	18.9286	18.9246	18.9286	36260.0
2014-03-21 08:05:00	AAPL	Stock	18.9286	18.9286	18.9282	18.9282	5600.0
2014-03-21 08:10:00	AAPL	Stock	18.9171	18.9171	18.9171	18.9171	4480.0
2014-03-21 08:20:00	AAPL	Stock	18.9264	18.9289	18.9264	18.9286	91280.0
2014-03-21 08:25:00	AAPL	Stock	18.9196	18.9321	18.9179	18.9321	64400.0
2014-03-21 08:30:00	AAPL	Stock	18.9318	18.9357	18.9293	18.9293	25200.0
2014-03-21 08:35:00	AAPL	Stock	18.9286	18.9375	18.9286	18.9286	87304.0
2014-03-21 08:40:00	AAPL	Stock	18.9321	18.9339	18.9118	18.9125	74004.0
2014-03-21 08:50:00	AAPL	Stock	18.925	18.9393	18.925	18.9375	83020.0
2014-03-21 08:55:00	AAPL	Stock	18.9207	18.9221	18.9207	18.9211	28000.0
2014-03-21 09:00:00	AAPL	Stock	18.9282	18.9282	18.9282	18.9282	2800.0
2014-03-21 09:05:00	AAPL	Stock	18.9286	18.9339	18.9282	18.9339	40600.0
2014-03-21 09:15:00	AAPL	Stock	18.9286	18.9375	18.9286	18.9339	8400.0
2014-03-21 09:20:00	AAPL	Stock	18.9371	18.9375	18.9286	18.9357	94948.0
2014-03-21 09:25:00	AAPL	Stock	18.9375	19.1129	18.9229	19.0193	4355540.0
2014-03-21 09:30:00	AAPL	Stock	18.9925	19.0625	18.9214	18.9618	57424360.0
2014-03-21 09:35:00	AAPL	Stock	18.9657	18.9761	18.9329	18.9596	5805940.0
2014-03-21 09:40:00	AAPL	Stock	18.9625	18.9886	18.9414	18.9474	4465048.0
2014-03-21 09:45:00	AAPL	Stock	18.9475	18.9707	18.9475	18.9504	2501380.0
2014-03-21 09:50:00	AAPL	Stock	18.95	18.9525	18.9036	18.9211	3438988.0
2014-03-21 09:55:00	AAPL	Stock	18.9196	18.9282	18.8971	18.8986	2384760.0
2014-03-21 10:00:00	AAPL	Stock	18.8987	18.9182	18.8986	18.9077	2216760.0
2014-03-21 10:05:00	AAPL	Stock	18.91	18.9129	18.8729	18.8896	3224788.0
2014-03-21 10:10:00	AAPL	Stock	18.8857	18.9064	18.8696	18.9064	3331496.0
2014-03-21 10:15:00	AAPL	Stock	18.9071	18.9071	18.8754	18.88	2935016.0
2014-03-21 10:20:00	AAPL	Stock	18.8775	18.9054	18.875	18.8857	2764160.0
2014-03-21 10:25:00	AAPL	Stock	18.8893	18.8893	18.8482	18.8804	3863020.0
2014-03-21 10:30:00	AAPL	Stock	18.8804	18.9	18.8543	18.8957	2631160.0
2014-03-21 10:35:00	AAPL	Stock	18.8943	18.9	18.8586	18.8696	1639932.0
2014-03-21 10:40:00	AAPL	Stock	18.8709	18.8957	18.87	18.8857	1276912.0
2014-03-21 10:45:00	AAPL	Stock	18.8825	18.9064	18.8796	18.8993	1762040.0
2014-03-21 10:50:00	AAPL	Stock	18.9	18.9164	18.8946	18.9089	2420656.0
2014-03-21 10:55:00	AAPL	Stock	18.9105	18.9196	18.9054	18.9125	1449000.0
2014-03-21 11:00:00	AAPL	Stock	18.9132	18.925	18.9129	18.915	1039920.0
2014-03-21 11:05:00	AAPL	Stock	18.9132	18.9179	18.8955	18.9107	1509620.0

> showing 50 of 375,870 rows — these rows as CSV

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