PREVIEW / stock_5min / 2013-01-09

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-01-09.parquet
  size:    4.8 MB
  rows:    323,062
  symbols: 3,453

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-09 04:00:00	AAPL	Stock	18.8571	18.8571	18.8571	18.8571	2800.0
2013-01-09 04:10:00	AAPL	Stock	18.8282	18.8282	18.8279	18.8279	5600.0
2013-01-09 04:20:00	AAPL	Stock	18.8107	18.8107	18.8107	18.8107	2800.0
2013-01-09 04:45:00	AAPL	Stock	18.8207	18.8207	18.8157	18.8157	5600.0
2013-01-09 05:15:00	AAPL	Stock	18.8161	18.8161	18.8161	18.8161	2800.0
2013-01-09 05:25:00	AAPL	Stock	18.8161	18.8161	18.8161	18.8161	2800.0
2013-01-09 05:50:00	AAPL	Stock	18.8157	18.8157	18.8057	18.8057	11200.0
2013-01-09 06:05:00	AAPL	Stock	18.8161	18.8161	18.8161	18.8161	2800.0
2013-01-09 06:15:00	AAPL	Stock	18.8089	18.8161	18.8036	18.8036	26404.0
2013-01-09 06:30:00	AAPL	Stock	18.7964	18.8036	18.7964	18.8036	9380.0
2013-01-09 06:45:00	AAPL	Stock	18.7857	18.7857	18.7679	18.7679	67060.0
2013-01-09 06:50:00	AAPL	Stock	18.7671	18.7671	18.7671	18.7671	2800.0
2013-01-09 07:00:00	AAPL	Stock	18.7504	18.7507	18.7321	18.7321	74536.0
2013-01-09 07:05:00	AAPL	Stock	18.7321	18.7411	18.7321	18.7411	14000.0
2013-01-09 07:10:00	AAPL	Stock	18.75	18.7518	18.75	18.75	16800.0
2013-01-09 07:15:00	AAPL	Stock	18.7496	18.7857	18.7496	18.7857	30492.0
2013-01-09 07:20:00	AAPL	Stock	18.7857	18.8211	18.7857	18.8036	123760.0
2013-01-09 07:25:00	AAPL	Stock	18.8029	18.8121	18.8014	18.8121	31360.0
2013-01-09 07:30:00	AAPL	Stock	18.8	18.8096	18.8	18.8096	5600.0
2013-01-09 07:35:00	AAPL	Stock	18.8104	18.8107	18.8036	18.8036	15764.0
2013-01-09 07:50:00	AAPL	Stock	18.7964	18.7964	18.7964	18.7964	5600.0
2013-01-09 07:55:00	AAPL	Stock	18.7975	18.7975	18.7921	18.7921	8400.0
2013-01-09 08:00:00	AAPL	Stock	18.7968	18.8107	18.745	18.7532	362600.0
2013-01-09 08:05:00	AAPL	Stock	18.7529	18.7596	18.6071	18.6786	505988.0
2013-01-09 08:10:00	AAPL	Stock	18.6571	18.6714	18.6429	18.6714	206864.0
2013-01-09 08:15:00	AAPL	Stock	18.6607	18.7054	18.6607	18.7054	165872.0
2013-01-09 08:20:00	AAPL	Stock	18.695	18.695	18.6732	18.6864	200200.0
2013-01-09 08:25:00	AAPL	Stock	18.685	18.6964	18.6786	18.6825	397600.0
2013-01-09 08:30:00	AAPL	Stock	18.6882	18.7089	18.6796	18.6896	195384.0
2013-01-09 08:35:00	AAPL	Stock	18.6914	18.7075	18.6357	18.6543	568232.0
2013-01-09 08:40:00	AAPL	Stock	18.6479	18.6718	18.625	18.6471	661864.0
2013-01-09 08:45:00	AAPL	Stock	18.6596	18.6607	18.6386	18.6475	305564.0
2013-01-09 08:50:00	AAPL	Stock	18.6582	18.6764	18.6429	18.6764	291480.0
2013-01-09 08:55:00	AAPL	Stock	18.6696	18.6857	18.6564	18.6625	404124.0
2013-01-09 09:00:00	AAPL	Stock	18.6579	18.6593	18.6429	18.6539	318360.0
2013-01-09 09:05:00	AAPL	Stock	18.6507	18.6589	18.6339	18.6589	345492.0
2013-01-09 09:10:00	AAPL	Stock	18.6521	18.6893	18.6521	18.68	361284.0
2013-01-09 09:15:00	AAPL	Stock	18.68	18.68	18.6586	18.6586	170520.0
2013-01-09 09:20:00	AAPL	Stock	18.6554	18.6554	18.6318	18.6421	382732.0
2013-01-09 09:25:00	AAPL	Stock	18.6425	18.6786	18.6421	18.6607	816508.0
2013-01-09 09:30:00	AAPL	Stock	18.6593	18.7429	18.5923	18.6046	21123760.0
2013-01-09 09:35:00	AAPL	Stock	18.6029	18.6375	18.5793	18.5793	13817188.0
2013-01-09 09:40:00	AAPL	Stock	18.5793	18.5882	18.5393	18.5507	12994996.0
2013-01-09 09:45:00	AAPL	Stock	18.5514	18.6171	18.5475	18.5896	10607520.0
2013-01-09 09:50:00	AAPL	Stock	18.59	18.6693	18.5717	18.6461	11773356.0
2013-01-09 09:55:00	AAPL	Stock	18.6458	18.6946	18.6225	18.6314	10154256.0
2013-01-09 10:00:00	AAPL	Stock	18.6279	18.6579	18.585	18.5936	8050168.0
2013-01-09 10:05:00	AAPL	Stock	18.59	18.6071	18.5629	18.585	7877324.0
2013-01-09 10:10:00	AAPL	Stock	18.5875	18.6286	18.5761	18.6126	4647216.0
2013-01-09 10:15:00	AAPL	Stock	18.6125	18.6568	18.5993	18.6182	5977552.0

> showing 50 of 323,062 rows — these rows as CSV

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