PREVIEW / stock_1hour / 2012-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-24.parquet
  size:    947 KB
  rows:    44,448
  symbols: 3,544

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-02-24 04:00:00	AAPL	Stock	18.48	18.5514	18.48	18.5514	116200.0
2012-02-24 05:00:00	AAPL	Stock	18.5511	18.5714	18.5393	18.5571	113260.0
2012-02-24 06:00:00	AAPL	Stock	18.5393	18.5714	18.5357	18.54	51940.0
2012-02-24 07:00:00	AAPL	Stock	18.5411	18.5786	18.5	18.5	1329748.0
2012-02-24 08:00:00	AAPL	Stock	18.51	18.5639	18.4686	18.5125	2857848.0
2012-02-24 09:00:00	AAPL	Stock	18.5086	18.6107	18.5	18.5925	81356436.0
2012-02-24 10:00:00	AAPL	Stock	18.5861	18.5968	18.54	18.5718	62932016.0
2012-02-24 11:00:00	AAPL	Stock	18.5718	18.5893	18.5571	18.5721	36048796.0
2012-02-24 12:00:00	AAPL	Stock	18.5725	18.6611	18.5671	18.6318	51922332.0
2012-02-24 13:00:00	AAPL	Stock	18.6314	18.675	18.6086	18.6193	42007084.0
2012-02-24 14:00:00	AAPL	Stock	18.6168	18.6404	18.5621	18.6043	42616140.0
2012-02-24 15:00:00	AAPL	Stock	18.605	18.6646	18.5907	18.6557	71268456.0
2012-02-24 16:00:00	AAPL	Stock	18.6575	18.6614	18.6249	18.6357	8526784.0
2012-02-24 17:00:00	AAPL	Stock	18.6418	18.6464	18.6332	18.6446	134876.0
2012-02-24 18:00:00	AAPL	Stock	18.6446	18.6446	18.6393	18.6429	162092.0
2012-02-24 19:00:00	AAPL	Stock	18.6393	18.6536	18.6357	18.6432	169624.0
2012-02-24 07:00:00	MSFT	Stock	31.52	31.52	31.48	31.48	1000.0
2012-02-24 08:00:00	MSFT	Stock	31.45	31.47	31.45	31.47	1050.0
2012-02-24 09:00:00	MSFT	Stock	31.48	31.49	31.24	31.4	4603629.0
2012-02-24 10:00:00	MSFT	Stock	31.395	31.49	31.28	31.29	5448945.0
2012-02-24 11:00:00	MSFT	Stock	31.295	31.425	31.29	31.42	3541484.0
2012-02-24 12:00:00	MSFT	Stock	31.42	31.46	31.38	31.435	3342946.0
2012-02-24 13:00:00	MSFT	Stock	31.43	31.45	31.37	31.434	2581993.0
2012-02-24 14:00:00	MSFT	Stock	31.436	31.495	31.37	31.4	3681105.0
2012-02-24 15:00:00	MSFT	Stock	31.395	31.5	31.39	31.49	6360455.0
2012-02-24 16:00:00	MSFT	Stock	31.49	31.49	31.37	31.46	4804981.0
2012-02-24 17:00:00	MSFT	Stock	31.44	31.44	31.44	31.44	100.0
2012-02-24 18:00:00	MSFT	Stock	31.46	31.5	31.46	31.5	993.0
2012-02-24 19:00:00	MSFT	Stock	31.47	31.49	31.44	31.44	1470.0
2012-02-24 09:00:00	NVDA	Stock	0.398	0.3995	0.3948	0.3977	43047200.0
2012-02-24 10:00:00	NVDA	Stock	0.3975	0.3995	0.3945	0.3958	61000920.0
2012-02-24 11:00:00	NVDA	Stock	0.396	0.3978	0.3958	0.3975	30859120.0
2012-02-24 12:00:00	NVDA	Stock	0.3975	0.399	0.397	0.3985	33274920.0
2012-02-24 13:00:00	NVDA	Stock	0.3985	0.3988	0.3955	0.3962	34953600.0
2012-02-24 14:00:00	NVDA	Stock	0.3962	0.3973	0.3945	0.3946	39576280.0
2012-02-24 15:00:00	NVDA	Stock	0.3946	0.395	0.393	0.3948	107400440.0
2012-02-24 16:00:00	NVDA	Stock	0.3945	0.3978	0.3935	0.3935	1129120.0
2012-02-24 17:00:00	NVDA	Stock	0.3965	0.3965	0.3942	0.3942	48800.0
2012-02-24 18:00:00	NVDA	Stock	0.3942	0.3942	0.3942	0.3942	35200.0
2012-02-24 19:00:00	NVDA	Stock	0.3942	0.396	0.3942	0.3955	44800.0
2012-02-24 04:00:00	AMZN	Stock	8.9745	8.9745	8.9745	8.9745	2000.0
2012-02-24 06:00:00	AMZN	Stock	9.0075	9.0075	9.0075	9.0075	2000.0
2012-02-24 07:00:00	AMZN	Stock	9.002	9.0075	8.99	8.99	10000.0
2012-02-24 08:00:00	AMZN	Stock	8.99	9.0	8.983	9.0	149460.0
2012-02-24 09:00:00	AMZN	Stock	9.0	9.037	8.9355	8.947	15582540.0
2012-02-24 10:00:00	AMZN	Stock	8.94	9.015	8.9351	8.9925	12798420.0
2012-02-24 11:00:00	AMZN	Stock	8.993	9.019	8.9875	9.013	10504080.0
2012-02-24 12:00:00	AMZN	Stock	9.0145	9.025	8.9955	9.0085	5746020.0
2012-02-24 13:00:00	AMZN	Stock	9.007	9.015	8.9616	8.9655	7363920.0
2012-02-24 14:00:00	AMZN	Stock	8.966	8.984	8.9185	8.946	8118260.0

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

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