PREVIEW / stock_1min / 2012-07-25

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-07-25.parquet
  size:    12.3 MB
  rows:    918,765
  symbols: 2,809

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.3214	20.2796	20.2857	39760.0
2012-07-25 04:01:00	AAPL	Stock	20.3525	20.3525	20.3525	20.3525	14700.0
2012-07-25 04:02:00	AAPL	Stock	20.3525	20.3571	20.3525	20.3536	79800.0
2012-07-25 04:03:00	AAPL	Stock	20.3532	20.3571	20.3532	20.3536	72520.0
2012-07-25 04:04:00	AAPL	Stock	20.3493	20.3536	20.3493	20.3536	5880.0
2012-07-25 04:05:00	AAPL	Stock	20.3554	20.3571	20.3554	20.3571	25200.0
2012-07-25 04:06:00	AAPL	Stock	20.3732	20.3893	20.3732	20.3893	39200.0
2012-07-25 04:08:00	AAPL	Stock	20.3929	20.3929	20.3929	20.3929	42840.0
2012-07-25 04:09:00	AAPL	Stock	20.3936	20.3936	20.3929	20.3929	11200.0
2012-07-25 04:10:00	AAPL	Stock	20.3929	20.4104	20.3929	20.4104	5600.0
2012-07-25 04:11:00	AAPL	Stock	20.3929	20.3929	20.3929	20.3929	28000.0
2012-07-25 04:12:00	AAPL	Stock	20.3929	20.3929	20.3929	20.3929	2800.0
2012-07-25 04:14:00	AAPL	Stock	20.3929	20.3929	20.3929	20.3929	5600.0
2012-07-25 04:20:00	AAPL	Stock	20.4107	20.4107	20.4107	20.4107	2800.0
2012-07-25 04:22:00	AAPL	Stock	20.3918	20.3918	20.3918	20.3918	2800.0
2012-07-25 04:23:00	AAPL	Stock	20.3929	20.4089	20.3929	20.4089	5600.0
2012-07-25 04:30:00	AAPL	Stock	20.4179	20.4179	20.4179	20.4179	2800.0
2012-07-25 04:31:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	9800.0
2012-07-25 04:32:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	2800.0
2012-07-25 04:38:00	AAPL	Stock	20.4282	20.4286	20.4282	20.4286	22400.0
2012-07-25 04:39:00	AAPL	Stock	20.4375	20.4375	20.4375	20.4375	5600.0
2012-07-25 04:40:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	8400.0
2012-07-25 04:41:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	25200.0
2012-07-25 04:42:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	14000.0
2012-07-25 04:44:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	5600.0
2012-07-25 04:45:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	5600.0
2012-07-25 04:46:00	AAPL	Stock	20.4375	20.4375	20.4375	20.4375	2800.0
2012-07-25 04:49:00	AAPL	Stock	20.4304	20.4304	20.4304	20.4304	5600.0
2012-07-25 04:51: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:07:00	AAPL	Stock	20.4607	20.4607	20.4607	20.4607	5600.0
2012-07-25 05:11:00	AAPL	Stock	20.4589	20.4625	20.4589	20.4625	8400.0
2012-07-25 05:13:00	AAPL	Stock	20.4604	20.4643	20.4604	20.4643	21112.0
2012-07-25 05:14:00	AAPL	Stock	20.4639	20.4639	20.4639	20.4639	2800.0
2012-07-25 05:15:00	AAPL	Stock	20.4643	20.4643	20.4643	20.4643	13440.0
2012-07-25 05:21:00	AAPL	Stock	20.4607	20.4607	20.4607	20.4607	8400.0
2012-07-25 05:38: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.4786	20.4786	5600.0
2012-07-25 05:42:00	AAPL	Stock	20.4718	20.4718	20.4718	20.4718	2800.0
2012-07-25 05:43:00	AAPL	Stock	20.4714	20.4714	20.4714	20.4714	2800.0
2012-07-25 05:44:00	AAPL	Stock	20.4718	20.4718	20.4718	20.4718	5600.0
2012-07-25 05:49: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.4643	20.4643	11200.0
2012-07-25 05:51:00	AAPL	Stock	20.4464	20.4518	20.4464	20.4518	12600.0
2012-07-25 05:54:00	AAPL	Stock	20.46	20.46	20.46	20.46	2800.0
2012-07-25 05:58:00	AAPL	Stock	20.4339	20.4339	20.4304	20.4307	33600.0
2012-07-25 05:59:00	AAPL	Stock	20.4307	20.4307	20.4307	20.4307	12600.0
2012-07-25 06:02:00	AAPL	Stock	20.4357	20.4357	20.4357	20.4357	2800.0
2012-07-25 06:03:00	AAPL	Stock	20.4607	20.4607	20.4607	20.4607	11256.0
2012-07-25 06:04:00	AAPL	Stock	20.4607	20.4607	20.4607	20.4607	4256.0

> showing 50 of 918,765 rows — these rows as CSV

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