PREVIEW / stock_5min / 2012-07-20

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-20.parquet
  size:    4.6 MB
  rows:    308,104
  symbols: 3,463

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-07-20 05:30:00	AAPL	Stock	21.9646	21.9646	21.9643	21.9643	5600.0
2012-07-20 05:50:00	AAPL	Stock	21.9643	21.9643	21.9643	21.9643	2800.0
2012-07-20 06:00:00	AAPL	Stock	21.9643	21.9643	21.9643	21.9643	2800.0
2012-07-20 06:10:00	AAPL	Stock	21.9818	21.9818	21.9818	21.9818	2800.0
2012-07-20 06:25:00	AAPL	Stock	21.9871	21.9871	21.9871	21.9871	2800.0
2012-07-20 06:55:00	AAPL	Stock	21.9821	21.9821	21.9646	21.9646	16800.0
2012-07-20 07:00:00	AAPL	Stock	21.9646	21.9782	21.9589	21.9643	39228.0
2012-07-20 07:05:00	AAPL	Stock	21.9554	21.9554	21.9554	21.9554	2800.0
2012-07-20 07:10:00	AAPL	Stock	21.9414	21.9414	21.9414	21.9414	5600.0
2012-07-20 07:15:00	AAPL	Stock	21.9411	21.9446	21.9307	21.9318	32200.0
2012-07-20 07:20:00	AAPL	Stock	21.9357	21.9357	21.9321	21.9321	8008.0
2012-07-20 07:25:00	AAPL	Stock	21.9361	21.9361	21.9321	21.9321	6048.0
2012-07-20 07:30:00	AAPL	Stock	21.9482	21.9482	21.9357	21.9429	35980.0
2012-07-20 07:35:00	AAPL	Stock	21.9464	21.9464	21.9107	21.9107	71484.0
2012-07-20 07:40:00	AAPL	Stock	21.9107	21.9125	21.8571	21.8679	163464.0
2012-07-20 07:45:00	AAPL	Stock	21.8839	21.8875	21.8625	21.8625	36400.0
2012-07-20 07:50:00	AAPL	Stock	21.8643	21.8643	21.8214	21.8232	67340.0
2012-07-20 07:55:00	AAPL	Stock	21.8604	21.8604	21.8554	21.8571	33600.0
2012-07-20 08:00:00	AAPL	Stock	21.8739	21.9643	21.8507	21.9029	248136.0
2012-07-20 08:05:00	AAPL	Stock	21.9036	21.9089	21.8814	21.8929	299012.0
2012-07-20 08:10:00	AAPL	Stock	21.9025	21.9196	21.8982	21.9179	234164.0
2012-07-20 08:15:00	AAPL	Stock	21.9143	21.9196	21.9039	21.9196	168784.0
2012-07-20 08:20:00	AAPL	Stock	21.9196	21.9246	21.9125	21.9179	54012.0
2012-07-20 08:25:00	AAPL	Stock	21.9125	21.9136	21.9018	21.9071	141288.0
2012-07-20 08:30:00	AAPL	Stock	21.9107	21.9164	21.8929	21.8975	178472.0
2012-07-20 08:35:00	AAPL	Stock	21.8929	21.91	21.8846	21.8929	344148.0
2012-07-20 08:40:00	AAPL	Stock	21.9	21.9054	21.8929	21.9054	68320.0
2012-07-20 08:45:00	AAPL	Stock	21.9057	21.9107	21.9032	21.9057	38640.0
2012-07-20 08:50:00	AAPL	Stock	21.9054	21.9061	21.9	21.9032	51352.0
2012-07-20 08:55:00	AAPL	Stock	21.9004	21.9007	21.8754	21.8829	104580.0
2012-07-20 09:00:00	AAPL	Stock	21.8857	21.9125	21.8839	21.9096	172592.0
2012-07-20 09:05:00	AAPL	Stock	21.9029	21.9357	21.9025	21.9286	247380.0
2012-07-20 09:10:00	AAPL	Stock	21.9321	21.935	21.9232	21.9282	199080.0
2012-07-20 09:15:00	AAPL	Stock	21.9221	21.925	21.9146	21.9211	178080.0
2012-07-20 09:20:00	AAPL	Stock	21.9254	21.9282	21.9107	21.92	136080.0
2012-07-20 09:25:00	AAPL	Stock	21.9179	21.9625	21.8904	21.8982	2710624.0
2012-07-20 09:30:00	AAPL	Stock	21.8982	21.9286	21.8432	21.8871	32859176.0
2012-07-20 09:35:00	AAPL	Stock	21.8843	21.9443	21.8789	21.9329	8777580.0
2012-07-20 09:40:00	AAPL	Stock	21.9357	21.9357	21.8914	21.8968	7049700.0
2012-07-20 09:45:00	AAPL	Stock	21.9004	21.9011	21.8536	21.8771	7460628.0
2012-07-20 09:50:00	AAPL	Stock	21.8757	21.9286	21.8664	21.9139	6330884.0
2012-07-20 09:55:00	AAPL	Stock	21.9161	21.9174	21.8793	21.8957	4524520.0
2012-07-20 10:00:00	AAPL	Stock	21.8904	21.9104	21.8761	21.8964	5715472.0
2012-07-20 10:05:00	AAPL	Stock	21.8979	21.9025	21.8664	21.8964	4631536.0
2012-07-20 10:10:00	AAPL	Stock	21.8964	21.8997	21.8764	21.8796	4757928.0
2012-07-20 10:15:00	AAPL	Stock	21.88	21.883	21.8589	21.8624	6095544.0
2012-07-20 10:20:00	AAPL	Stock	21.8604	21.8679	21.8089	21.831	10315368.0
2012-07-20 10:25:00	AAPL	Stock	21.829	21.8636	21.8268	21.8539	3984820.0
2012-07-20 10:30:00	AAPL	Stock	21.8568	21.8607	21.8082	21.8164	3392508.0
2012-07-20 10:35:00	AAPL	Stock	21.8198	21.8201	21.8004	21.8132	4990496.0

> showing 50 of 308,104 rows — these rows as CSV

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