PREVIEW / stock_1hour / 2012-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-04.parquet
  size:    941 KB
  rows:    44,881
  symbols: 3,532

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-06-04 04:00:00	AAPL	Stock	19.9643	19.9643	19.8529	19.8571	112308.0
2012-06-04 05:00:00	AAPL	Stock	19.8571	19.9286	19.8571	19.9107	64876.0
2012-06-04 06:00:00	AAPL	Stock	19.9321	20.0357	19.9321	20.0357	132860.0
2012-06-04 07:00:00	AAPL	Stock	20.0357	20.0864	19.9843	20.0664	581056.0
2012-06-04 08:00:00	AAPL	Stock	20.0625	20.1236	19.9821	20.0646	2544836.0
2012-06-04 09:00:00	AAPL	Stock	20.0636	20.2071	19.7775	19.8214	89096868.0
2012-06-04 10:00:00	AAPL	Stock	19.8204	19.9536	19.5893	19.8661	127277556.0
2012-06-04 11:00:00	AAPL	Stock	19.8571	19.8989	19.6682	19.6714	48963908.0
2012-06-04 12:00:00	AAPL	Stock	19.6686	19.7429	19.625	19.7103	42149268.0
2012-06-04 13:00:00	AAPL	Stock	19.7036	19.8964	19.7007	19.895	45966368.0
2012-06-04 14:00:00	AAPL	Stock	19.8929	20.1883	19.8479	20.0642	96319440.0
2012-06-04 15:00:00	AAPL	Stock	20.0591	20.1546	19.9382	20.1532	88194288.0
2012-06-04 16:00:00	AAPL	Stock	20.1529	20.1532	19.7544	20.1375	12816636.0
2012-06-04 17:00:00	AAPL	Stock	20.0354	20.1532	20.0354	20.1354	296828.0
2012-06-04 18:00:00	AAPL	Stock	20.1346	20.1571	20.1279	20.1357	530880.0
2012-06-04 19:00:00	AAPL	Stock	20.1286	20.1529	20.1286	20.1429	309792.0
2012-06-04 04:00:00	MSFT	Stock	28.37	28.37	28.35	28.35	300.0
2012-06-04 06:00:00	MSFT	Stock	28.58	28.58	28.48	28.48	1000.0
2012-06-04 07:00:00	MSFT	Stock	28.44	28.48	28.44	28.48	3949.0
2012-06-04 08:00:00	MSFT	Stock	28.52	28.52	28.42	28.45	21940.0
2012-06-04 09:00:00	MSFT	Stock	28.46	28.78	28.39	28.41	5220173.0
2012-06-04 10:00:00	MSFT	Stock	28.42	28.645	28.32	28.51	7254674.0
2012-06-04 11:00:00	MSFT	Stock	28.51	28.52	28.38	28.42	4441442.0
2012-06-04 12:00:00	MSFT	Stock	28.41	28.475	28.37	28.42	4045505.0
2012-06-04 13:00:00	MSFT	Stock	28.42	28.49	28.33	28.41	4310354.0
2012-06-04 14:00:00	MSFT	Stock	28.41	28.57	28.35	28.434	5783622.0
2012-06-04 15:00:00	MSFT	Stock	28.43	28.56	28.35	28.54	9770448.0
2012-06-04 16:00:00	MSFT	Stock	28.53	28.55	28.42	28.55	4934242.0
2012-06-04 17:00:00	MSFT	Stock	28.55	28.55	28.55	28.55	16061.0
2012-06-04 18:00:00	MSFT	Stock	28.48	28.54	28.48	28.54	1500.0
2012-06-04 19:00:00	MSFT	Stock	28.54	28.55	28.52	28.54	1680.0
2012-06-04 04:00:00	NVDA	Stock	0.294	0.294	0.294	0.294	31000.0
2012-06-04 08:00:00	NVDA	Stock	0.2995	0.3005	0.2995	0.3005	50000.0
2012-06-04 09:00:00	NVDA	Stock	0.3005	0.3028	0.2958	0.2965	43851680.0
2012-06-04 10:00:00	NVDA	Stock	0.2966	0.297	0.294	0.2945	75914720.0
2012-06-04 11:00:00	NVDA	Stock	0.2945	0.295	0.2925	0.2928	42645920.0
2012-06-04 12:00:00	NVDA	Stock	0.2928	0.293	0.2911	0.2918	40186080.0
2012-06-04 13:00:00	NVDA	Stock	0.2918	0.2926	0.2908	0.2915	46791880.0
2012-06-04 14:00:00	NVDA	Stock	0.2917	0.2942	0.2908	0.293	68302760.0
2012-06-04 15:00:00	NVDA	Stock	0.2931	0.294	0.2915	0.2932	99526720.0
2012-06-04 16:00:00	NVDA	Stock	0.2932	0.2957	0.2918	0.2932	15214680.0
2012-06-04 17:00:00	NVDA	Stock	0.2932	0.2932	0.2925	0.2925	116000.0
2012-06-04 18:00:00	NVDA	Stock	0.2925	0.2925	0.2925	0.2925	80000.0
2012-06-04 19:00:00	NVDA	Stock	0.2915	0.2945	0.2915	0.2945	46000.0
2012-06-04 04:00:00	AMZN	Stock	10.34	10.34	10.33	10.33	25900.0
2012-06-04 05:00:00	AMZN	Stock	10.331	10.331	10.33	10.33	8000.0
2012-06-04 06:00:00	AMZN	Stock	10.384	10.384	10.384	10.384	19600.0
2012-06-04 07:00:00	AMZN	Stock	10.3985	10.3985	10.334	10.385	40340.0
2012-06-04 08:00:00	AMZN	Stock	10.356	10.402	10.3555	10.3615	384520.0
2012-06-04 09:00:00	AMZN	Stock	10.38	10.5445	10.3695	10.426	10412380.0

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

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