PREVIEW / stock_5min / 2014-03-06

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-03-06.parquet
  size:    5.5 MB
  rows:    364,974
  symbols: 3,525

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-06 04:25:00	AAPL	Stock	19.0525	19.0532	19.0525	19.0532	14000.0
2014-03-06 06:20:00	AAPL	Stock	19.0407	19.0407	19.0407	19.0407	5600.0
2014-03-06 06:50:00	AAPL	Stock	19.0357	19.0357	19.0357	19.0357	5600.0
2014-03-06 07:00:00	AAPL	Stock	19.0321	19.0357	19.0321	19.0357	33600.0
2014-03-06 07:10:00	AAPL	Stock	19.0443	19.0443	19.0443	19.0443	11200.0
2014-03-06 07:20:00	AAPL	Stock	19.0396	19.0396	19.0357	19.0396	13580.0
2014-03-06 07:35:00	AAPL	Stock	19.0393	19.0393	19.0286	19.0361	43960.0
2014-03-06 07:40:00	AAPL	Stock	19.0375	19.0375	19.0375	19.0375	2800.0
2014-03-06 08:00:00	AAPL	Stock	19.0357	19.0529	19.0257	19.0357	84868.0
2014-03-06 08:05:00	AAPL	Stock	19.0357	19.0525	19.0357	19.0464	106372.0
2014-03-06 08:10:00	AAPL	Stock	19.0489	19.0521	19.0429	19.0518	33600.0
2014-03-06 08:15:00	AAPL	Stock	19.05	19.05	19.0421	19.0432	15400.0
2014-03-06 08:20:00	AAPL	Stock	19.04	19.0421	19.0393	19.0393	15400.0
2014-03-06 08:25:00	AAPL	Stock	19.0407	19.0518	19.0393	19.045	28000.0
2014-03-06 08:30:00	AAPL	Stock	19.05	19.0521	19.045	19.045	22400.0
2014-03-06 08:35:00	AAPL	Stock	19.0464	19.0514	19.0418	19.0418	81396.0
2014-03-06 08:40:00	AAPL	Stock	19.0454	19.0496	19.0446	19.0446	17332.0
2014-03-06 08:45:00	AAPL	Stock	19.0489	19.05	19.0446	19.0464	42280.0
2014-03-06 08:55:00	AAPL	Stock	19.0443	19.0464	19.0439	19.0464	12152.0
2014-03-06 09:00:00	AAPL	Stock	19.0429	19.0464	19.0418	19.0446	150248.0
2014-03-06 09:05:00	AAPL	Stock	19.0475	19.0475	19.0457	19.0457	5600.0
2014-03-06 09:10:00	AAPL	Stock	19.0421	19.05	19.0421	19.05	69860.0
2014-03-06 09:15:00	AAPL	Stock	19.0482	19.0493	19.0457	19.0493	100800.0
2014-03-06 09:20:00	AAPL	Stock	19.0429	19.0432	19.0357	19.0357	113176.0
2014-03-06 09:25:00	AAPL	Stock	19.0357	19.0357	19.0257	19.0286	53900.0
2014-03-06 09:30:00	AAPL	Stock	19.02	19.0871	19.02	19.0446	7253316.0
2014-03-06 09:35:00	AAPL	Stock	19.045	19.0693	19.0232	19.0346	4384688.0
2014-03-06 09:40:00	AAPL	Stock	19.0346	19.0493	19.0268	19.0471	2294404.0
2014-03-06 09:45:00	AAPL	Stock	19.0468	19.0664	19.0096	19.0132	4398072.0
2014-03-06 09:50:00	AAPL	Stock	19.0157	19.0218	18.9764	18.9954	4972968.0
2014-03-06 09:55:00	AAPL	Stock	18.9968	19.0064	18.9643	18.9679	3203928.0
2014-03-06 10:00:00	AAPL	Stock	18.9679	19.0	18.9546	18.9929	3184384.0
2014-03-06 10:05:00	AAPL	Stock	18.9896	19.0082	18.9857	18.9961	2126712.0
2014-03-06 10:10:00	AAPL	Stock	18.9957	18.9968	18.9643	18.9787	1735272.0
2014-03-06 10:15:00	AAPL	Stock	18.9764	18.9925	18.9681	18.9796	1758568.0
2014-03-06 10:20:00	AAPL	Stock	18.9786	19.0161	18.9768	19.0032	2073484.0
2014-03-06 10:25:00	AAPL	Stock	19.0104	19.0357	19.0	19.0357	2224796.0
2014-03-06 10:30:00	AAPL	Stock	19.0354	19.0493	19.0196	19.0471	1747480.0
2014-03-06 10:35:00	AAPL	Stock	19.0457	19.0593	19.0275	19.0393	2156252.0
2014-03-06 10:40:00	AAPL	Stock	19.0404	19.0439	18.9954	18.9997	1748488.0
2014-03-06 10:45:00	AAPL	Stock	19.0004	19.0071	18.9961	19.0029	1103256.0
2014-03-06 10:50:00	AAPL	Stock	19.0037	19.0179	18.9982	19.0014	1707776.0
2014-03-06 10:55:00	AAPL	Stock	19.0079	19.0132	18.9871	19.0132	1137220.0
2014-03-06 11:00:00	AAPL	Stock	19.0125	19.0211	18.9946	18.9957	1429232.0
2014-03-06 11:05:00	AAPL	Stock	18.9977	19.0157	18.995	19.0086	988316.0
2014-03-06 11:10:00	AAPL	Stock	19.0104	19.0139	19.0014	19.0096	569240.0
2014-03-06 11:15:00	AAPL	Stock	19.0114	19.0282	19.0023	19.0171	1454628.0
2014-03-06 11:20:00	AAPL	Stock	19.0179	19.0257	19.0168	19.0207	754348.0
2014-03-06 11:25:00	AAPL	Stock	19.0221	19.0243	19.0039	19.0154	1024044.0
2014-03-06 11:30:00	AAPL	Stock	19.0093	19.0154	19.0	19.0051	940548.0

> showing 50 of 364,974 rows — these rows as CSV

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