PREVIEW / stock_5min / 2013-09-17

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-09-17.parquet
  size:    5.1 MB
  rows:    342,692
  symbols: 3,535

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-09-17 04:00:00	AAPL	Stock	15.8857	15.9739	15.8714	15.8821	52220.0
2013-09-17 04:05:00	AAPL	Stock	15.9221	15.9346	15.9054	15.9336	52192.0
2013-09-17 04:10:00	AAPL	Stock	15.9429	15.9429	15.9286	15.9286	8400.0
2013-09-17 04:20:00	AAPL	Stock	15.9461	15.9461	15.9461	15.9461	11200.0
2013-09-17 04:45:00	AAPL	Stock	15.9443	15.9443	15.9329	15.9329	13720.0
2013-09-17 04:50:00	AAPL	Stock	15.9529	15.9529	15.9529	15.9529	5600.0
2013-09-17 04:55:00	AAPL	Stock	15.9543	15.9679	15.9543	15.9679	5600.0
2013-09-17 05:00:00	AAPL	Stock	15.9679	15.97	15.9564	15.9564	8400.0
2013-09-17 05:05:00	AAPL	Stock	15.9818	15.9821	15.9818	15.9821	5600.0
2013-09-17 05:10:00	AAPL	Stock	15.9718	15.9718	15.9643	15.9643	15680.0
2013-09-17 05:25:00	AAPL	Stock	15.9582	15.9589	15.9582	15.9589	8400.0
2013-09-17 05:40:00	AAPL	Stock	15.95	15.95	15.95	15.95	2800.0
2013-09-17 05:55:00	AAPL	Stock	15.9429	15.9432	15.9429	15.9432	5600.0
2013-09-17 06:00:00	AAPL	Stock	15.9375	15.9375	15.9375	15.9375	2800.0
2013-09-17 06:20:00	AAPL	Stock	15.9368	15.9429	15.9368	15.9429	8400.0
2013-09-17 06:35:00	AAPL	Stock	15.9286	15.9286	15.9282	15.9282	5600.0
2013-09-17 06:50:00	AAPL	Stock	15.9214	15.9218	15.9214	15.9214	8400.0
2013-09-17 06:55:00	AAPL	Stock	15.9068	15.9143	15.9068	15.9143	10640.0
2013-09-17 07:00:00	AAPL	Stock	15.9089	15.9289	15.9089	15.9164	36064.0
2013-09-17 07:05:00	AAPL	Stock	15.9196	15.9275	15.9196	15.9204	35168.0
2013-09-17 07:10:00	AAPL	Stock	15.9232	15.9468	15.9232	15.9339	130396.0
2013-09-17 07:15:00	AAPL	Stock	15.9393	15.9393	15.9332	15.9332	16800.0
2013-09-17 07:20:00	AAPL	Stock	15.9368	15.9443	15.9368	15.9414	40600.0
2013-09-17 07:25:00	AAPL	Stock	15.9529	16.0093	15.9529	15.965	268856.0
2013-09-17 07:30:00	AAPL	Stock	15.9818	15.9843	15.9379	15.9607	195552.0
2013-09-17 07:35:00	AAPL	Stock	15.9629	15.9629	15.9468	15.9468	9044.0
2013-09-17 07:40:00	AAPL	Stock	15.9471	15.9618	15.9464	15.9618	28000.0
2013-09-17 07:45:00	AAPL	Stock	15.9596	15.96	15.9596	15.96	8400.0
2013-09-17 07:50:00	AAPL	Stock	15.9586	15.9586	15.9429	15.9446	97748.0
2013-09-17 07:55:00	AAPL	Stock	15.9446	15.9529	15.9204	15.95	391776.0
2013-09-17 08:00:00	AAPL	Stock	15.9554	15.9814	15.9018	15.97	516936.0
2013-09-17 08:05:00	AAPL	Stock	15.9657	15.9929	15.9643	15.9821	182448.0
2013-09-17 08:10:00	AAPL	Stock	15.9896	16.0171	15.9896	16.0125	226184.0
2013-09-17 08:15:00	AAPL	Stock	16.0125	16.0125	15.9975	15.9982	232960.0
2013-09-17 08:20:00	AAPL	Stock	15.9936	15.9979	15.975	15.9793	215068.0
2013-09-17 08:25:00	AAPL	Stock	15.9843	15.9911	15.9789	15.9846	95872.0
2013-09-17 08:30:00	AAPL	Stock	15.9925	15.9993	15.9857	15.9971	151228.0
2013-09-17 08:35:00	AAPL	Stock	15.9911	15.9964	15.9861	15.9861	47600.0
2013-09-17 08:40:00	AAPL	Stock	15.9857	15.9936	15.9754	15.9857	103544.0
2013-09-17 08:45:00	AAPL	Stock	15.9843	15.9843	15.9643	15.9664	341012.0
2013-09-17 08:50:00	AAPL	Stock	15.9686	15.9714	15.9561	15.9625	260960.0
2013-09-17 08:55:00	AAPL	Stock	15.9632	15.9743	15.9471	15.9671	394576.0
2013-09-17 09:00:00	AAPL	Stock	15.9682	16.0118	15.9682	15.9804	451556.0
2013-09-17 09:05:00	AAPL	Stock	15.98	15.98	15.9643	15.9707	221144.0
2013-09-17 09:10:00	AAPL	Stock	15.9696	15.9714	15.9614	15.9629	283108.0
2013-09-17 09:15:00	AAPL	Stock	15.9654	15.9939	15.9654	15.9857	315700.0
2013-09-17 09:20:00	AAPL	Stock	15.9893	15.9911	15.9757	15.9854	232624.0
2013-09-17 09:25:00	AAPL	Stock	15.9821	16.0429	15.9643	15.9996	2186996.0
2013-09-17 09:30:00	AAPL	Stock	15.9939	16.1417	15.9821	16.1266	30614332.0
2013-09-17 09:35:00	AAPL	Stock	16.1279	16.2068	16.1275	16.1725	18573072.0

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

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