PREVIEW / stock_1hour / 2014-02-21

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-21.parquet
  size:    1.0 MB
  rows:    47,752
  symbols: 3,541

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
2014-02-21 04:00:00	AAPL	Stock	19.0	19.0	19.0	19.0	2800.0
2014-02-21 06:00:00	AAPL	Stock	19.0268	19.0357	19.0214	19.0261	14000.0
2014-02-21 07:00:00	AAPL	Stock	19.0236	19.035	19.0179	19.035	58184.0
2014-02-21 08:00:00	AAPL	Stock	19.0229	19.0411	18.9764	18.9857	766696.0
2014-02-21 09:00:00	AAPL	Stock	18.9957	19.0918	18.9857	19.022	52753064.0
2014-02-21 10:00:00	AAPL	Stock	19.0236	19.0357	18.9079	18.9079	33778136.0
2014-02-21 11:00:00	AAPL	Stock	18.9082	18.9082	18.7996	18.8639	42805420.0
2014-02-21 12:00:00	AAPL	Stock	18.8643	18.8789	18.7793	18.8136	20228292.0
2014-02-21 13:00:00	AAPL	Stock	18.8136	18.8486	18.8036	18.8232	12387256.0
2014-02-21 14:00:00	AAPL	Stock	18.8257	18.8482	18.7825	18.8114	17143224.0
2014-02-21 15:00:00	AAPL	Stock	18.8132	18.815	18.7357	18.7586	44893044.0
2014-02-21 16:00:00	AAPL	Stock	18.7589	18.9696	18.75	18.7529	6751948.0
2014-02-21 17:00:00	AAPL	Stock	18.75	18.7518	18.7418	18.7489	425740.0
2014-02-21 18:00:00	AAPL	Stock	18.7464	18.7589	18.7432	18.7446	89348.0
2014-02-21 19:00:00	AAPL	Stock	18.7446	18.7496	18.7425	18.7496	69720.0
2014-02-21 07:00:00	MSFT	Stock	37.9	37.91	37.87	37.87	1700.0
2014-02-21 08:00:00	MSFT	Stock	37.78	37.9	37.65	37.7	15376.0
2014-02-21 09:00:00	MSFT	Stock	37.71	38.18	37.67	38.09	10216933.0
2014-02-21 10:00:00	MSFT	Stock	38.09	38.3	38.05	38.27	5367320.0
2014-02-21 11:00:00	MSFT	Stock	38.27	38.35	38.09	38.095	4761286.0
2014-02-21 12:00:00	MSFT	Stock	38.095	38.14	38.03	38.1	3150118.0
2014-02-21 13:00:00	MSFT	Stock	38.1	38.23	38.1	38.15	2805328.0
2014-02-21 14:00:00	MSFT	Stock	38.15	38.18	37.97	37.999	3064742.0
2014-02-21 15:00:00	MSFT	Stock	37.99	38.06	37.95	37.98	5663384.0
2014-02-21 16:00:00	MSFT	Stock	37.99	38.17	37.978	37.98	1847289.0
2014-02-21 17:00:00	MSFT	Stock	37.98	38.02	37.96	38.02	53664.0
2014-02-21 18:00:00	MSFT	Stock	37.98	37.98	37.98	37.98	6859.0
2014-02-21 19:00:00	MSFT	Stock	38.02	38.02	37.95	37.95	2508.0
2014-02-21 09:00:00	NVDA	Stock	0.47	0.4748	0.4685	0.4728	68734800.0
2014-02-21 10:00:00	NVDA	Stock	0.4728	0.4738	0.468	0.4692	52723200.0
2014-02-21 11:00:00	NVDA	Stock	0.469	0.4692	0.463	0.4659	56809280.0
2014-02-21 12:00:00	NVDA	Stock	0.4658	0.4675	0.465	0.466	26644640.0
2014-02-21 13:00:00	NVDA	Stock	0.466	0.4705	0.4655	0.468	43070240.0
2014-02-21 14:00:00	NVDA	Stock	0.4683	0.4683	0.4633	0.4655	48622400.0
2014-02-21 15:00:00	NVDA	Stock	0.4654	0.4685	0.4654	0.466	88444400.0
2014-02-21 16:00:00	NVDA	Stock	0.4662	0.4662	0.4658	0.466	2227600.0
2014-02-21 17:00:00	NVDA	Stock	0.4668	0.4668	0.4668	0.4668	12000.0
2014-02-21 04:00:00	AMZN	Stock	17.54	17.567	17.54	17.5655	12100.0
2014-02-21 05:00:00	AMZN	Stock	17.675	17.675	17.675	17.675	2000.0
2014-02-21 06:00:00	AMZN	Stock	17.689	17.689	17.689	17.689	2000.0
2014-02-21 07:00:00	AMZN	Stock	17.675	17.675	17.6175	17.6175	24960.0
2014-02-21 08:00:00	AMZN	Stock	17.589	17.6085	17.575	17.575	128700.0
2014-02-21 09:00:00	AMZN	Stock	17.585	17.7071	17.571	17.668	17864640.0
2014-02-21 10:00:00	AMZN	Stock	17.6675	17.6915	17.5175	17.55	13835420.0
2014-02-21 11:00:00	AMZN	Stock	17.55	17.6165	17.463	17.4795	10989460.0
2014-02-21 12:00:00	AMZN	Stock	17.489	17.494	17.3885	17.389	6683820.0
2014-02-21 13:00:00	AMZN	Stock	17.3947	17.445	17.3762	17.4188	6015760.0
2014-02-21 14:00:00	AMZN	Stock	17.4135	17.431	17.348	17.3705	8741500.0
2014-02-21 15:00:00	AMZN	Stock	17.372	17.4245	17.3375	17.3485	11270980.0
2014-02-21 16:00:00	AMZN	Stock	17.338	17.5128	17.328	17.338	511400.0

> showing 50 of 47,752 rows — these rows as CSV

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