PREVIEW / stock_1hour / 2011-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-08.parquet
  size:    938 KB
  rows:    44,281
  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-07-08 04:00:00	AAPL	Stock	12.7696	12.7696	12.7696	12.7696	2800.0
2011-07-08 05:00:00	AAPL	Stock	12.785	12.7893	12.7654	12.7654	14000.0
2011-07-08 06:00:00	AAPL	Stock	12.7493	12.7829	12.7493	12.7829	5600.0
2011-07-08 07:00:00	AAPL	Stock	12.7846	12.8107	12.775	12.7986	279244.0
2011-07-08 08:00:00	AAPL	Stock	12.7914	12.8214	12.6071	12.6096	7021336.0
2011-07-08 09:00:00	AAPL	Stock	12.6089	12.8382	12.5786	12.8299	122999296.0
2011-07-08 10:00:00	AAPL	Stock	12.8311	12.8532	12.7621	12.8079	108836056.0
2011-07-08 11:00:00	AAPL	Stock	12.8068	12.8104	12.725	12.7843	67816168.0
2011-07-08 12:00:00	AAPL	Stock	12.785	12.8007	12.7679	12.7818	30738372.0
2011-07-08 13:00:00	AAPL	Stock	12.78	12.8036	12.7679	12.7832	30237060.0
2011-07-08 14:00:00	AAPL	Stock	12.7814	12.7971	12.7679	12.7836	23129792.0
2011-07-08 15:00:00	AAPL	Stock	12.7836	12.8571	12.7757	12.8471	83277124.0
2011-07-08 16:00:00	AAPL	Stock	12.8468	12.8604	12.7828	12.8571	7958496.0
2011-07-08 17:00:00	AAPL	Stock	12.8575	12.8611	12.8554	12.8571	410032.0
2011-07-08 18:00:00	AAPL	Stock	12.8607	12.8625	12.8468	12.8625	356020.0
2011-07-08 19:00:00	AAPL	Stock	12.8571	12.8643	12.8571	12.8643	124852.0
2011-07-08 05:00:00	MSFT	Stock	26.66	26.66	26.66	26.66	400.0
2011-07-08 06:00:00	MSFT	Stock	26.61	26.61	26.61	26.61	300.0
2011-07-08 07:00:00	MSFT	Stock	26.78	26.81	26.78	26.81	1578.0
2011-07-08 08:00:00	MSFT	Stock	26.8	26.91	26.4	26.42	180142.0
2011-07-08 09:00:00	MSFT	Stock	26.45	26.98	26.36	26.913	12439812.0
2011-07-08 10:00:00	MSFT	Stock	26.91	26.93	26.61	26.62	10687197.0
2011-07-08 11:00:00	MSFT	Stock	26.62	26.64	26.53	26.56	5652051.0
2011-07-08 12:00:00	MSFT	Stock	26.563	26.75	26.545	26.72	4803922.0
2011-07-08 13:00:00	MSFT	Stock	26.71	26.8	26.61	26.71	5694963.0
2011-07-08 14:00:00	MSFT	Stock	26.71	26.88	26.7	26.81	6201691.0
2011-07-08 15:00:00	MSFT	Stock	26.805	26.94	26.788	26.93	9826523.0
2011-07-08 16:00:00	MSFT	Stock	26.92	26.98	26.749	26.96	1887559.0
2011-07-08 17:00:00	MSFT	Stock	26.97	26.98	26.96	26.96	11943.0
2011-07-08 18:00:00	MSFT	Stock	26.96	26.96	26.9	26.92	41174.0
2011-07-08 19:00:00	MSFT	Stock	26.91	26.94	26.91	26.92	3210.0
2011-07-08 07:00:00	NVDA	Stock	0.3862	0.3913	0.3862	0.3913	88000.0
2011-07-08 08:00:00	NVDA	Stock	0.3913	0.3925	0.3875	0.3875	1129960.0
2011-07-08 09:00:00	NVDA	Stock	0.3875	0.3905	0.3858	0.3871	68597560.0
2011-07-08 10:00:00	NVDA	Stock	0.3871	0.3875	0.383	0.3856	105999960.0
2011-07-08 11:00:00	NVDA	Stock	0.3858	0.3858	0.3833	0.3844	69088840.0
2011-07-08 12:00:00	NVDA	Stock	0.3842	0.3845	0.3825	0.3838	89640400.0
2011-07-08 13:00:00	NVDA	Stock	0.3835	0.3845	0.383	0.3835	68344520.0
2011-07-08 14:00:00	NVDA	Stock	0.3835	0.3842	0.3825	0.384	69021480.0
2011-07-08 15:00:00	NVDA	Stock	0.384	0.3865	0.3838	0.3858	128291120.0
2011-07-08 16:00:00	NVDA	Stock	0.3858	0.3859	0.3846	0.3846	16064480.0
2011-07-08 17:00:00	NVDA	Stock	0.3858	0.3858	0.3853	0.3853	84000.0
2011-07-08 18:00:00	NVDA	Stock	0.3853	0.3853	0.3853	0.3853	4000.0
2011-07-08 19:00:00	NVDA	Stock	0.3855	0.3858	0.3855	0.3858	12000.0
2011-07-08 07:00:00	AMZN	Stock	10.835	10.875	10.835	10.875	22000.0
2011-07-08 08:00:00	AMZN	Stock	10.85	10.886	10.657	10.68	423500.0
2011-07-08 09:00:00	AMZN	Stock	10.675	10.8205	10.636	10.798	13912660.0
2011-07-08 10:00:00	AMZN	Stock	10.7972	10.803	10.721	10.7675	13175780.0
2011-07-08 11:00:00	AMZN	Stock	10.7675	10.7685	10.688	10.7505	10987680.0
2011-07-08 12:00:00	AMZN	Stock	10.7505	10.796	10.729	10.7805	6043280.0

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

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