PREVIEW / stock_1min / 2011-06-23

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-06-23.parquet
  size:    13.9 MB
  rows:    1,052,622
  symbols: 2,855

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-06-23 04:06:00	AAPL	Stock	11.4846	11.4846	11.4846	11.4846	2800.0
2011-06-23 06:04:00	AAPL	Stock	11.4654	11.4654	11.4654	11.4654	2800.0
2011-06-23 06:28:00	AAPL	Stock	11.4554	11.4554	11.4554	11.4554	14000.0
2011-06-23 06:35:00	AAPL	Stock	11.4543	11.4543	11.4543	11.4543	14000.0
2011-06-23 06:47:00	AAPL	Stock	11.4421	11.4421	11.4421	11.4421	2940.0
2011-06-23 06:57:00	AAPL	Stock	11.4421	11.4421	11.4421	11.4421	9324.0
2011-06-23 07:01:00	AAPL	Stock	11.4461	11.4461	11.4386	11.4386	29512.0
2011-06-23 07:02:00	AAPL	Stock	11.4429	11.4429	11.4429	11.4429	5600.0
2011-06-23 07:04:00	AAPL	Stock	11.4518	11.4714	11.4518	11.4518	56000.0
2011-06-23 07:05:00	AAPL	Stock	11.4518	11.4518	11.4518	11.4518	8400.0
2011-06-23 07:16:00	AAPL	Stock	11.4643	11.4643	11.4643	11.4643	5600.0
2011-06-23 07:17:00	AAPL	Stock	11.4571	11.4821	11.4571	11.4714	22400.0
2011-06-23 07:20:00	AAPL	Stock	11.4679	11.4679	11.4679	11.4679	2800.0
2011-06-23 07:23:00	AAPL	Stock	11.4643	11.4643	11.4643	11.4643	2800.0
2011-06-23 07:27:00	AAPL	Stock	11.4643	11.4643	11.4643	11.4643	2800.0
2011-06-23 07:37:00	AAPL	Stock	11.4536	11.4554	11.4489	11.4536	44800.0
2011-06-23 07:38:00	AAPL	Stock	11.45	11.45	11.4464	11.45	53200.0
2011-06-23 07:39:00	AAPL	Stock	11.4486	11.45	11.4429	11.4429	14000.0
2011-06-23 07:40:00	AAPL	Stock	11.4482	11.45	11.4482	11.45	16800.0
2011-06-23 07:41:00	AAPL	Stock	11.4429	11.4468	11.4404	11.4404	16800.0
2011-06-23 07:42:00	AAPL	Stock	11.4404	11.4404	11.4404	11.4404	2800.0
2011-06-23 07:43:00	AAPL	Stock	11.4429	11.4429	11.4429	11.4429	2800.0
2011-06-23 07:44:00	AAPL	Stock	11.4429	11.4429	11.4429	11.4429	8400.0
2011-06-23 07:45:00	AAPL	Stock	11.4429	11.4464	11.4429	11.4464	16436.0
2011-06-23 07:46:00	AAPL	Stock	11.4604	11.4604	11.4604	11.4604	2800.0
2011-06-23 07:48:00	AAPL	Stock	11.4482	11.4482	11.4482	11.4482	2800.0
2011-06-23 07:56:00	AAPL	Stock	11.4571	11.4643	11.4568	11.4596	42000.0
2011-06-23 08:00:00	AAPL	Stock	11.4643	11.4643	11.4464	11.4464	28252.0
2011-06-23 08:01:00	AAPL	Stock	11.4546	11.4546	11.4375	11.4457	38500.0
2011-06-23 08:02:00	AAPL	Stock	11.4429	11.4429	11.4364	11.4382	59136.0
2011-06-23 08:03:00	AAPL	Stock	11.4368	11.4382	11.4368	11.4382	16800.0
2011-06-23 08:04:00	AAPL	Stock	11.4361	11.4361	11.4361	11.4361	4816.0
2011-06-23 08:05:00	AAPL	Stock	11.4411	11.4411	11.4379	11.4379	8400.0
2011-06-23 08:06:00	AAPL	Stock	11.4379	11.4425	11.4379	11.4407	8400.0
2011-06-23 08:07:00	AAPL	Stock	11.4407	11.4407	11.4407	11.4407	2800.0
2011-06-23 08:08:00	AAPL	Stock	11.4407	11.4407	11.4407	11.4407	5600.0
2011-06-23 08:09:00	AAPL	Stock	11.4411	11.4411	11.4411	11.4411	14280.0
2011-06-23 08:12:00	AAPL	Stock	11.4464	11.4464	11.4429	11.4429	8400.0
2011-06-23 08:13:00	AAPL	Stock	11.4389	11.44	11.4361	11.4361	51744.0
2011-06-23 08:14:00	AAPL	Stock	11.4357	11.4357	11.4357	11.4357	2884.0
2011-06-23 08:15:00	AAPL	Stock	11.4375	11.4375	11.4364	11.4364	11200.0
2011-06-23 08:16:00	AAPL	Stock	11.4357	11.4357	11.435	11.435	5684.0
2011-06-23 08:17:00	AAPL	Stock	11.4329	11.4382	11.4311	11.4382	16800.0
2011-06-23 08:20:00	AAPL	Stock	11.4307	11.4307	11.4304	11.4304	32956.0
2011-06-23 08:21:00	AAPL	Stock	11.4343	11.4343	11.4321	11.4321	5600.0
2011-06-23 08:22:00	AAPL	Stock	11.4321	11.4321	11.4286	11.4286	102536.0
2011-06-23 08:23:00	AAPL	Stock	11.4286	11.4286	11.4286	11.4286	8400.0
2011-06-23 08:24:00	AAPL	Stock	11.4254	11.4254	11.4239	11.4239	70000.0
2011-06-23 08:25:00	AAPL	Stock	11.4225	11.425	11.4214	11.4239	60760.0
2011-06-23 08:26:00	AAPL	Stock	11.4239	11.4286	11.4232	11.4232	64400.0

> showing 50 of 1,052,622 rows — these rows as CSV

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