PREVIEW / stock_1hour / 2008-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-10.parquet
  size:    839 KB
  rows:    40,266
  symbols: 3,316

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-06-10 04:00:00	AAPL	Stock	6.4518	6.4518	6.4464	6.4464	5600.0
2008-06-10 05:00:00	AAPL	Stock	6.4754	6.4821	6.4754	6.4821	36400.0
2008-06-10 06:00:00	AAPL	Stock	6.4804	6.5014	6.4804	6.5014	5600.0
2008-06-10 07:00:00	AAPL	Stock	6.4825	6.5464	6.4579	6.5179	1888404.0
2008-06-10 08:00:00	AAPL	Stock	6.5179	6.5393	6.4075	6.4489	10435824.0
2008-06-10 09:00:00	AAPL	Stock	6.4525	6.5736	6.3793	6.5593	190010800.0
2008-06-10 10:00:00	AAPL	Stock	6.5589	6.6143	6.5129	6.5982	196534660.0
2008-06-10 11:00:00	AAPL	Stock	6.5982	6.6271	6.5643	6.5875	149921240.0
2008-06-10 12:00:00	AAPL	Stock	6.5879	6.6596	6.5764	6.6582	116720016.0
2008-06-10 13:00:00	AAPL	Stock	6.6579	6.6707	6.6286	6.6425	132651008.0
2008-06-10 14:00:00	AAPL	Stock	6.6429	6.6461	6.5932	6.6189	121947980.0
2008-06-10 15:00:00	AAPL	Stock	6.6189	6.6661	6.6184	6.63	139295184.0
2008-06-10 16:00:00	AAPL	Stock	6.63	6.6357	6.5883	6.6321	11831120.0
2008-06-10 17:00:00	AAPL	Stock	6.6321	6.6339	6.6279	6.63	627956.0
2008-06-10 18:00:00	AAPL	Stock	6.6282	6.6293	6.6179	6.6182	202132.0
2008-06-10 19:00:00	AAPL	Stock	6.6193	6.625	6.6179	6.6182	253176.0
2008-06-10 08:00:00	MSFT	Stock	27.5	27.71	27.36	27.42	1039153.0
2008-06-10 09:00:00	MSFT	Stock	27.41	27.78	27.32	27.672	9780237.0
2008-06-10 10:00:00	MSFT	Stock	27.672	27.95	27.59	27.88	12781645.0
2008-06-10 11:00:00	MSFT	Stock	27.87	28.1	27.79	27.96	12969618.0
2008-06-10 12:00:00	MSFT	Stock	27.97	28.29	27.89	28.06	8707673.0
2008-06-10 13:00:00	MSFT	Stock	28.06	28.24	27.97	28.14	6841511.0
2008-06-10 14:00:00	MSFT	Stock	28.14	28.16	27.81	27.88	9617276.0
2008-06-10 15:00:00	MSFT	Stock	27.89	27.97	27.81	27.91	10185870.0
2008-06-10 16:00:00	MSFT	Stock	27.9	28.04	27.85	27.89	1859545.0
2008-06-10 17:00:00	MSFT	Stock	27.88	27.89	27.87	27.87	35671.0
2008-06-10 18:00:00	MSFT	Stock	27.86	27.9	27.85	27.9	6150.0
2008-06-10 19:00:00	MSFT	Stock	27.9	27.9	27.88	27.88	5406.0
2008-06-10 08:00:00	NVDA	Stock	0.5838	0.5855	0.5755	0.5755	645360.0
2008-06-10 09:00:00	NVDA	Stock	0.5758	0.5775	0.5638	0.5672	154051240.0
2008-06-10 10:00:00	NVDA	Stock	0.567	0.5712	0.5588	0.561	212801480.0
2008-06-10 11:00:00	NVDA	Stock	0.5608	0.5675	0.559	0.5632	126326760.0
2008-06-10 12:00:00	NVDA	Stock	0.5635	0.5702	0.563	0.566	112877600.0
2008-06-10 13:00:00	NVDA	Stock	0.5662	0.5688	0.561	0.5615	164356040.0
2008-06-10 14:00:00	NVDA	Stock	0.5612	0.5618	0.5535	0.555	182611040.0
2008-06-10 15:00:00	NVDA	Stock	0.555	0.5585	0.5542	0.5562	242550400.0
2008-06-10 16:00:00	NVDA	Stock	0.5565	0.5672	0.5555	0.5565	4760520.0
2008-06-10 17:00:00	NVDA	Stock	0.5562	0.557	0.5562	0.557	192840.0
2008-06-10 18:00:00	NVDA	Stock	0.5582	0.5598	0.5575	0.558	106000.0
2008-06-10 19:00:00	NVDA	Stock	0.5588	0.5598	0.5588	0.5588	50000.0
2008-06-10 08:00:00	AMZN	Stock	3.925	3.925	3.925	3.925	2000.0
2008-06-10 09:00:00	AMZN	Stock	3.9105	4.0185	3.91	4.0082	17207720.0
2008-06-10 10:00:00	AMZN	Stock	4.0095	4.0245	3.9765	3.997	18754660.0
2008-06-10 11:00:00	AMZN	Stock	3.998	4.0175	3.975	3.9825	10836800.0
2008-06-10 12:00:00	AMZN	Stock	3.982	4.019	3.9705	4.0135	9967700.0
2008-06-10 13:00:00	AMZN	Stock	4.015	4.052	4.005	4.018	9922480.0
2008-06-10 14:00:00	AMZN	Stock	4.017	4.021	3.9435	3.9648	19707680.0
2008-06-10 15:00:00	AMZN	Stock	3.9645	3.9885	3.962	3.981	21129760.0
2008-06-10 16:00:00	AMZN	Stock	3.981	4.0082	3.971	3.971	7569680.0
2008-06-10 17:00:00	AMZN	Stock	3.9565	3.981	3.9565	3.981	13700.0

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

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