PREVIEW / stock_1hour / 2013-10-08

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-08.parquet
  size:    1.0 MB
  rows:    48,166
  symbols: 3,520

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
2013-10-08 04:00:00	AAPL	Stock	17.4196	17.4196	17.4196	17.4196	2800.0
2013-10-08 06:00:00	AAPL	Stock	17.4021	17.4279	17.4021	17.4279	8400.0
2013-10-08 07:00:00	AAPL	Stock	17.4286	17.4439	17.3929	17.4439	238840.0
2013-10-08 08:00:00	AAPL	Stock	17.4511	17.5075	17.3929	17.4779	1972432.0
2013-10-08 09:00:00	AAPL	Stock	17.4811	17.5089	17.3968	17.4782	46523120.0
2013-10-08 10:00:00	AAPL	Stock	17.4768	17.5229	17.3086	17.33	69408612.0
2013-10-08 11:00:00	AAPL	Stock	17.3286	17.3382	17.1982	17.27	50319528.0
2013-10-08 12:00:00	AAPL	Stock	17.2693	17.27	17.1868	17.2536	27713448.0
2013-10-08 13:00:00	AAPL	Stock	17.2514	17.2764	17.1964	17.2054	19670504.0
2013-10-08 14:00:00	AAPL	Stock	17.2054	17.2379	17.1679	17.2125	21988176.0
2013-10-08 15:00:00	AAPL	Stock	17.2125	17.2482	17.1621	17.1789	37082640.0
2013-10-08 16:00:00	AAPL	Stock	17.1764	17.3185	17.1763	17.2429	8931720.0
2013-10-08 17:00:00	AAPL	Stock	17.2293	17.25	17.1764	17.2143	732564.0
2013-10-08 18:00:00	AAPL	Stock	17.2289	17.25	17.1764	17.25	820176.0
2013-10-08 19:00:00	AAPL	Stock	17.2436	17.275	17.2429	17.2714	871304.0
2013-10-08 08:00:00	MSFT	Stock	33.31	33.42	33.31	33.37	7290.0
2013-10-08 09:00:00	MSFT	Stock	33.37	33.42	33.01	33.21	6891152.0
2013-10-08 10:00:00	MSFT	Stock	33.2	33.22	32.9	32.94	5370746.0
2013-10-08 11:00:00	MSFT	Stock	32.93	33.12	32.82	32.91	5825777.0
2013-10-08 12:00:00	MSFT	Stock	32.91	33.006	32.8	33.0	3265536.0
2013-10-08 13:00:00	MSFT	Stock	32.995	33.07	32.89	32.92	3596978.0
2013-10-08 14:00:00	MSFT	Stock	32.915	32.96	32.8	32.96	3999750.0
2013-10-08 15:00:00	MSFT	Stock	32.965	33.16	32.95	33.0	7562805.0
2013-10-08 16:00:00	MSFT	Stock	33.01	33.11	32.92	33.01	2335835.0
2013-10-08 17:00:00	MSFT	Stock	33.03	33.05	33.01	33.03	100577.0
2013-10-08 18:00:00	MSFT	Stock	33.02	33.05	33.01	33.01	16697.0
2013-10-08 19:00:00	MSFT	Stock	33.05	33.12	33.05	33.11	45400.0
2013-10-08 09:00:00	NVDA	Stock	0.3888	0.393	0.3888	0.3921	30196400.0
2013-10-08 10:00:00	NVDA	Stock	0.3922	0.3942	0.3875	0.3878	54022640.0
2013-10-08 11:00:00	NVDA	Stock	0.3878	0.3882	0.3848	0.3868	36738880.0
2013-10-08 12:00:00	NVDA	Stock	0.3868	0.3868	0.3835	0.3858	27581040.0
2013-10-08 13:00:00	NVDA	Stock	0.3856	0.3873	0.3848	0.3865	24057680.0
2013-10-08 14:00:00	NVDA	Stock	0.3866	0.3882	0.3859	0.3882	35319720.0
2013-10-08 15:00:00	NVDA	Stock	0.3882	0.389	0.3865	0.3868	66261320.0
2013-10-08 16:00:00	NVDA	Stock	0.3865	0.3884	0.3858	0.3865	6829680.0
2013-10-08 17:00:00	NVDA	Stock	0.3865	0.3865	0.3855	0.3855	90600.0
2013-10-08 04:00:00	AMZN	Stock	15.55	15.55	15.526	15.526	4000.0
2013-10-08 07:00:00	AMZN	Stock	15.6	15.6	15.587	15.587	6000.0
2013-10-08 08:00:00	AMZN	Stock	15.5925	15.6395	15.5925	15.618	85420.0
2013-10-08 09:00:00	AMZN	Stock	15.624	15.632	15.3405	15.422	12605460.0
2013-10-08 10:00:00	AMZN	Stock	15.422	15.456	15.1515	15.172	12392180.0
2013-10-08 11:00:00	AMZN	Stock	15.1685	15.2495	15.05	15.1375	9915780.0
2013-10-08 12:00:00	AMZN	Stock	15.1335	15.1785	15.0135	15.125	5340880.0
2013-10-08 13:00:00	AMZN	Stock	15.134	15.1645	15.0635	15.0845	3852260.0
2013-10-08 14:00:00	AMZN	Stock	15.0785	15.168	15.061	15.157	6280280.0
2013-10-08 15:00:00	AMZN	Stock	15.157	15.235	15.1065	15.1615	9537860.0
2013-10-08 16:00:00	AMZN	Stock	15.1615	15.2211	15.119	15.1325	535940.0
2013-10-08 17:00:00	AMZN	Stock	15.144	15.1615	15.1215	15.1615	30640.0
2013-10-08 18:00:00	AMZN	Stock	15.142	15.206	15.142	15.1615	102960.0
2013-10-08 19:00:00	AMZN	Stock	15.1885	15.206	15.1885	15.206	4000.0

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

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