PREVIEW / stock_1hour / 2011-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-21.parquet
  size:    933 KB
  rows:    44,406
  symbols: 3,533

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-04-21 04:00:00	AAPL	Stock	12.6964	12.7561	12.6964	12.7282	117320.0
2011-04-21 05:00:00	AAPL	Stock	12.7268	12.74	12.715	12.7329	130200.0
2011-04-21 06:00:00	AAPL	Stock	12.7236	12.7329	12.7	12.7	349300.0
2011-04-21 07:00:00	AAPL	Stock	12.7139	12.8893	12.6904	12.8846	5917800.0
2011-04-21 08:00:00	AAPL	Stock	12.8768	12.8875	12.725	12.75	13383664.0
2011-04-21 09:00:00	AAPL	Stock	12.75	12.7821	12.5561	12.583	218831564.0
2011-04-21 10:00:00	AAPL	Stock	12.5829	12.5836	12.4471	12.5459	185272220.0
2011-04-21 11:00:00	AAPL	Stock	12.5486	12.625	12.5275	12.6125	87407292.0
2011-04-21 12:00:00	AAPL	Stock	12.6141	12.6179	12.5539	12.5743	48411552.0
2011-04-21 13:00:00	AAPL	Stock	12.5736	12.5804	12.5232	12.5582	38851624.0
2011-04-21 14:00:00	AAPL	Stock	12.5582	12.6021	12.5496	12.5663	46995396.0
2011-04-21 15:00:00	AAPL	Stock	12.5675	12.5807	12.5	12.5254	88007108.0
2011-04-21 16:00:00	AAPL	Stock	12.5257	12.6481	12.4589	12.5321	14981624.0
2011-04-21 17:00:00	AAPL	Stock	12.5318	12.5357	12.5286	12.535	347816.0
2011-04-21 18:00:00	AAPL	Stock	12.5321	12.5354	12.525	12.5286	475300.0
2011-04-21 19:00:00	AAPL	Stock	12.5318	12.54	12.5286	12.5339	188272.0
2011-04-21 07:00:00	MSFT	Stock	25.96	25.96	25.95	25.96	9760.0
2011-04-21 08:00:00	MSFT	Stock	25.95	25.96	25.87	25.91	30686.0
2011-04-21 09:00:00	MSFT	Stock	25.91	25.94	25.58	25.63	5307563.0
2011-04-21 10:00:00	MSFT	Stock	25.62	25.72	25.48	25.52	9673442.0
2011-04-21 11:00:00	MSFT	Stock	25.529	25.57	25.5	25.54	4361289.0
2011-04-21 12:00:00	MSFT	Stock	25.531	25.56	25.5	25.53	3735214.0
2011-04-21 13:00:00	MSFT	Stock	25.54	25.54	25.4	25.42	5747593.0
2011-04-21 14:00:00	MSFT	Stock	25.42	25.48	25.36	25.375	5093206.0
2011-04-21 15:00:00	MSFT	Stock	25.375	25.54	25.37	25.53	9468481.0
2011-04-21 16:00:00	MSFT	Stock	25.53	25.58	25.421	25.52	2764616.0
2011-04-21 17:00:00	MSFT	Stock	25.52	25.59	25.52	25.53	15560.0
2011-04-21 18:00:00	MSFT	Stock	25.53	25.53	25.52	25.52	10961.0
2011-04-21 19:00:00	MSFT	Stock	25.53	25.6	25.53	25.59	3020.0
2011-04-21 08:00:00	NVDA	Stock	0.469	0.4718	0.4685	0.4688	501400.0
2011-04-21 09:00:00	NVDA	Stock	0.4668	0.4721	0.4658	0.47	84222280.0
2011-04-21 10:00:00	NVDA	Stock	0.4698	0.4699	0.4625	0.4646	97876560.0
2011-04-21 11:00:00	NVDA	Stock	0.4645	0.466	0.4625	0.466	52216360.0
2011-04-21 12:00:00	NVDA	Stock	0.4658	0.4665	0.4648	0.4653	31610440.0
2011-04-21 13:00:00	NVDA	Stock	0.4652	0.4675	0.4652	0.466	31644520.0
2011-04-21 14:00:00	NVDA	Stock	0.4658	0.466	0.462	0.462	40899080.0
2011-04-21 15:00:00	NVDA	Stock	0.4622	0.4633	0.462	0.463	66936080.0
2011-04-21 16:00:00	NVDA	Stock	0.463	0.466	0.4628	0.463	14987600.0
2011-04-21 17:00:00	NVDA	Stock	0.4643	0.4643	0.4631	0.4631	47520.0
2011-04-21 18:00:00	NVDA	Stock	0.4593	0.4593	0.4593	0.4593	28000.0
2011-04-21 19:00:00	NVDA	Stock	0.4625	0.4628	0.4612	0.4628	56000.0
2011-04-21 06:00:00	AMZN	Stock	9.25	9.25	9.25	9.25	4000.0
2011-04-21 07:00:00	AMZN	Stock	9.25	9.25	9.25	9.25	11260.0
2011-04-21 08:00:00	AMZN	Stock	9.25	9.25	9.225	9.233	160820.0
2011-04-21 09:00:00	AMZN	Stock	9.238	9.2395	9.1523	9.196	7490180.0
2011-04-21 10:00:00	AMZN	Stock	9.1935	9.2075	9.1615	9.1995	8598080.0
2011-04-21 11:00:00	AMZN	Stock	9.2	9.28	9.1665	9.2735	14592420.0
2011-04-21 12:00:00	AMZN	Stock	9.2735	9.281	9.239	9.248	5640260.0
2011-04-21 13:00:00	AMZN	Stock	9.2475	9.2595	9.229	9.238	3569380.0
2011-04-21 14:00:00	AMZN	Stock	9.2378	9.2595	9.234	9.2505	4746780.0

> showing 50 of 44,406 rows — these rows as CSV

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