PREVIEW / stock_5min / 2013-10-25

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-10-25.parquet
  size:    5.2 MB
  rows:    342,326
  symbols: 3,544

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
2013-10-25 04:05:00	AAPL	Stock	19.0	19.01	19.0	19.0036	28000.0
2013-10-25 04:10:00	AAPL	Stock	19.0036	19.0036	19.0036	19.0036	5600.0
2013-10-25 04:15:00	AAPL	Stock	18.9929	18.9929	18.9871	18.9871	11200.0
2013-10-25 04:25:00	AAPL	Stock	18.9571	18.9571	18.9571	18.9571	2800.0
2013-10-25 04:30:00	AAPL	Stock	18.975	18.975	18.9461	18.9461	11200.0
2013-10-25 04:35:00	AAPL	Stock	18.9429	18.9429	18.9429	18.9429	23744.0
2013-10-25 04:45:00	AAPL	Stock	18.9796	18.9796	18.9796	18.9796	2800.0
2013-10-25 04:50:00	AAPL	Stock	18.9821	18.9821	18.9821	18.9821	8400.0
2013-10-25 05:05:00	AAPL	Stock	18.9943	19.0	18.9943	19.0	9520.0
2013-10-25 05:10:00	AAPL	Stock	18.9993	19.0	18.9993	19.0	39200.0
2013-10-25 05:15:00	AAPL	Stock	19.0	19.0	19.0	19.0	16800.0
2013-10-25 05:30:00	AAPL	Stock	18.9821	18.9821	18.9821	18.9821	14000.0
2013-10-25 05:35:00	AAPL	Stock	19.0	19.0	19.0	19.0	5600.0
2013-10-25 05:40:00	AAPL	Stock	19.0107	19.0107	19.0107	19.0107	8400.0
2013-10-25 05:50:00	AAPL	Stock	19.0164	19.0207	19.0164	19.0196	24640.0
2013-10-25 05:55:00	AAPL	Stock	19.0057	19.0057	19.0	19.0	27244.0
2013-10-25 06:00:00	AAPL	Stock	19.0161	19.0196	19.0089	19.0196	12572.0
2013-10-25 06:05:00	AAPL	Stock	19.0246	19.0246	19.0179	19.0179	25200.0
2013-10-25 06:10:00	AAPL	Stock	19.0004	19.0004	19.0	19.0	39956.0
2013-10-25 06:20:00	AAPL	Stock	19.0	19.0	19.0	19.0	2800.0
2013-10-25 06:25:00	AAPL	Stock	18.99	19.0	18.9854	18.9854	19600.0
2013-10-25 06:30:00	AAPL	Stock	18.9854	18.9854	18.9854	18.9854	10500.0
2013-10-25 06:40:00	AAPL	Stock	19.0	19.0	19.0	19.0	6440.0
2013-10-25 06:45:00	AAPL	Stock	19.0236	19.0236	19.0236	19.0236	2800.0
2013-10-25 06:50:00	AAPL	Stock	19.0054	19.0054	19.0054	19.0054	2800.0
2013-10-25 07:00:00	AAPL	Stock	19.0107	19.0421	19.0107	19.0421	21896.0
2013-10-25 07:05:00	AAPL	Stock	19.0357	19.0711	19.0304	19.0625	106260.0
2013-10-25 07:10:00	AAPL	Stock	19.0632	19.0632	19.0268	19.0321	214088.0
2013-10-25 07:15:00	AAPL	Stock	19.0357	19.0357	19.0268	19.0357	103740.0
2013-10-25 07:20:00	AAPL	Stock	19.0421	19.0482	19.0421	19.0482	28000.0
2013-10-25 07:25:00	AAPL	Stock	19.0446	19.05	19.0357	19.0357	60760.0
2013-10-25 07:30:00	AAPL	Stock	19.0221	19.0518	19.0221	19.0357	165340.0
2013-10-25 07:35:00	AAPL	Stock	19.0357	19.0514	19.0293	19.0514	42000.0
2013-10-25 07:40:00	AAPL	Stock	19.05	19.05	19.0171	19.025	210028.0
2013-10-25 07:45:00	AAPL	Stock	19.025	19.025	19.0246	19.0246	15680.0
2013-10-25 07:50:00	AAPL	Stock	19.01	19.01	18.9929	19.0054	78988.0
2013-10-25 07:55:00	AAPL	Stock	19.0136	19.0164	18.9986	19.0164	76468.0
2013-10-25 08:00:00	AAPL	Stock	19.0161	19.0625	18.9643	18.9875	438452.0
2013-10-25 08:05:00	AAPL	Stock	18.9986	19.0136	18.9911	19.0132	130760.0
2013-10-25 08:10:00	AAPL	Stock	19.0132	19.0132	18.9789	18.9789	195300.0
2013-10-25 08:15:00	AAPL	Stock	18.9804	18.9804	18.9432	18.9464	354704.0
2013-10-25 08:20:00	AAPL	Stock	18.9639	18.9732	18.9521	18.9643	146384.0
2013-10-25 08:25:00	AAPL	Stock	18.9668	18.9793	18.955	18.9679	166376.0
2013-10-25 08:30:00	AAPL	Stock	18.9768	18.9821	18.9696	18.9821	77504.0
2013-10-25 08:35:00	AAPL	Stock	18.9714	18.9993	18.9696	18.9821	114324.0
2013-10-25 08:40:00	AAPL	Stock	18.9804	18.9821	18.9804	18.9821	10920.0
2013-10-25 08:45:00	AAPL	Stock	18.9914	18.9914	18.9696	18.9696	39760.0
2013-10-25 08:50:00	AAPL	Stock	18.9729	18.9804	18.9682	18.9754	75040.0
2013-10-25 08:55:00	AAPL	Stock	18.9732	18.9936	18.9714	18.9936	144956.0
2013-10-25 09:00:00	AAPL	Stock	18.9982	19.0	18.99	18.9996	82880.0

> showing 50 of 342,326 rows — these rows as CSV

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