PREVIEW / stock_5min / 2013-06-20

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-06-20.parquet
  size:    5.5 MB
  rows:    363,038
  symbols: 3,511

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-06-20 04:00:00	AAPL	Stock	15.0875	15.0875	15.0875	15.0875	2800.0
2013-06-20 04:15:00	AAPL	Stock	15.025	15.0254	15.025	15.025	17780.0
2013-06-20 04:20:00	AAPL	Stock	15.025	15.025	15.025	15.025	11200.0
2013-06-20 04:30:00	AAPL	Stock	15.0136	15.0136	15.0136	15.0136	4396.0
2013-06-20 04:35:00	AAPL	Stock	15.0186	15.0186	15.0036	15.0036	15428.0
2013-06-20 04:40:00	AAPL	Stock	14.9986	14.9986	14.9986	14.9986	2800.0
2013-06-20 05:05:00	AAPL	Stock	15.0036	15.0171	15.0036	15.0171	15876.0
2013-06-20 05:20:00	AAPL	Stock	15.0171	15.0171	15.0171	15.0171	5600.0
2013-06-20 05:30:00	AAPL	Stock	15.0171	15.0171	15.0036	15.0036	25732.0
2013-06-20 05:40:00	AAPL	Stock	15.0179	15.0179	15.0179	15.0179	11200.0
2013-06-20 05:45:00	AAPL	Stock	15.0179	15.02	15.0179	15.0179	22400.0
2013-06-20 05:55:00	AAPL	Stock	15.0036	15.0046	15.0036	15.0036	8400.0
2013-06-20 06:05:00	AAPL	Stock	15.0036	15.0036	15.0036	15.0036	2800.0
2013-06-20 06:10:00	AAPL	Stock	14.9975	14.9975	14.9975	14.9975	5600.0
2013-06-20 06:20:00	AAPL	Stock	14.9975	14.9975	14.9975	14.9975	2800.0
2013-06-20 06:30:00	AAPL	Stock	14.9968	14.9975	14.9893	14.9893	30800.0
2013-06-20 06:35:00	AAPL	Stock	14.9732	14.9732	14.9732	14.9732	2800.0
2013-06-20 06:40:00	AAPL	Stock	14.9807	14.9857	14.9807	14.9857	5600.0
2013-06-20 06:50:00	AAPL	Stock	14.9982	15.0	14.9982	15.0	19600.0
2013-06-20 07:00:00	AAPL	Stock	14.9879	14.9879	14.9879	14.9879	8400.0
2013-06-20 07:05:00	AAPL	Stock	14.9961	15.0	14.9807	14.99	110236.0
2013-06-20 07:10:00	AAPL	Stock	14.9946	15.0125	14.9946	15.0036	74480.0
2013-06-20 07:15:00	AAPL	Stock	15.0	15.0086	14.9993	15.0071	19600.0
2013-06-20 07:20:00	AAPL	Stock	15.0071	15.0071	14.995	14.9968	63448.0
2013-06-20 07:25:00	AAPL	Stock	15.0	15.0011	14.9993	15.0	62776.0
2013-06-20 07:30:00	AAPL	Stock	15.0	15.0	14.9896	14.9896	31640.0
2013-06-20 07:35:00	AAPL	Stock	14.9882	14.9893	14.9829	14.9832	55440.0
2013-06-20 07:40:00	AAPL	Stock	14.9907	14.9946	14.9836	14.9864	95564.0
2013-06-20 07:45:00	AAPL	Stock	14.9825	14.9946	14.9804	14.9843	36400.0
2013-06-20 07:50:00	AAPL	Stock	14.99	14.99	14.9754	14.9821	340480.0
2013-06-20 07:55:00	AAPL	Stock	14.9932	14.9971	14.9821	14.9971	55496.0
2013-06-20 08:00:00	AAPL	Stock	14.9996	15.0511	14.9821	15.0357	420728.0
2013-06-20 08:05:00	AAPL	Stock	15.0357	15.0357	15.015	15.0318	71680.0
2013-06-20 08:10:00	AAPL	Stock	15.0321	15.0357	15.025	15.0268	182280.0
2013-06-20 08:15:00	AAPL	Stock	15.0221	15.04	15.0214	15.04	180404.0
2013-06-20 08:20:00	AAPL	Stock	15.0371	15.0536	15.0357	15.0536	132216.0
2013-06-20 08:25:00	AAPL	Stock	15.0614	15.0714	15.0536	15.0643	191576.0
2013-06-20 08:30:00	AAPL	Stock	15.0607	15.0682	15.0486	15.0607	208236.0
2013-06-20 08:35:00	AAPL	Stock	15.0604	15.0604	15.04	15.04	131600.0
2013-06-20 08:40:00	AAPL	Stock	15.0493	15.0539	15.0411	15.0536	56700.0
2013-06-20 08:45:00	AAPL	Stock	15.0539	15.0539	15.0411	15.0411	279356.0
2013-06-20 08:50:00	AAPL	Stock	15.04	15.0414	15.0264	15.0264	267568.0
2013-06-20 08:55:00	AAPL	Stock	15.0264	15.0268	15.0071	15.0136	339136.0
2013-06-20 09:00:00	AAPL	Stock	15.02	15.0268	14.9893	14.9893	688688.0
2013-06-20 09:05:00	AAPL	Stock	14.9929	15.0	14.9679	14.9714	547008.0
2013-06-20 09:10:00	AAPL	Stock	14.9679	14.9875	14.9679	14.9875	158060.0
2013-06-20 09:15:00	AAPL	Stock	14.9904	14.9986	14.9786	14.9879	161056.0
2013-06-20 09:20:00	AAPL	Stock	14.9982	14.9982	14.9821	14.9821	58716.0
2013-06-20 09:25:00	AAPL	Stock	14.9821	14.9893	14.9718	14.9875	582540.0
2013-06-20 09:30:00	AAPL	Stock	14.9736	15.0457	14.9304	15.0436	21248892.0

> showing 50 of 363,038 rows — these rows as CSV

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