PREVIEW / stock_1hour / 2013-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-10.parquet
  size:    1.0 MB
  rows:    48,690
  symbols: 3,537

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-10 04:00:00	AAPL	Stock	17.4707	17.5064	17.4707	17.5011	23716.0
2013-10-10 05:00:00	AAPL	Stock	17.5068	17.5068	17.4732	17.4946	131600.0
2013-10-10 06:00:00	AAPL	Stock	17.4821	17.5179	17.4821	17.5146	216692.0
2013-10-10 07:00:00	AAPL	Stock	17.5104	17.5643	17.5039	17.5557	1808352.0
2013-10-10 08:00:00	AAPL	Stock	17.5529	17.5668	17.3571	17.5393	3910788.0
2013-10-10 09:00:00	AAPL	Stock	17.5379	17.5804	17.3943	17.4736	60280584.0
2013-10-10 10:00:00	AAPL	Stock	17.4721	17.5482	17.415	17.5239	51674448.0
2013-10-10 11:00:00	AAPL	Stock	17.5211	17.5793	17.4836	17.5718	35502096.0
2013-10-10 12:00:00	AAPL	Stock	17.5714	17.585	17.5254	17.5436	21809480.0
2013-10-10 13:00:00	AAPL	Stock	17.54	17.5421	17.4683	17.519	17947104.0
2013-10-10 14:00:00	AAPL	Stock	17.5213	17.5225	17.4086	17.4675	32194372.0
2013-10-10 15:00:00	AAPL	Stock	17.4668	17.5196	17.4661	17.4957	39506348.0
2013-10-10 16:00:00	AAPL	Stock	17.4957	17.5465	17.3781	17.4804	9764328.0
2013-10-10 17:00:00	AAPL	Stock	17.4689	17.4964	17.4482	17.4532	511644.0
2013-10-10 18:00:00	AAPL	Stock	17.4507	17.4507	17.3661	17.3821	986496.0
2013-10-10 19:00:00	AAPL	Stock	17.3989	17.4232	17.3839	17.4071	574168.0
2013-10-10 04:00:00	MSFT	Stock	33.12	33.12	33.12	33.12	100.0
2013-10-10 06:00:00	MSFT	Stock	33.29	33.3	33.29	33.3	700.0
2013-10-10 07:00:00	MSFT	Stock	33.3	33.35	33.06	33.25	12200.0
2013-10-10 08:00:00	MSFT	Stock	33.29	33.29	33.16	33.27	8490.0
2013-10-10 09:00:00	MSFT	Stock	33.28	33.55	33.26	33.422	4813387.0
2013-10-10 10:00:00	MSFT	Stock	33.43	33.59	33.34	33.44	6048474.0
2013-10-10 11:00:00	MSFT	Stock	33.44	33.49	33.32	33.46	5944838.0
2013-10-10 12:00:00	MSFT	Stock	33.46	33.49	33.37	33.48	2351444.0
2013-10-10 13:00:00	MSFT	Stock	33.48	33.51	33.34	33.36	3383998.0
2013-10-10 14:00:00	MSFT	Stock	33.36	33.67	33.26	33.67	4994258.0
2013-10-10 15:00:00	MSFT	Stock	33.67	33.89	33.65	33.75	11149053.0
2013-10-10 16:00:00	MSFT	Stock	33.77	33.868	33.07	33.66	3345214.0
2013-10-10 17:00:00	MSFT	Stock	33.67	33.77	33.38	33.77	175875.0
2013-10-10 18:00:00	MSFT	Stock	33.7	33.7	33.6	33.7	3174.0
2013-10-10 19:00:00	MSFT	Stock	33.69	33.7	33.65	33.65	4191.0
2013-10-10 08:00:00	NVDA	Stock	0.3828	0.3828	0.3828	0.3828	4000.0
2013-10-10 09:00:00	NVDA	Stock	0.3833	0.3856	0.383	0.3834	26830320.0
2013-10-10 10:00:00	NVDA	Stock	0.3834	0.3844	0.3805	0.3822	33648640.0
2013-10-10 11:00:00	NVDA	Stock	0.3822	0.3838	0.3818	0.3838	40480720.0
2013-10-10 12:00:00	NVDA	Stock	0.3838	0.3842	0.3835	0.3841	10904760.0
2013-10-10 13:00:00	NVDA	Stock	0.3841	0.3841	0.383	0.3838	26009000.0
2013-10-10 14:00:00	NVDA	Stock	0.3835	0.384	0.383	0.3836	19080000.0
2013-10-10 15:00:00	NVDA	Stock	0.3835	0.3858	0.3835	0.3848	50485960.0
2013-10-10 16:00:00	NVDA	Stock	0.385	0.3853	0.3838	0.385	6141840.0
2013-10-10 17:00:00	NVDA	Stock	0.385	0.385	0.3822	0.3825	54760.0
2013-10-10 19:00:00	NVDA	Stock	0.3825	0.3825	0.3825	0.3825	8000.0
2013-10-10 05:00:00	AMZN	Stock	15.0615	15.116	15.0615	15.116	29000.0
2013-10-10 06:00:00	AMZN	Stock	15.1015	15.1015	15.1015	15.1015	2000.0
2013-10-10 07:00:00	AMZN	Stock	15.104	15.15	15.104	15.15	16000.0
2013-10-10 08:00:00	AMZN	Stock	15.142	15.1795	15.125	15.153	217100.0
2013-10-10 09:00:00	AMZN	Stock	15.178	15.325	15.1735	15.2705	12030180.0
2013-10-10 10:00:00	AMZN	Stock	15.269	15.294	15.1295	15.25	11307100.0
2013-10-10 11:00:00	AMZN	Stock	15.2525	15.2615	15.1775	15.2435	5413700.0
2013-10-10 12:00:00	AMZN	Stock	15.25	15.2979	15.2	15.2328	3346700.0

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

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