PREVIEW / stock_1hour / 2011-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-13.parquet
  size:    898 KB
  rows:    43,160
  symbols: 3,486

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
2011-10-13 04:00:00	AAPL	Stock	14.4343	14.4343	14.3689	14.37	42980.0
2011-10-13 05:00:00	AAPL	Stock	14.37	14.37	14.3571	14.3571	8400.0
2011-10-13 06:00:00	AAPL	Stock	14.3414	14.3571	14.3414	14.3571	11900.0
2011-10-13 07:00:00	AAPL	Stock	14.3464	14.35	14.3111	14.3361	336420.0
2011-10-13 08:00:00	AAPL	Stock	14.3268	14.4886	14.3161	14.4607	5073040.0
2011-10-13 09:00:00	AAPL	Stock	14.4625	14.5054	14.3875	14.455	79202032.0
2011-10-13 10:00:00	AAPL	Stock	14.4543	14.5321	14.4268	14.4561	77596120.0
2011-10-13 11:00:00	AAPL	Stock	14.4514	14.5546	14.4514	14.5282	46690224.0
2011-10-13 12:00:00	AAPL	Stock	14.5282	14.5475	14.4968	14.5157	27920172.0
2011-10-13 13:00:00	AAPL	Stock	14.5157	14.5184	14.4439	14.4857	35038416.0
2011-10-13 14:00:00	AAPL	Stock	14.4879	14.5418	14.4529	14.5239	36243004.0
2011-10-13 15:00:00	AAPL	Stock	14.5218	14.5868	14.5179	14.5864	77297192.0
2011-10-13 16:00:00	AAPL	Stock	14.5868	14.7143	14.4628	14.7046	32329332.0
2011-10-13 17:00:00	AAPL	Stock	14.71	14.7739	14.5868	14.7504	2709420.0
2011-10-13 18:00:00	AAPL	Stock	14.7536	14.7843	14.5868	14.7643	1400000.0
2011-10-13 19:00:00	AAPL	Stock	14.7707	14.7707	14.75	14.75	552636.0
2011-10-13 08:00:00	MSFT	Stock	26.78	26.85	26.75	26.83	7900.0
2011-10-13 09:00:00	MSFT	Stock	26.83	26.96	26.62	26.77	6114463.0
2011-10-13 10:00:00	MSFT	Stock	26.77	26.95	26.75	26.93	8734885.0
2011-10-13 11:00:00	MSFT	Stock	26.93	27.07	26.89	27.025	4556392.0
2011-10-13 12:00:00	MSFT	Stock	27.025	27.075	26.96	27.0	4318994.0
2011-10-13 13:00:00	MSFT	Stock	27.005	27.1	26.965	27.07	3542282.0
2011-10-13 14:00:00	MSFT	Stock	27.06	27.165	27.03	27.14	4174068.0
2011-10-13 15:00:00	MSFT	Stock	27.145	27.2	27.015	27.18	8884398.0
2011-10-13 16:00:00	MSFT	Stock	27.18	27.25	26.961	27.12	2864329.0
2011-10-13 17:00:00	MSFT	Stock	27.15	27.18	27.15	27.17	15406.0
2011-10-13 18:00:00	MSFT	Stock	27.17	27.18	27.14	27.16	18307.0
2011-10-13 19:00:00	MSFT	Stock	27.11	27.18	27.11	27.18	5150.0
2011-10-13 08:00:00	NVDA	Stock	0.3608	0.3625	0.36	0.3625	132000.0
2011-10-13 09:00:00	NVDA	Stock	0.3642	0.3758	0.3625	0.3748	132822080.0
2011-10-13 10:00:00	NVDA	Stock	0.3748	0.3868	0.374	0.3795	217809080.0
2011-10-13 11:00:00	NVDA	Stock	0.3798	0.3825	0.3765	0.3815	93974400.0
2011-10-13 12:00:00	NVDA	Stock	0.3815	0.3833	0.3785	0.3823	71306680.0
2011-10-13 13:00:00	NVDA	Stock	0.3825	0.385	0.3803	0.382	61139800.0
2011-10-13 14:00:00	NVDA	Stock	0.3822	0.3868	0.3815	0.3868	64064080.0
2011-10-13 15:00:00	NVDA	Stock	0.3866	0.3873	0.384	0.3862	163653600.0
2011-10-13 16:00:00	NVDA	Stock	0.3862	0.3875	0.3804	0.3855	27383160.0
2011-10-13 17:00:00	NVDA	Stock	0.3865	0.3865	0.3853	0.3858	254520.0
2011-10-13 18:00:00	NVDA	Stock	0.3862	0.3935	0.3862	0.392	645400.0
2011-10-13 19:00:00	NVDA	Stock	0.3925	0.3925	0.39	0.3913	524320.0
2011-10-13 05:00:00	AMZN	Stock	11.8435	11.8435	11.8435	11.8435	2000.0
2011-10-13 07:00:00	AMZN	Stock	11.7905	11.7905	11.7905	11.7905	2000.0
2011-10-13 08:00:00	AMZN	Stock	11.7865	11.8895	11.7635	11.85	113400.0
2011-10-13 09:00:00	AMZN	Stock	11.855	11.9375	11.7755	11.9	16319240.0
2011-10-13 10:00:00	AMZN	Stock	11.893	11.984	11.8535	11.8547	15409420.0
2011-10-13 11:00:00	AMZN	Stock	11.8535	11.943	11.833	11.875	12169120.0
2011-10-13 12:00:00	AMZN	Stock	11.881	11.9035	11.82	11.8685	4378100.0
2011-10-13 13:00:00	AMZN	Stock	11.864	11.948	11.8205	11.875	9227840.0
2011-10-13 14:00:00	AMZN	Stock	11.8785	11.941	11.8385	11.878	11147720.0
2011-10-13 15:00:00	AMZN	Stock	11.878	11.924	11.7615	11.807	23401040.0

> showing 50 of 43,160 rows — these rows as CSV

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