PREVIEW / stock_5min / 2011-07-14

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-07-14.parquet
  size:    4.8 MB
  rows:    325,873
  symbols: 3,518

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
2011-07-14 04:30:00	AAPL	Stock	12.7857	12.7907	12.7857	12.7907	10920.0
2011-07-14 04:35:00	AAPL	Stock	12.7893	12.7893	12.7893	12.7893	2800.0
2011-07-14 04:40:00	AAPL	Stock	12.7893	12.7893	12.7893	12.7893	2800.0
2011-07-14 05:30:00	AAPL	Stock	12.7761	12.7761	12.7714	12.7714	8400.0
2011-07-14 05:40:00	AAPL	Stock	12.735	12.735	12.7321	12.7321	5600.0
2011-07-14 06:00:00	AAPL	Stock	12.7707	12.7857	12.7707	12.7857	28000.0
2011-07-14 06:05:00	AAPL	Stock	12.7857	12.7857	12.7857	12.7857	5600.0
2011-07-14 06:10:00	AAPL	Stock	12.8118	12.8121	12.8118	12.8121	41720.0
2011-07-14 06:20:00	AAPL	Stock	12.8125	12.8125	12.8107	12.8107	8400.0
2011-07-14 06:25:00	AAPL	Stock	12.8107	12.8107	12.8107	12.8107	2800.0
2011-07-14 06:30:00	AAPL	Stock	12.7975	12.7975	12.7864	12.7864	36400.0
2011-07-14 06:35:00	AAPL	Stock	12.7868	12.7868	12.7868	12.7868	11200.0
2011-07-14 06:40:00	AAPL	Stock	12.7868	12.8118	12.7868	12.8118	16800.0
2011-07-14 06:45:00	AAPL	Stock	12.8161	12.8371	12.8161	12.8371	47180.0
2011-07-14 06:50:00	AAPL	Stock	12.8214	12.8214	12.8214	12.8214	5600.0
2011-07-14 07:00:00	AAPL	Stock	12.8221	12.8393	12.8221	12.8321	25200.0
2011-07-14 07:05:00	AAPL	Stock	12.8325	12.8325	12.8114	12.8114	69860.0
2011-07-14 07:10:00	AAPL	Stock	12.8214	12.8471	12.8214	12.8471	81172.0
2011-07-14 07:15:00	AAPL	Stock	12.8471	12.8796	12.8471	12.875	78400.0
2011-07-14 07:20:00	AAPL	Stock	12.865	12.8821	12.8646	12.8661	159432.0
2011-07-14 07:25:00	AAPL	Stock	12.8714	12.885	12.8661	12.885	64400.0
2011-07-14 07:30:00	AAPL	Stock	12.8904	12.9011	12.8821	12.8911	309316.0
2011-07-14 07:35:00	AAPL	Stock	12.8929	12.9029	12.875	12.8929	288904.0
2011-07-14 07:40:00	AAPL	Stock	12.8968	12.9046	12.8936	12.8964	151704.0
2011-07-14 07:45:00	AAPL	Stock	12.8964	12.9029	12.8889	12.9029	177240.0
2011-07-14 07:50:00	AAPL	Stock	12.9071	12.9093	12.8964	12.9	171724.0
2011-07-14 07:55:00	AAPL	Stock	12.8964	12.9071	12.8893	12.9	249200.0
2011-07-14 08:00:00	AAPL	Stock	12.9054	12.9071	12.8857	12.905	637056.0
2011-07-14 08:05:00	AAPL	Stock	12.9018	12.9036	12.8964	12.9036	208600.0
2011-07-14 08:10:00	AAPL	Stock	12.905	12.9143	12.9	12.9107	450240.0
2011-07-14 08:15:00	AAPL	Stock	12.9068	12.9071	12.9011	12.9011	178024.0
2011-07-14 08:20:00	AAPL	Stock	12.9	12.9061	12.8982	12.9	100156.0
2011-07-14 08:25:00	AAPL	Stock	12.9014	12.9029	12.8893	12.9004	337092.0
2011-07-14 08:30:00	AAPL	Stock	12.8982	12.9114	12.8893	12.9025	452424.0
2011-07-14 08:35:00	AAPL	Stock	12.8979	12.9046	12.8929	12.9025	215040.0
2011-07-14 08:40:00	AAPL	Stock	12.9025	12.9025	12.8957	12.9007	210700.0
2011-07-14 08:45:00	AAPL	Stock	12.8975	12.9107	12.8971	12.9071	782824.0
2011-07-14 08:50:00	AAPL	Stock	12.9071	12.9282	12.9071	12.9232	592424.0
2011-07-14 08:55:00	AAPL	Stock	12.9264	12.9446	12.9214	12.9404	549304.0
2011-07-14 09:00:00	AAPL	Stock	12.9364	12.9425	12.9271	12.9336	465668.0
2011-07-14 09:05:00	AAPL	Stock	12.9354	12.9357	12.9196	12.9232	285936.0
2011-07-14 09:10:00	AAPL	Stock	12.925	12.925	12.9125	12.9168	132440.0
2011-07-14 09:15:00	AAPL	Stock	12.9168	12.9221	12.9168	12.9214	120120.0
2011-07-14 09:20:00	AAPL	Stock	12.9214	12.925	12.9214	12.925	66080.0
2011-07-14 09:25:00	AAPL	Stock	12.925	12.9357	12.8896	12.8914	1747788.0
2011-07-14 09:30:00	AAPL	Stock	12.8936	12.9146	12.8668	12.8929	18565932.0
2011-07-14 09:35:00	AAPL	Stock	12.8929	12.8975	12.8696	12.8864	10377612.0
2011-07-14 09:40:00	AAPL	Stock	12.8871	12.8961	12.8289	12.8311	13980204.0
2011-07-14 09:45:00	AAPL	Stock	12.83	12.8904	12.8286	12.8821	9958704.0
2011-07-14 09:50:00	AAPL	Stock	12.8861	12.9032	12.88	12.8979	11719624.0

> showing 50 of 325,873 rows — these rows as CSV

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