PREVIEW / stock_5min / 2012-02-17

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-02-17.parquet
  size:    4.8 MB
  rows:    323,958
  symbols: 3,561

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
2012-02-17 04:00:00	AAPL	Stock	18.0443	18.0789	18.0443	18.0714	32200.0
2012-02-17 04:05:00	AAPL	Stock	18.0893	18.0893	18.0893	18.0893	4200.0
2012-02-17 04:10:00	AAPL	Stock	18.1064	18.1068	18.1064	18.1068	8400.0
2012-02-17 04:20:00	AAPL	Stock	18.1068	18.1068	18.0939	18.1025	19600.0
2012-02-17 04:30:00	AAPL	Stock	18.0857	18.0857	18.0714	18.0714	30800.0
2012-02-17 04:35:00	AAPL	Stock	18.0914	18.1071	18.0857	18.0893	49000.0
2012-02-17 04:40:00	AAPL	Stock	18.0893	18.0893	18.0893	18.0893	21000.0
2012-02-17 04:45:00	AAPL	Stock	18.0779	18.0779	18.0732	18.0732	8400.0
2012-02-17 04:50:00	AAPL	Stock	18.0729	18.0811	18.0661	18.0696	48160.0
2012-02-17 04:55:00	AAPL	Stock	18.0643	18.0643	18.0518	18.0518	37660.0
2012-02-17 05:00:00	AAPL	Stock	18.0604	18.0604	18.0561	18.0561	11200.0
2012-02-17 05:05:00	AAPL	Stock	18.0589	18.0589	18.0589	18.0589	5600.0
2012-02-17 05:10:00	AAPL	Stock	18.0571	18.0571	18.0464	18.0464	18200.0
2012-02-17 05:15:00	AAPL	Stock	18.0436	18.0436	18.035	18.035	24164.0
2012-02-17 05:20:00	AAPL	Stock	18.0396	18.0396	18.0243	18.0243	8400.0
2012-02-17 05:25:00	AAPL	Stock	18.0204	18.0204	18.0204	18.0204	16800.0
2012-02-17 05:45:00	AAPL	Stock	18.0275	18.0275	18.0275	18.0275	9800.0
2012-02-17 05:50:00	AAPL	Stock	18.0239	18.0268	18.0239	18.0268	5600.0
2012-02-17 05:55:00	AAPL	Stock	18.0268	18.0268	18.0268	18.0268	2800.0
2012-02-17 06:00:00	AAPL	Stock	18.0357	18.0357	18.0357	18.0357	5600.0
2012-02-17 06:05:00	AAPL	Stock	18.0446	18.0446	18.0446	18.0446	2800.0
2012-02-17 06:10:00	AAPL	Stock	18.0357	18.0357	18.0357	18.0357	14000.0
2012-02-17 06:15:00	AAPL	Stock	18.0446	18.0446	18.0446	18.0446	5600.0
2012-02-17 06:40:00	AAPL	Stock	18.0393	18.0393	18.0393	18.0393	9660.0
2012-02-17 06:45:00	AAPL	Stock	18.0357	18.0357	18.0357	18.0357	19600.0
2012-02-17 06:50:00	AAPL	Stock	18.0357	18.0357	18.0357	18.0357	25200.0
2012-02-17 06:55:00	AAPL	Stock	18.0268	18.0268	18.0268	18.0268	14000.0
2012-02-17 07:00:00	AAPL	Stock	18.0179	18.0214	18.0	18.0	82880.0
2012-02-17 07:05:00	AAPL	Stock	17.9875	18.0057	17.9875	18.0057	14000.0
2012-02-17 07:10:00	AAPL	Stock	18.0132	18.0346	18.0121	18.0336	41580.0
2012-02-17 07:15:00	AAPL	Stock	18.0336	18.0336	18.0143	18.0321	73920.0
2012-02-17 07:20:00	AAPL	Stock	18.0332	18.0446	18.0286	18.0446	84000.0
2012-02-17 07:25:00	AAPL	Stock	18.0443	18.05	18.0357	18.0411	97328.0
2012-02-17 07:30:00	AAPL	Stock	18.0386	18.05	18.0357	18.0357	144200.0
2012-02-17 07:35:00	AAPL	Stock	18.0357	18.0357	18.0143	18.0161	97720.0
2012-02-17 07:40:00	AAPL	Stock	18.0054	18.0168	18.0029	18.0089	47600.0
2012-02-17 07:45:00	AAPL	Stock	18.0157	18.0268	18.0157	18.0268	25200.0
2012-02-17 07:50:00	AAPL	Stock	18.0339	18.0339	18.0182	18.0182	14000.0
2012-02-17 07:55:00	AAPL	Stock	18.0161	18.0207	18.0161	18.0186	14000.0
2012-02-17 08:00:00	AAPL	Stock	18.0232	18.0468	18.0	18.01	418824.0
2012-02-17 08:05:00	AAPL	Stock	18.0139	18.0139	18.0014	18.0021	165760.0
2012-02-17 08:10:00	AAPL	Stock	18.0064	18.0071	17.9643	17.9893	375396.0
2012-02-17 08:15:00	AAPL	Stock	17.9839	17.9896	17.9679	17.9786	152460.0
2012-02-17 08:20:00	AAPL	Stock	17.975	17.9854	17.9732	17.9854	100604.0
2012-02-17 08:25:00	AAPL	Stock	17.9879	18.0089	17.9821	18.0029	209720.0
2012-02-17 08:30:00	AAPL	Stock	18.0032	18.0054	17.9893	17.9964	148484.0
2012-02-17 08:35:00	AAPL	Stock	17.9946	17.9968	17.9786	17.9789	119784.0
2012-02-17 08:40:00	AAPL	Stock	17.985	18.0089	17.9839	18.0089	195468.0
2012-02-17 08:45:00	AAPL	Stock	18.0071	18.0154	17.9946	17.9954	582344.0
2012-02-17 08:50:00	AAPL	Stock	18.0046	18.0104	17.9868	17.9964	285404.0

> showing 50 of 323,958 rows — these rows as CSV

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