PREVIEW / stock_5min / 2013-02-27

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-02-27.parquet
  size:    4.9 MB
  rows:    327,909
  symbols: 3,487

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-02-27 05:45:00	AAPL	Stock	15.9768	15.9768	15.9768	15.9768	8400.0
2013-02-27 06:00:00	AAPL	Stock	15.9886	15.9886	15.9886	15.9886	11200.0
2013-02-27 06:30:00	AAPL	Stock	16.0	16.0	16.0	16.0	14280.0
2013-02-27 06:35:00	AAPL	Stock	16.0	16.0	16.0	16.0	12320.0
2013-02-27 06:50:00	AAPL	Stock	16.0	16.0	16.0	16.0	22960.0
2013-02-27 07:00:00	AAPL	Stock	15.9821	15.9946	15.9821	15.9929	23800.0
2013-02-27 07:05:00	AAPL	Stock	15.9975	15.9975	15.9975	15.9975	2800.0
2013-02-27 07:10:00	AAPL	Stock	15.9975	16.0089	15.9975	16.0089	27860.0
2013-02-27 07:15:00	AAPL	Stock	16.0143	16.0232	16.0143	16.0214	30800.0
2013-02-27 07:20:00	AAPL	Stock	16.0114	16.0114	16.0	16.0	101220.0
2013-02-27 07:25:00	AAPL	Stock	15.9979	16.0	15.9979	16.0	5600.0
2013-02-27 07:30:00	AAPL	Stock	16.0064	16.0064	15.9821	15.9989	81200.0
2013-02-27 07:35:00	AAPL	Stock	15.9661	15.9821	15.9657	15.9821	102760.0
2013-02-27 07:40:00	AAPL	Stock	15.9814	15.9821	15.9814	15.9821	20300.0
2013-02-27 07:45:00	AAPL	Stock	15.9821	15.9821	15.9725	15.9732	11200.0
2013-02-27 07:50:00	AAPL	Stock	15.9811	15.9979	15.9811	15.9821	112476.0
2013-02-27 07:55:00	AAPL	Stock	15.995	15.9968	15.975	15.975	82852.0
2013-02-27 08:00:00	AAPL	Stock	15.9929	16.0179	15.9607	15.9696	357924.0
2013-02-27 08:05:00	AAPL	Stock	15.9643	15.9654	15.9546	15.9643	160776.0
2013-02-27 08:10:00	AAPL	Stock	15.9768	15.9782	15.9768	15.9775	30800.0
2013-02-27 08:15:00	AAPL	Stock	15.9761	15.9957	15.9761	15.9871	82096.0
2013-02-27 08:20:00	AAPL	Stock	15.9857	15.9954	15.9818	15.9818	133728.0
2013-02-27 08:25:00	AAPL	Stock	15.9818	15.9821	15.9643	15.9796	209944.0
2013-02-27 08:30:00	AAPL	Stock	15.9718	15.9832	15.9571	15.9736	58716.0
2013-02-27 08:35:00	AAPL	Stock	15.9814	15.9821	15.9611	15.9761	120568.0
2013-02-27 08:40:00	AAPL	Stock	15.9779	15.9782	15.9614	15.9714	42840.0
2013-02-27 08:45:00	AAPL	Stock	15.9789	15.9821	15.9714	15.975	32200.0
2013-02-27 08:50:00	AAPL	Stock	15.9732	15.9804	15.9732	15.9804	22400.0
2013-02-27 08:55:00	AAPL	Stock	15.9768	15.9818	15.965	15.9711	33040.0
2013-02-27 09:00:00	AAPL	Stock	15.9668	15.9964	15.9668	15.9964	150360.0
2013-02-27 09:05:00	AAPL	Stock	15.9889	15.9996	15.9732	15.9996	212352.0
2013-02-27 09:10:00	AAPL	Stock	15.9989	16.0357	15.9989	16.0357	595924.0
2013-02-27 09:15:00	AAPL	Stock	16.0364	16.0393	16.0182	16.0182	179200.0
2013-02-27 09:20:00	AAPL	Stock	16.0118	16.0118	16.0	16.0	152656.0
2013-02-27 09:25:00	AAPL	Stock	16.0054	16.0321	16.0004	16.0321	473480.0
2013-02-27 09:30:00	AAPL	Stock	16.0221	16.0346	15.9382	16.0	16762816.0
2013-02-27 09:35:00	AAPL	Stock	15.9993	16.0121	15.9129	15.9179	9768024.0
2013-02-27 09:40:00	AAPL	Stock	15.9168	15.9342	15.875	15.9	10148348.0
2013-02-27 09:45:00	AAPL	Stock	15.9014	15.9343	15.8518	15.8743	8671544.0
2013-02-27 09:50:00	AAPL	Stock	15.8771	15.9432	15.8689	15.92	6617212.0
2013-02-27 09:55:00	AAPL	Stock	15.9249	15.9286	15.8964	15.9043	3616004.0
2013-02-27 10:00:00	AAPL	Stock	15.9075	15.9375	15.87	15.8957	4880456.0
2013-02-27 10:05:00	AAPL	Stock	15.8893	15.895	15.8414	15.855	4763360.0
2013-02-27 10:10:00	AAPL	Stock	15.8539	15.88	15.85	15.8682	4636940.0
2013-02-27 10:15:00	AAPL	Stock	15.8732	15.9082	15.868	15.8929	3833816.0
2013-02-27 10:20:00	AAPL	Stock	15.8929	15.9996	15.879	15.9839	11450684.0
2013-02-27 10:25:00	AAPL	Stock	15.9818	15.9846	15.9482	15.9582	4997608.0
2013-02-27 10:30:00	AAPL	Stock	15.9636	15.9642	15.9143	15.9211	4811296.0
2013-02-27 10:35:00	AAPL	Stock	15.9214	15.9479	15.9021	15.9264	4302872.0
2013-02-27 10:40:00	AAPL	Stock	15.93	15.9821	15.9275	15.9431	5561808.0

> showing 50 of 327,909 rows — these rows as CSV

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