PREVIEW / stock_5min / 2012-05-17

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-05-17.parquet
  size:    5.1 MB
  rows:    341,955
  symbols: 3,534

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-05-17 04:10:00	AAPL	Stock	19.4532	19.4532	19.4532	19.4532	2800.0
2012-05-17 04:50:00	AAPL	Stock	19.4532	19.4532	19.4532	19.4532	2800.0
2012-05-17 05:30:00	AAPL	Stock	19.4286	19.4286	19.4196	19.4196	5600.0
2012-05-17 06:15:00	AAPL	Stock	19.4393	19.4393	19.4393	19.4393	11200.0
2012-05-17 06:20:00	AAPL	Stock	19.4407	19.4407	19.4407	19.4407	2800.0
2012-05-17 06:35:00	AAPL	Stock	19.4407	19.4407	19.4407	19.4407	28000.0
2012-05-17 06:40:00	AAPL	Stock	19.4407	19.4407	19.4407	19.4407	16800.0
2012-05-17 06:45:00	AAPL	Stock	19.4107	19.4107	19.4107	19.4107	2800.0
2012-05-17 07:00:00	AAPL	Stock	19.4279	19.4279	19.4089	19.4143	22400.0
2012-05-17 07:05:00	AAPL	Stock	19.4143	19.4143	19.4143	19.4143	22344.0
2012-05-17 07:10:00	AAPL	Stock	19.4107	19.4357	19.3982	19.4357	64232.0
2012-05-17 07:15:00	AAPL	Stock	19.4375	19.4643	19.4286	19.4464	70700.0
2012-05-17 07:20:00	AAPL	Stock	19.4286	19.4496	19.4286	19.4496	37660.0
2012-05-17 07:25:00	AAPL	Stock	19.4464	19.4464	19.4286	19.4464	47600.0
2012-05-17 07:30:00	AAPL	Stock	19.4314	19.4314	19.4054	19.4054	44856.0
2012-05-17 07:35:00	AAPL	Stock	19.4057	19.4057	19.3575	19.375	109200.0
2012-05-17 07:40:00	AAPL	Stock	19.3579	19.3839	19.3332	19.3839	122864.0
2012-05-17 07:45:00	AAPL	Stock	19.3714	19.4104	19.3714	19.3929	11256.0
2012-05-17 07:50:00	AAPL	Stock	19.4111	19.4111	19.3857	19.3929	53956.0
2012-05-17 07:55:00	AAPL	Stock	19.4036	19.4054	19.4036	19.4054	12460.0
2012-05-17 08:00:00	AAPL	Stock	19.4107	19.4604	19.375	19.4321	324156.0
2012-05-17 08:05:00	AAPL	Stock	19.4329	19.4386	19.41	19.4164	74620.0
2012-05-17 08:10:00	AAPL	Stock	19.4161	19.4268	19.4032	19.4032	79660.0
2012-05-17 08:15:00	AAPL	Stock	19.3971	19.3971	19.3611	19.3643	240380.0
2012-05-17 08:20:00	AAPL	Stock	19.3643	19.3786	19.3643	19.3764	327628.0
2012-05-17 08:25:00	AAPL	Stock	19.3764	19.3768	19.3643	19.3746	191828.0
2012-05-17 08:30:00	AAPL	Stock	19.3646	19.3886	19.3446	19.3821	258944.0
2012-05-17 08:35:00	AAPL	Stock	19.3918	19.4604	19.3918	19.4464	362488.0
2012-05-17 08:40:00	AAPL	Stock	19.4411	19.4786	19.4393	19.4739	331828.0
2012-05-17 08:45:00	AAPL	Stock	19.4793	19.5096	19.4725	19.5082	640640.0
2012-05-17 08:50:00	AAPL	Stock	19.5089	19.5529	19.5046	19.54	595588.0
2012-05-17 08:55:00	AAPL	Stock	19.5386	19.5564	19.5221	19.5429	554960.0
2012-05-17 09:00:00	AAPL	Stock	19.5389	19.5389	19.5057	19.5179	264572.0
2012-05-17 09:05:00	AAPL	Stock	19.5229	19.5421	19.5	19.5161	295988.0
2012-05-17 09:10:00	AAPL	Stock	19.5096	19.5379	19.5096	19.5361	121184.0
2012-05-17 09:15:00	AAPL	Stock	19.5393	19.5768	19.5268	19.5768	504588.0
2012-05-17 09:20:00	AAPL	Stock	19.5786	19.5807	19.5507	19.5514	307188.0
2012-05-17 09:25:00	AAPL	Stock	19.5571	19.5571	19.4646	19.4732	1370012.0
2012-05-17 09:30:00	AAPL	Stock	19.4754	19.5536	19.4518	19.4521	17262112.0
2012-05-17 09:35:00	AAPL	Stock	19.4518	19.4671	19.3543	19.3581	15425620.0
2012-05-17 09:40:00	AAPL	Stock	19.3607	19.375	19.325	19.3311	16516080.0
2012-05-17 09:45:00	AAPL	Stock	19.3271	19.3272	19.1929	19.2307	30834188.0
2012-05-17 09:50:00	AAPL	Stock	19.2336	19.2671	19.1943	19.2196	18213748.0
2012-05-17 09:55:00	AAPL	Stock	19.2179	19.2664	19.1804	19.2489	16539488.0
2012-05-17 10:00:00	AAPL	Stock	19.2443	19.2543	19.1261	19.155	20331136.0
2012-05-17 10:05:00	AAPL	Stock	19.1557	19.1871	19.0961	19.1857	20179124.0
2012-05-17 10:10:00	AAPL	Stock	19.1821	19.2159	19.1468	19.2104	14400764.0
2012-05-17 10:15:00	AAPL	Stock	19.2136	19.275	19.1971	19.2632	19539520.0
2012-05-17 10:20:00	AAPL	Stock	19.2661	19.3636	19.2654	19.3571	20002892.0
2012-05-17 10:25:00	AAPL	Stock	19.3525	19.3571	19.2521	19.2879	15875972.0

> showing 50 of 341,955 rows — these rows as CSV

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