PREVIEW / stock_1hour / 2014-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-02.parquet
  size:    1.0 MB
  rows:    48,405
  symbols: 3,542

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-04-02 04:00:00	AAPL	Stock	19.3911	19.3961	19.3911	19.3961	11200.0
2014-04-02 05:00:00	AAPL	Stock	19.3929	19.3929	19.3757	19.3757	17360.0
2014-04-02 06:00:00	AAPL	Stock	19.3575	19.3911	19.3575	19.3807	35000.0
2014-04-02 07:00:00	AAPL	Stock	19.3804	19.4018	19.3571	19.3575	140812.0
2014-04-02 08:00:00	AAPL	Stock	19.3643	19.4021	19.3471	19.3639	804832.0
2014-04-02 09:00:00	AAPL	Stock	19.3668	19.3989	19.2961	19.3036	30882180.0
2014-04-02 10:00:00	AAPL	Stock	19.3036	19.3611	19.2968	19.32	23940420.0
2014-04-02 11:00:00	AAPL	Stock	19.32	19.3729	19.3143	19.3611	15058988.0
2014-04-02 12:00:00	AAPL	Stock	19.3614	19.38	19.3229	19.3779	15003884.0
2014-04-02 13:00:00	AAPL	Stock	19.3782	19.3789	19.295	19.3268	12129488.0
2014-04-02 14:00:00	AAPL	Stock	19.3275	19.3564	19.3086	19.3521	10263064.0
2014-04-02 15:00:00	AAPL	Stock	19.3525	19.41	19.3521	19.3789	28710472.0
2014-04-02 16:00:00	AAPL	Stock	19.3768	19.3814	19.3372	19.3625	7542416.0
2014-04-02 17:00:00	AAPL	Stock	19.3729	19.3768	19.3282	19.3696	242844.0
2014-04-02 18:00:00	AAPL	Stock	19.3661	19.3893	19.3393	19.3393	651168.0
2014-04-02 19:00:00	AAPL	Stock	19.3564	19.3929	19.3561	19.3839	414512.0
2014-04-02 06:00:00	MSFT	Stock	41.44	41.58	41.4	41.58	1585.0
2014-04-02 07:00:00	MSFT	Stock	41.52	41.62	41.52	41.62	13880.0
2014-04-02 08:00:00	MSFT	Stock	41.6	41.63	41.3	41.53	19846.0
2014-04-02 09:00:00	MSFT	Stock	41.51	41.66	41.325	41.35	4844634.0
2014-04-02 10:00:00	MSFT	Stock	41.34	41.39	41.17	41.33	3756263.0
2014-04-02 11:00:00	MSFT	Stock	41.337	41.37	41.2	41.28	2633733.0
2014-04-02 12:00:00	MSFT	Stock	41.285	41.291	41.21	41.25	1761064.0
2014-04-02 13:00:00	MSFT	Stock	41.259	41.35	41.22	41.295	2690839.0
2014-04-02 14:00:00	MSFT	Stock	41.3	41.37	41.22	41.35	2574705.0
2014-04-02 15:00:00	MSFT	Stock	41.34	41.41	41.28	41.35	6715796.0
2014-04-02 16:00:00	MSFT	Stock	41.35	41.448	41.25	41.25	2343420.0
2014-04-02 17:00:00	MSFT	Stock	41.342	41.46	41.342	41.4	47208.0
2014-04-02 18:00:00	MSFT	Stock	41.4	41.43	41.35	41.37	44528.0
2014-04-02 19:00:00	MSFT	Stock	41.38	41.4	41.37	41.4	2355.0
2014-04-02 08:00:00	NVDA	Stock	0.4688	0.4688	0.4662	0.4662	19200.0
2014-04-02 09:00:00	NVDA	Stock	0.4662	0.4668	0.4612	0.4625	30886440.0
2014-04-02 10:00:00	NVDA	Stock	0.4625	0.467	0.462	0.4662	36420720.0
2014-04-02 11:00:00	NVDA	Stock	0.466	0.4668	0.463	0.4645	21453600.0
2014-04-02 12:00:00	NVDA	Stock	0.4645	0.4673	0.464	0.465	24586560.0
2014-04-02 13:00:00	NVDA	Stock	0.465	0.4652	0.4615	0.463	16245920.0
2014-04-02 14:00:00	NVDA	Stock	0.4629	0.464	0.4622	0.4639	21517280.0
2014-04-02 15:00:00	NVDA	Stock	0.4639	0.464	0.4625	0.4633	68402920.0
2014-04-02 16:00:00	NVDA	Stock	0.4633	0.4644	0.4629	0.4633	12691880.0
2014-04-02 17:00:00	NVDA	Stock	0.4632	0.4633	0.4632	0.4633	101680.0
2014-04-02 07:00:00	AMZN	Stock	17.2895	17.3	17.262	17.275	33600.0
2014-04-02 08:00:00	AMZN	Stock	17.3	17.3	17.25	17.2685	178960.0
2014-04-02 09:00:00	AMZN	Stock	17.286	17.4148	17.1495	17.1565	15009860.0
2014-04-02 10:00:00	AMZN	Stock	17.159	17.2405	17.0845	17.17	11979180.0
2014-04-02 11:00:00	AMZN	Stock	17.1849	17.295	17.1355	17.2455	14678080.0
2014-04-02 12:00:00	AMZN	Stock	17.2433	17.255	17.1365	17.2222	6281700.0
2014-04-02 13:00:00	AMZN	Stock	17.2145	17.231	17.094	17.137	5950120.0
2014-04-02 14:00:00	AMZN	Stock	17.134	17.1415	17.019	17.0785	7620320.0
2014-04-02 15:00:00	AMZN	Stock	17.0875	17.1715	17.081	17.0945	17768460.0
2014-04-02 16:00:00	AMZN	Stock	17.098	17.1797	17.05	17.0565	3388640.0

> showing 50 of 48,405 rows — these rows as CSV

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