PREVIEW / stock_1hour / 2010-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-13.parquet
  size:    952 KB
  rows:    45,690
  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
2010-12-13 04:00:00	AAPL	Stock	11.4939	11.5639	11.4846	11.5357	274764.0
2010-12-13 05:00:00	AAPL	Stock	11.5357	11.5689	11.5357	11.5689	101304.0
2010-12-13 06:00:00	AAPL	Stock	11.5593	11.5893	11.5575	11.5846	155120.0
2010-12-13 07:00:00	AAPL	Stock	11.5957	11.5968	11.5514	11.5829	1717100.0
2010-12-13 08:00:00	AAPL	Stock	11.5793	11.5968	11.5368	11.5946	9352924.0
2010-12-13 09:00:00	AAPL	Stock	11.5939	11.6364	11.5468	11.5511	115413088.0
2010-12-13 10:00:00	AAPL	Stock	11.5514	11.6018	11.5511	11.5986	60973332.0
2010-12-13 11:00:00	AAPL	Stock	11.5986	11.6068	11.5825	11.5893	45576804.0
2010-12-13 12:00:00	AAPL	Stock	11.5893	11.6014	11.5786	11.5982	24649240.0
2010-12-13 13:00:00	AAPL	Stock	11.5971	11.5994	11.5721	11.5793	23464504.0
2010-12-13 14:00:00	AAPL	Stock	11.5784	11.595	11.5761	11.5789	32159652.0
2010-12-13 15:00:00	AAPL	Stock	11.5793	11.5814	11.4643	11.4857	103097540.0
2010-12-13 16:00:00	AAPL	Stock	11.4857	11.5689	11.4482	11.5079	11259024.0
2010-12-13 17:00:00	AAPL	Stock	11.5093	11.5214	11.5064	11.52	755888.0
2010-12-13 18:00:00	AAPL	Stock	11.5214	11.5229	11.4882	11.5054	368424.0
2010-12-13 19:00:00	AAPL	Stock	11.5036	11.5089	11.4982	11.5054	579992.0
2010-12-13 07:00:00	MSFT	Stock	27.3	27.38	27.3	27.38	1414.0
2010-12-13 08:00:00	MSFT	Stock	27.38	27.4	27.36	27.39	25980.0
2010-12-13 09:00:00	MSFT	Stock	27.39	27.4	27.172	27.21	7526529.0
2010-12-13 10:00:00	MSFT	Stock	27.215	27.3	27.2	27.293	6372117.0
2010-12-13 11:00:00	MSFT	Stock	27.296	27.33	27.26	27.314	5829853.0
2010-12-13 12:00:00	MSFT	Stock	27.31	27.39	27.28	27.368	4041186.0
2010-12-13 13:00:00	MSFT	Stock	27.365	27.4	27.35	27.395	3471083.0
2010-12-13 14:00:00	MSFT	Stock	27.4	27.44	27.39	27.42	4460644.0
2010-12-13 15:00:00	MSFT	Stock	27.428	27.45	27.23	27.23	10559822.0
2010-12-13 16:00:00	MSFT	Stock	27.23	27.34	27.23	27.25	4234848.0
2010-12-13 17:00:00	MSFT	Stock	27.25	27.25	27.25	27.25	400.0
2010-12-13 18:00:00	MSFT	Stock	27.3	27.3	27.25	27.25	18892.0
2010-12-13 19:00:00	MSFT	Stock	27.2	27.2	27.2	27.2	600.0
2010-12-13 08:00:00	NVDA	Stock	0.375	0.3763	0.375	0.3763	21000.0
2010-12-13 09:00:00	NVDA	Stock	0.3765	0.3765	0.3715	0.373	77235440.0
2010-12-13 10:00:00	NVDA	Stock	0.3731	0.3743	0.372	0.3723	85412440.0
2010-12-13 11:00:00	NVDA	Stock	0.3723	0.3723	0.366	0.3679	140989920.0
2010-12-13 12:00:00	NVDA	Stock	0.368	0.3687	0.3662	0.3669	40716320.0
2010-12-13 13:00:00	NVDA	Stock	0.3668	0.3675	0.3652	0.3655	43265240.0
2010-12-13 14:00:00	NVDA	Stock	0.3656	0.3682	0.3655	0.3672	67376040.0
2010-12-13 15:00:00	NVDA	Stock	0.3674	0.3675	0.3632	0.365	130438440.0
2010-12-13 16:00:00	NVDA	Stock	0.3648	0.369	0.3632	0.3632	3718280.0
2010-12-13 19:00:00	NVDA	Stock	0.364	0.3642	0.364	0.3642	20000.0
2010-12-13 04:00:00	AMZN	Stock	8.81	8.81	8.81	8.81	2000.0
2010-12-13 06:00:00	AMZN	Stock	8.785	8.87	8.785	8.813	32000.0
2010-12-13 07:00:00	AMZN	Stock	8.814	8.814	8.795	8.805	16000.0
2010-12-13 08:00:00	AMZN	Stock	8.81	8.8375	8.8	8.822	207280.0
2010-12-13 09:00:00	AMZN	Stock	8.8165	8.83	8.76	8.7639	11636780.0
2010-12-13 10:00:00	AMZN	Stock	8.763	8.896	8.763	8.885	14372900.0
2010-12-13 11:00:00	AMZN	Stock	8.8855	8.897	8.8285	8.8295	7803020.0
2010-12-13 12:00:00	AMZN	Stock	8.828	8.8285	8.755	8.7945	11859660.0
2010-12-13 13:00:00	AMZN	Stock	8.794	8.8005	8.7695	8.7932	4311220.0
2010-12-13 14:00:00	AMZN	Stock	8.7935	8.813	8.788	8.7905	7238300.0
2010-12-13 15:00:00	AMZN	Stock	8.793	8.7945	8.6865	8.7125	20178420.0

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

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