PREVIEW / stock_1hour / 2014-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-21.parquet
  size:    1.1 MB
  rows:    49,110
  symbols: 3,553

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-01-21 04:00:00	AAPL	Stock	19.3107	19.3929	19.3107	19.37	46424.0
2014-01-21 05:00:00	AAPL	Stock	19.3704	19.4161	19.3704	19.4132	136976.0
2014-01-21 06:00:00	AAPL	Stock	19.4093	19.4179	19.3929	19.3932	80024.0
2014-01-21 07:00:00	AAPL	Stock	19.3968	19.4279	19.2614	19.2714	754404.0
2014-01-21 08:00:00	AAPL	Stock	19.275	19.3954	19.2593	19.3304	2359140.0
2014-01-21 09:00:00	AAPL	Stock	19.3304	19.5725	19.3007	19.5286	62603380.0
2014-01-21 10:00:00	AAPL	Stock	19.5286	19.5607	19.4029	19.4946	44680720.0
2014-01-21 11:00:00	AAPL	Stock	19.4857	19.5354	19.3496	19.5155	32521188.0
2014-01-21 12:00:00	AAPL	Stock	19.5155	19.6246	19.4725	19.6143	37644012.0
2014-01-21 13:00:00	AAPL	Stock	19.6136	19.6454	19.5868	19.6218	28009212.0
2014-01-21 14:00:00	AAPL	Stock	19.6229	19.6446	19.5982	19.6281	18111044.0
2014-01-21 15:00:00	AAPL	Stock	19.6243	19.6429	19.5718	19.6071	33516868.0
2014-01-21 16:00:00	AAPL	Stock	19.6096	19.6139	19.3331	19.6104	14594356.0
2014-01-21 17:00:00	AAPL	Stock	19.6071	19.6096	19.5943	19.6068	829808.0
2014-01-21 18:00:00	AAPL	Stock	19.5946	19.6096	19.5936	19.6032	244356.0
2014-01-21 19:00:00	AAPL	Stock	19.6	19.6196	19.5982	19.6196	259168.0
2014-01-21 05:00:00	MSFT	Stock	36.51	36.51	36.51	36.51	500.0
2014-01-21 07:00:00	MSFT	Stock	36.65	36.65	36.64	36.64	800.0
2014-01-21 08:00:00	MSFT	Stock	36.54	36.65	36.5	36.65	7784.0
2014-01-21 09:00:00	MSFT	Stock	36.65	36.82	36.55	36.685	3698647.0
2014-01-21 10:00:00	MSFT	Stock	36.68	36.72	36.45	36.57	3732201.0
2014-01-21 11:00:00	MSFT	Stock	36.57	36.61	36.1	36.125	5522282.0
2014-01-21 12:00:00	MSFT	Stock	36.123	36.23	36.06	36.146	2739284.0
2014-01-21 13:00:00	MSFT	Stock	36.14	36.24	36.1	36.217	2555379.0
2014-01-21 14:00:00	MSFT	Stock	36.216	36.3	36.2	36.215	2209912.0
2014-01-21 15:00:00	MSFT	Stock	36.215	36.22	36.1	36.16	5930903.0
2014-01-21 16:00:00	MSFT	Stock	36.16	36.458	36.08	36.08	2892745.0
2014-01-21 17:00:00	MSFT	Stock	36.16	36.186	36.08	36.16	453068.0
2014-01-21 18:00:00	MSFT	Stock	36.12	36.17	36.08	36.09	13155.0
2014-01-21 19:00:00	MSFT	Stock	36.09	36.09	36.09	36.09	378.0
2014-01-21 04:00:00	NVDA	Stock	0.4038	0.4038	0.4038	0.4038	20000.0
2014-01-21 08:00:00	NVDA	Stock	0.405	0.405	0.405	0.405	8000.0
2014-01-21 09:00:00	NVDA	Stock	0.4053	0.4053	0.3988	0.399	49590320.0
2014-01-21 10:00:00	NVDA	Stock	0.3989	0.4005	0.398	0.3988	24972600.0
2014-01-21 11:00:00	NVDA	Stock	0.3989	0.3995	0.397	0.399	22881480.0
2014-01-21 12:00:00	NVDA	Stock	0.3993	0.4008	0.3988	0.4005	10596400.0
2014-01-21 13:00:00	NVDA	Stock	0.4005	0.4013	0.3998	0.3998	29280520.0
2014-01-21 14:00:00	NVDA	Stock	0.3998	0.4013	0.3993	0.4005	19828760.0
2014-01-21 15:00:00	NVDA	Stock	0.4004	0.4015	0.399	0.4011	54221280.0
2014-01-21 16:00:00	NVDA	Stock	0.4013	0.4015	0.4004	0.4013	31602640.0
2014-01-21 17:00:00	NVDA	Stock	0.4013	0.4013	0.4013	0.4013	80000.0
2014-01-21 07:00:00	AMZN	Stock	20.11	20.11	20.05	20.05	12500.0
2014-01-21 08:00:00	AMZN	Stock	20.087	20.087	20.05	20.05	54760.0
2014-01-21 09:00:00	AMZN	Stock	20.075	20.284	20.075	20.2055	10715260.0
2014-01-21 10:00:00	AMZN	Stock	20.2025	20.262	20.112	20.225	9621400.0
2014-01-21 11:00:00	AMZN	Stock	20.224	20.2605	20.0912	20.195	6621340.0
2014-01-21 12:00:00	AMZN	Stock	20.1945	20.2495	20.105	20.2248	5584220.0
2014-01-21 13:00:00	AMZN	Stock	20.2295	20.2795	20.2025	20.2595	3969540.0
2014-01-21 14:00:00	AMZN	Stock	20.268	20.39	20.225	20.358	8760020.0
2014-01-21 15:00:00	AMZN	Stock	20.3645	20.3845	20.275	20.353	8966240.0

> showing 50 of 49,110 rows — these rows as CSV

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