PREVIEW / stock_5min / 2013-01-14

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-01-14.parquet
  size:    4.7 MB
  rows:    321,379
  symbols: 3,469

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-01-14 04:00:00	AAPL	Stock	18.5857	18.5857	18.2093	18.2143	43960.0
2013-01-14 04:05:00	AAPL	Stock	18.2143	18.2229	18.2143	18.2186	14000.0
2013-01-14 04:10:00	AAPL	Stock	18.2321	18.2854	18.2321	18.2854	33320.0
2013-01-14 04:15:00	AAPL	Stock	18.25	18.25	18.25	18.25	5600.0
2013-01-14 04:20:00	AAPL	Stock	18.2543	18.2546	18.2543	18.2543	22400.0
2013-01-14 04:25:00	AAPL	Stock	18.2543	18.26	18.25	18.25	92204.0
2013-01-14 04:30:00	AAPL	Stock	18.2236	18.2236	18.2236	18.2236	2800.0
2013-01-14 04:35:00	AAPL	Stock	18.1814	18.2071	18.1814	18.1893	47964.0
2013-01-14 04:50:00	AAPL	Stock	18.1889	18.1889	18.1875	18.1875	5600.0
2013-01-14 04:55:00	AAPL	Stock	18.1789	18.1793	18.1789	18.1793	16800.0
2013-01-14 05:00:00	AAPL	Stock	18.1832	18.1875	18.1789	18.1789	63672.0
2013-01-14 05:05:00	AAPL	Stock	18.1871	18.1875	18.1636	18.1636	35280.0
2013-01-14 05:10:00	AAPL	Stock	18.1643	18.1643	18.1643	18.1643	2800.0
2013-01-14 05:15:00	AAPL	Stock	18.165	18.165	18.1096	18.1114	70336.0
2013-01-14 05:20:00	AAPL	Stock	18.125	18.125	18.105	18.105	21644.0
2013-01-14 05:25:00	AAPL	Stock	18.0804	18.0804	18.0732	18.0732	9016.0
2013-01-14 05:30:00	AAPL	Stock	18.0443	18.0443	17.95	17.9882	211960.0
2013-01-14 05:35:00	AAPL	Stock	17.9875	18.0	17.9646	17.9821	41244.0
2013-01-14 05:40:00	AAPL	Stock	17.9732	17.9757	17.9589	17.9757	19600.0
2013-01-14 05:45:00	AAPL	Stock	17.9589	17.9589	17.9293	17.9311	122976.0
2013-01-14 05:50:00	AAPL	Stock	17.9425	17.9814	17.9425	17.9571	118440.0
2013-01-14 05:55:00	AAPL	Stock	17.9918	17.9918	17.9571	17.9571	25844.0
2013-01-14 06:05:00	AAPL	Stock	17.9786	17.9804	17.9571	17.9575	64176.0
2013-01-14 06:10:00	AAPL	Stock	17.9607	17.9607	17.8554	17.8571	150080.0
2013-01-14 06:15:00	AAPL	Stock	17.8561	17.8561	17.7857	17.7861	299320.0
2013-01-14 06:20:00	AAPL	Stock	17.7946	17.8393	17.75	17.8393	189728.0
2013-01-14 06:25:00	AAPL	Stock	17.7929	17.7929	17.75	17.7857	190568.0
2013-01-14 06:30:00	AAPL	Stock	17.7879	17.8036	17.7554	17.8036	77224.0
2013-01-14 06:35:00	AAPL	Stock	17.7893	17.8529	17.7893	17.8193	171808.0
2013-01-14 06:40:00	AAPL	Stock	17.8214	17.8529	17.8089	17.8529	155372.0
2013-01-14 06:45:00	AAPL	Stock	17.8457	17.8457	17.8036	17.8393	157976.0
2013-01-14 06:50:00	AAPL	Stock	17.8464	17.91	17.8393	17.9004	401912.0
2013-01-14 06:55:00	AAPL	Stock	17.9068	17.9179	17.8807	17.8929	52276.0
2013-01-14 07:00:00	AAPL	Stock	17.9018	17.9532	17.8893	17.9111	592760.0
2013-01-14 07:05:00	AAPL	Stock	17.9286	17.9536	17.9107	17.9286	452676.0
2013-01-14 07:10:00	AAPL	Stock	17.9218	17.9375	17.9196	17.9296	173600.0
2013-01-14 07:15:00	AAPL	Stock	17.9404	17.9818	17.9296	17.9464	180320.0
2013-01-14 07:20:00	AAPL	Stock	17.9518	17.9639	17.9089	17.9125	568820.0
2013-01-14 07:25:00	AAPL	Stock	17.9257	17.9264	17.8571	17.8714	235844.0
2013-01-14 07:30:00	AAPL	Stock	17.8611	17.9125	17.8571	17.8939	669844.0
2013-01-14 07:35:00	AAPL	Stock	17.9107	17.9246	17.8875	17.8925	168140.0
2013-01-14 07:40:00	AAPL	Stock	17.8786	17.9057	17.8557	17.8593	337596.0
2013-01-14 07:45:00	AAPL	Stock	17.8604	17.9036	17.8571	17.9036	486528.0
2013-01-14 07:50:00	AAPL	Stock	17.9086	17.9096	17.8786	17.8829	262864.0
2013-01-14 07:55:00	AAPL	Stock	17.8836	17.9632	17.8818	17.9471	586964.0
2013-01-14 08:00:00	AAPL	Stock	17.9589	18.0282	17.875	17.9107	2559256.0
2013-01-14 08:05:00	AAPL	Stock	17.9043	17.9825	17.9043	17.95	2067520.0
2013-01-14 08:10:00	AAPL	Stock	17.9504	17.9657	17.9286	17.9521	1075172.0
2013-01-14 08:15:00	AAPL	Stock	17.9536	18.0275	17.9411	18.0018	1441048.0
2013-01-14 08:20:00	AAPL	Stock	18.0025	18.0618	18.0	18.0536	1255296.0

> showing 50 of 321,379 rows — these rows as CSV

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