PREVIEW / stock_5min / 2012-07-25

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-25.parquet
  size:    4.6 MB
  rows:    314,065
  symbols: 3,477

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-25 04:00:00	AAPL	Stock	20.3214	20.3571	20.2796	20.3536	212660.0
2012-07-25 04:05:00	AAPL	Stock	20.3554	20.3936	20.3554	20.3929	118440.0
2012-07-25 04:10:00	AAPL	Stock	20.3929	20.4104	20.3929	20.3929	42000.0
2012-07-25 04:20:00	AAPL	Stock	20.4107	20.4107	20.3918	20.4089	11200.0
2012-07-25 04:30:00	AAPL	Stock	20.4179	20.4286	20.4179	20.4286	15400.0
2012-07-25 04:35:00	AAPL	Stock	20.4282	20.4375	20.4282	20.4375	28000.0
2012-07-25 04:40:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	53200.0
2012-07-25 04:45:00	AAPL	Stock	20.4286	20.4375	20.4286	20.4304	14000.0
2012-07-25 04:50:00	AAPL	Stock	20.4393	20.4393	20.4393	20.4393	2800.0
2012-07-25 04:55:00	AAPL	Stock	20.4429	20.4429	20.4429	20.4429	5600.0
2012-07-25 05:05:00	AAPL	Stock	20.4607	20.4607	20.4607	20.4607	5600.0
2012-07-25 05:10:00	AAPL	Stock	20.4589	20.4643	20.4589	20.4639	32312.0
2012-07-25 05:15:00	AAPL	Stock	20.4643	20.4643	20.4643	20.4643	13440.0
2012-07-25 05:20:00	AAPL	Stock	20.4607	20.4607	20.4607	20.4607	8400.0
2012-07-25 05:35:00	AAPL	Stock	20.4571	20.4607	20.4571	20.4607	11200.0
2012-07-25 05:40:00	AAPL	Stock	20.4786	20.4786	20.4714	20.4718	16800.0
2012-07-25 05:45:00	AAPL	Stock	20.4718	20.4786	20.4718	20.4786	8400.0
2012-07-25 05:50:00	AAPL	Stock	20.4718	20.4718	20.4464	20.46	26600.0
2012-07-25 05:55:00	AAPL	Stock	20.4339	20.4339	20.4304	20.4307	46200.0
2012-07-25 06:00:00	AAPL	Stock	20.4357	20.4607	20.4357	20.4607	18312.0
2012-07-25 06:10:00	AAPL	Stock	20.4464	20.4643	20.4379	20.4379	43400.0
2012-07-25 06:15:00	AAPL	Stock	20.4379	20.4379	20.4357	20.4379	56000.0
2012-07-25 06:20:00	AAPL	Stock	20.4357	20.4357	20.4286	20.4286	16800.0
2012-07-25 06:30:00	AAPL	Stock	20.4318	20.4318	20.4314	20.4314	8400.0
2012-07-25 06:35:00	AAPL	Stock	20.4314	20.4314	20.4311	20.4311	5600.0
2012-07-25 06:40:00	AAPL	Stock	20.4314	20.4314	20.4196	20.4196	35280.0
2012-07-25 06:45:00	AAPL	Stock	20.4214	20.4286	20.4214	20.4282	50400.0
2012-07-25 06:50:00	AAPL	Stock	20.4282	20.4643	20.4282	20.4625	176568.0
2012-07-25 06:55:00	AAPL	Stock	20.455	20.4643	20.4286	20.4357	64260.0
2012-07-25 07:00:00	AAPL	Stock	20.4289	20.4375	20.405	20.4086	192528.0
2012-07-25 07:05:00	AAPL	Stock	20.4107	20.4107	20.3429	20.3732	270928.0
2012-07-25 07:10:00	AAPL	Stock	20.3732	20.4286	20.3732	20.4286	131656.0
2012-07-25 07:15:00	AAPL	Stock	20.3964	20.4214	20.3929	20.4107	206752.0
2012-07-25 07:20:00	AAPL	Stock	20.4111	20.4804	20.4107	20.4607	266308.0
2012-07-25 07:25:00	AAPL	Stock	20.4725	20.4954	20.4725	20.4861	235900.0
2012-07-25 07:30:00	AAPL	Stock	20.4861	20.4954	20.4643	20.4918	516740.0
2012-07-25 07:35:00	AAPL	Stock	20.4918	20.5489	20.4839	20.5321	1124060.0
2012-07-25 07:40:00	AAPL	Stock	20.5321	20.5464	20.5179	20.5464	745416.0
2012-07-25 07:45:00	AAPL	Stock	20.5446	20.5482	20.5307	20.5307	456512.0
2012-07-25 07:50:00	AAPL	Stock	20.5311	20.5714	20.5307	20.5307	780276.0
2012-07-25 07:55:00	AAPL	Stock	20.5307	20.5496	20.465	20.4821	981512.0
2012-07-25 08:00:00	AAPL	Stock	20.5404	20.5464	20.4414	20.4511	1594124.0
2012-07-25 08:05:00	AAPL	Stock	20.4504	20.4779	20.4411	20.4411	348628.0
2012-07-25 08:10:00	AAPL	Stock	20.4404	20.4661	20.4329	20.4461	459256.0
2012-07-25 08:15:00	AAPL	Stock	20.4461	20.4629	20.4461	20.4589	725284.0
2012-07-25 08:20:00	AAPL	Stock	20.4504	20.4804	20.4504	20.4632	1379924.0
2012-07-25 08:25:00	AAPL	Stock	20.4639	20.465	20.4464	20.4464	1441076.0
2012-07-25 08:30:00	AAPL	Stock	20.4464	20.4643	20.4464	20.4643	1507100.0
2012-07-25 08:35:00	AAPL	Stock	20.4575	20.4714	20.4464	20.4536	1302868.0
2012-07-25 08:40:00	AAPL	Stock	20.4571	20.4679	20.4571	20.4643	432880.0

> showing 50 of 314,065 rows — these rows as CSV

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