PREVIEW / stock_1hour / 2008-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-12.parquet
  size:    792 KB
  rows:    40,254
  symbols: 3,303

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
2008-11-12 07:00:00	AAPL	Stock	3.3821	3.3821	3.3821	3.3821	2800.0
2008-11-12 08:00:00	AAPL	Stock	3.3825	3.3918	3.2982	3.3132	3818780.0
2008-11-12 09:00:00	AAPL	Stock	3.3132	3.3168	3.2496	3.2711	166765620.0
2008-11-12 10:00:00	AAPL	Stock	3.2704	3.33	3.2632	3.3093	236561024.0
2008-11-12 11:00:00	AAPL	Stock	3.3096	3.3296	3.2857	3.2975	142143232.0
2008-11-12 12:00:00	AAPL	Stock	3.2968	3.3018	3.2768	3.3007	85946168.0
2008-11-12 13:00:00	AAPL	Stock	3.3011	3.3043	3.2439	3.2564	104561324.0
2008-11-12 14:00:00	AAPL	Stock	3.2557	3.265	3.2232	3.2275	160630512.0
2008-11-12 15:00:00	AAPL	Stock	3.2268	3.2514	3.2146	3.2186	229216988.0
2008-11-12 16:00:00	AAPL	Stock	3.2186	3.2871	3.2164	3.2179	29065428.0
2008-11-12 17:00:00	AAPL	Stock	3.2171	3.2171	3.1036	3.1239	5526276.0
2008-11-12 18:00:00	AAPL	Stock	3.1207	3.1382	3.1107	3.1354	1177456.0
2008-11-12 19:00:00	AAPL	Stock	3.135	3.1357	3.1154	3.1275	770980.0
2008-11-12 05:00:00	MSFT	Stock	21.09	21.09	21.09	21.09	180.0
2008-11-12 07:00:00	MSFT	Stock	21.13	21.14	21.13	21.14	1484.0
2008-11-12 08:00:00	MSFT	Stock	21.12	21.12	20.95	20.95	30318.0
2008-11-12 09:00:00	MSFT	Stock	20.91	21.0	20.83	20.85	7694817.0
2008-11-12 10:00:00	MSFT	Stock	20.84	20.95	20.67	20.814	14396007.0
2008-11-12 11:00:00	MSFT	Stock	20.82	20.87	20.65	20.8	8684397.0
2008-11-12 12:00:00	MSFT	Stock	20.8	20.85	20.67	20.81	6778116.0
2008-11-12 13:00:00	MSFT	Stock	20.812	20.83	20.61	20.66	6235939.0
2008-11-12 14:00:00	MSFT	Stock	20.66	20.71	20.53	20.54	9422235.0
2008-11-12 15:00:00	MSFT	Stock	20.54	20.57	20.28	20.3	18792659.0
2008-11-12 16:00:00	MSFT	Stock	20.3	21.359	20.25	20.25	17340057.0
2008-11-12 17:00:00	MSFT	Stock	20.33	20.33	19.85	19.9	223433.0
2008-11-12 18:00:00	MSFT	Stock	19.9	19.97	19.88	19.9	32579.0
2008-11-12 19:00:00	MSFT	Stock	19.9	19.9	19.8	19.9	30984.0
2008-11-12 08:00:00	NVDA	Stock	0.1952	0.1952	0.1952	0.1952	4000.0
2008-11-12 09:00:00	NVDA	Stock	0.1908	0.1935	0.1858	0.19	71350520.0
2008-11-12 10:00:00	NVDA	Stock	0.1903	0.1915	0.1853	0.1868	90653520.0
2008-11-12 11:00:00	NVDA	Stock	0.187	0.1878	0.1838	0.184	58328400.0
2008-11-12 12:00:00	NVDA	Stock	0.1839	0.185	0.1825	0.1835	76301080.0
2008-11-12 13:00:00	NVDA	Stock	0.1833	0.1845	0.1815	0.1823	58730080.0
2008-11-12 14:00:00	NVDA	Stock	0.182	0.1868	0.1813	0.1828	75893840.0
2008-11-12 15:00:00	NVDA	Stock	0.183	0.1865	0.1818	0.1835	181894520.0
2008-11-12 16:00:00	NVDA	Stock	0.1835	0.185	0.1833	0.1835	27533800.0
2008-11-12 17:00:00	NVDA	Stock	0.1825	0.1825	0.168	0.1688	3139920.0
2008-11-12 18:00:00	NVDA	Stock	0.1703	0.1718	0.17	0.1718	242400.0
2008-11-12 19:00:00	NVDA	Stock	0.1725	0.1725	0.17	0.17	832000.0
2008-11-12 08:00:00	AMZN	Stock	2.325	2.325	2.21	2.21	782120.0
2008-11-12 09:00:00	AMZN	Stock	2.21	2.272	2.145	2.256	47484500.0
2008-11-12 10:00:00	AMZN	Stock	2.257	2.2615	2.182	2.216	33605260.0
2008-11-12 11:00:00	AMZN	Stock	2.216	2.217	2.184	2.2045	28496240.0
2008-11-12 12:00:00	AMZN	Stock	2.2035	2.209	2.1755	2.1995	16794920.0
2008-11-12 13:00:00	AMZN	Stock	2.1995	2.202	2.103	2.1135	37434100.0
2008-11-12 14:00:00	AMZN	Stock	2.113	2.2168	2.066	2.067	46525040.0
2008-11-12 15:00:00	AMZN	Stock	2.0675	2.1085	2.045	2.0785	74632360.0
2008-11-12 16:00:00	AMZN	Stock	2.0775	2.1449	2.075	2.075	8404540.0
2008-11-12 17:00:00	AMZN	Stock	2.0675	2.0675	2.011	2.011	392680.0
2008-11-12 18:00:00	AMZN	Stock	2.011	2.035	2.01	2.024	48400.0

> showing 50 of 40,254 rows — these rows as CSV

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