PREVIEW / stock_5min / 2012-09-13

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-09-13.parquet
  size:    5.0 MB
  rows:    330,221
  symbols: 3,488

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-09-13 04:05:00	AAPL	Stock	23.9161	23.9161	23.8932	23.8932	18760.0
2012-09-13 04:20:00	AAPL	Stock	23.9107	23.9107	23.9107	23.9107	2800.0
2012-09-13 04:25:00	AAPL	Stock	23.9286	23.9289	23.9286	23.9289	5600.0
2012-09-13 04:40:00	AAPL	Stock	23.9286	23.9464	23.9286	23.9464	16268.0
2012-09-13 04:45:00	AAPL	Stock	23.9464	23.9464	23.9464	23.9464	11200.0
2012-09-13 04:50:00	AAPL	Stock	23.9464	23.9643	23.9464	23.9643	98000.0
2012-09-13 04:55:00	AAPL	Stock	23.9646	23.9646	23.9646	23.9646	2800.0
2012-09-13 05:00:00	AAPL	Stock	23.9679	23.9679	23.9679	23.9679	5600.0
2012-09-13 05:10:00	AAPL	Stock	23.9721	23.9811	23.9721	23.9811	5600.0
2012-09-13 05:15:00	AAPL	Stock	23.9911	23.9911	23.9911	23.9911	2800.0
2012-09-13 05:20:00	AAPL	Stock	24.0	24.0	24.0	24.0	5600.0
2012-09-13 05:25:00	AAPL	Stock	23.9825	23.9825	23.9821	23.9821	5600.0
2012-09-13 05:35:00	AAPL	Stock	24.0	24.0	23.9821	23.9821	12180.0
2012-09-13 05:40:00	AAPL	Stock	23.9821	23.9821	23.9821	23.9821	2800.0
2012-09-13 05:45:00	AAPL	Stock	23.9857	24.0	23.9857	24.0	11200.0
2012-09-13 05:50:00	AAPL	Stock	24.0	24.0143	24.0	24.0143	19600.0
2012-09-13 05:55:00	AAPL	Stock	24.0	24.0	24.0	24.0	5600.0
2012-09-13 06:00:00	AAPL	Stock	23.9857	23.9996	23.9821	23.9821	31780.0
2012-09-13 06:05:00	AAPL	Stock	23.9996	23.9996	23.9996	23.9996	2800.0
2012-09-13 06:10:00	AAPL	Stock	23.9982	23.9996	23.9982	23.9996	11200.0
2012-09-13 06:15:00	AAPL	Stock	23.9996	23.9996	23.9996	23.9996	2800.0
2012-09-13 06:35:00	AAPL	Stock	24.0143	24.0143	24.0143	24.0143	5600.0
2012-09-13 06:40:00	AAPL	Stock	24.0143	24.0143	24.0143	24.0143	14000.0
2012-09-13 06:50:00	AAPL	Stock	24.0232	24.0232	24.0146	24.0146	19600.0
2012-09-13 06:55:00	AAPL	Stock	24.0079	24.0079	23.9907	23.9907	25200.0
2012-09-13 07:00:00	AAPL	Stock	23.9875	24.0143	23.9875	24.0143	25704.0
2012-09-13 07:05:00	AAPL	Stock	24.0171	24.0339	24.0096	24.0296	182000.0
2012-09-13 07:10:00	AAPL	Stock	24.0111	24.0346	24.0043	24.0346	111076.0
2012-09-13 07:15:00	AAPL	Stock	24.0393	24.0664	24.0393	24.0536	236824.0
2012-09-13 07:20:00	AAPL	Stock	24.0432	24.065	24.0429	24.0543	199808.0
2012-09-13 07:25:00	AAPL	Stock	24.0571	24.0779	24.0536	24.0779	224840.0
2012-09-13 07:30:00	AAPL	Stock	24.0714	24.0893	24.0714	24.0804	521444.0
2012-09-13 07:35:00	AAPL	Stock	24.0854	24.0964	24.0804	24.0932	130172.0
2012-09-13 07:40:00	AAPL	Stock	24.0964	24.1061	24.0804	24.0982	372652.0
2012-09-13 07:45:00	AAPL	Stock	24.0961	24.1286	24.0961	24.1282	378504.0
2012-09-13 07:50:00	AAPL	Stock	24.1286	24.1286	24.0893	24.09	722736.0
2012-09-13 07:55:00	AAPL	Stock	24.0907	24.0989	24.0893	24.0893	107100.0
2012-09-13 08:00:00	AAPL	Stock	24.0982	24.13	24.0	24.1164	1008728.0
2012-09-13 08:05:00	AAPL	Stock	24.1168	24.1282	24.0986	24.1282	384104.0
2012-09-13 08:10:00	AAPL	Stock	24.125	24.1321	24.1071	24.1114	627760.0
2012-09-13 08:15:00	AAPL	Stock	24.1171	24.1175	24.0893	24.1007	378756.0
2012-09-13 08:20:00	AAPL	Stock	24.1007	24.1143	24.0982	24.1143	417004.0
2012-09-13 08:25:00	AAPL	Stock	24.1125	24.1129	24.0621	24.0875	611128.0
2012-09-13 08:30:00	AAPL	Stock	24.0846	24.0989	24.0811	24.0929	452172.0
2012-09-13 08:35:00	AAPL	Stock	24.0893	24.0982	24.0893	24.0979	189700.0
2012-09-13 08:40:00	AAPL	Stock	24.0939	24.0957	24.0714	24.0768	569044.0
2012-09-13 08:45:00	AAPL	Stock	24.0754	24.0889	24.0714	24.0889	187600.0
2012-09-13 08:50:00	AAPL	Stock	24.0857	24.0968	24.0796	24.0943	253792.0
2012-09-13 08:55:00	AAPL	Stock	24.1014	24.1179	24.0893	24.1093	813036.0
2012-09-13 09:00:00	AAPL	Stock	24.1071	24.1236	24.0982	24.1236	454916.0

> showing 50 of 330,221 rows — these rows as CSV

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