PREVIEW / stock_5min / 2011-07-28

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-07-28.parquet
  size:    4.9 MB
  rows:    329,812
  symbols: 3,528

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
2011-07-28 04:00:00	AAPL	Stock	13.9682	13.9682	13.9682	13.9682	7000.0
2011-07-28 04:45:00	AAPL	Stock	14.0518	14.0518	14.0518	14.0518	2800.0
2011-07-28 04:50:00	AAPL	Stock	14.0539	14.0543	14.0539	14.0543	5600.0
2011-07-28 05:00:00	AAPL	Stock	14.025	14.025	14.025	14.025	2800.0
2011-07-28 05:05:00	AAPL	Stock	14.0354	14.0354	14.0354	14.0354	2800.0
2011-07-28 05:15:00	AAPL	Stock	14.0179	14.0179	14.0179	14.0179	2800.0
2011-07-28 05:20:00	AAPL	Stock	14.0175	14.0175	14.0086	14.0086	14000.0
2011-07-28 05:25:00	AAPL	Stock	14.0146	14.0146	14.0146	14.0146	2800.0
2011-07-28 05:45:00	AAPL	Stock	13.9871	13.9871	13.9839	13.9839	11200.0
2011-07-28 05:50:00	AAPL	Stock	13.9871	13.9871	13.9839	13.9839	8400.0
2011-07-28 05:55:00	AAPL	Stock	13.9925	13.9925	13.9839	13.9839	11200.0
2011-07-28 06:00:00	AAPL	Stock	13.99	13.99	13.99	13.99	8400.0
2011-07-28 06:10:00	AAPL	Stock	13.99	13.9904	13.9721	13.9721	42000.0
2011-07-28 06:15:00	AAPL	Stock	13.9618	13.9639	13.95	13.9639	35700.0
2011-07-28 06:20:00	AAPL	Stock	13.9639	13.9639	13.9639	13.9639	19600.0
2011-07-28 06:25:00	AAPL	Stock	13.95	13.9643	13.95	13.9643	14000.0
2011-07-28 06:55:00	AAPL	Stock	13.9946	13.9946	13.9946	13.9946	2800.0
2011-07-28 07:00:00	AAPL	Stock	14.0	14.0154	13.9782	14.0089	72772.0
2011-07-28 07:05:00	AAPL	Stock	14.0089	14.0357	14.0089	14.0271	89628.0
2011-07-28 07:10:00	AAPL	Stock	14.0268	14.0396	14.0268	14.0396	23800.0
2011-07-28 07:15:00	AAPL	Stock	14.0396	14.04	13.9982	14.0179	44800.0
2011-07-28 07:20:00	AAPL	Stock	14.0018	14.0179	14.0	14.0129	40880.0
2011-07-28 07:25:00	AAPL	Stock	14.0304	14.0346	14.0036	14.0211	80136.0
2011-07-28 07:30:00	AAPL	Stock	14.0196	14.035	14.0196	14.035	77420.0
2011-07-28 07:35:00	AAPL	Stock	14.0354	14.05	14.0354	14.05	53480.0
2011-07-28 07:40:00	AAPL	Stock	14.0446	14.0446	14.0357	14.0357	19600.0
2011-07-28 07:45:00	AAPL	Stock	14.0357	14.0411	14.0357	14.0357	20440.0
2011-07-28 07:50:00	AAPL	Stock	14.0325	14.0325	14.0232	14.0254	75600.0
2011-07-28 07:55:00	AAPL	Stock	14.0236	14.0236	14.0186	14.0186	22400.0
2011-07-28 08:00:00	AAPL	Stock	14.0232	14.0439	13.9825	14.0	348432.0
2011-07-28 08:05:00	AAPL	Stock	13.9982	14.0164	13.9914	14.0118	141428.0
2011-07-28 08:10:00	AAPL	Stock	14.0118	14.0168	13.9964	14.0011	180152.0
2011-07-28 08:15:00	AAPL	Stock	14.0011	14.0061	13.9696	13.9807	820456.0
2011-07-28 08:20:00	AAPL	Stock	13.9779	13.9879	13.9736	13.9754	335440.0
2011-07-28 08:25:00	AAPL	Stock	13.9786	13.9786	13.9557	13.9586	688968.0
2011-07-28 08:30:00	AAPL	Stock	13.9625	14.0232	13.9625	14.0	918876.0
2011-07-28 08:35:00	AAPL	Stock	13.9957	14.0286	13.9957	14.0179	906808.0
2011-07-28 08:40:00	AAPL	Stock	14.0125	14.045	14.0093	14.0404	704424.0
2011-07-28 08:45:00	AAPL	Stock	14.0443	14.0714	14.0386	14.0636	1064028.0
2011-07-28 08:50:00	AAPL	Stock	14.0636	14.0857	14.0625	14.0718	692412.0
2011-07-28 08:55:00	AAPL	Stock	14.0779	14.0804	14.0554	14.0554	1022252.0
2011-07-28 09:00:00	AAPL	Stock	14.0554	14.0711	14.0357	14.0579	681128.0
2011-07-28 09:05:00	AAPL	Stock	14.0586	14.0661	14.0361	14.05	263760.0
2011-07-28 09:10:00	AAPL	Stock	14.0475	14.0521	14.0454	14.0454	119000.0
2011-07-28 09:15:00	AAPL	Stock	14.0446	14.0464	14.0164	14.0318	274652.0
2011-07-28 09:20:00	AAPL	Stock	14.0318	14.0396	14.0293	14.0396	447972.0
2011-07-28 09:25:00	AAPL	Stock	14.04	14.0539	13.9814	13.9907	922292.0
2011-07-28 09:30:00	AAPL	Stock	13.9864	14.0229	13.8757	13.9032	26155472.0
2011-07-28 09:35:00	AAPL	Stock	13.9018	13.9286	13.8764	13.9021	23550212.0
2011-07-28 09:40:00	AAPL	Stock	13.9	13.9146	13.8618	13.9036	16622928.0

> showing 50 of 329,812 rows — these rows as CSV

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