PREVIEW / stock_1hour / 2008-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-08.parquet
  size:    830 KB
  rows:    41,003
  symbols: 3,264

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-01-08 04:00:00	AAPL	Stock	6.3804	6.3804	6.3786	6.3786	5600.0
2008-01-08 05:00:00	AAPL	Stock	6.4054	6.4054	6.3607	6.3607	25200.0
2008-01-08 06:00:00	AAPL	Stock	6.4054	6.4054	6.4054	6.4054	2800.0
2008-01-08 07:00:00	AAPL	Stock	6.3964	6.4464	6.3932	6.4107	751240.0
2008-01-08 08:00:00	AAPL	Stock	6.4136	6.4282	6.3861	6.405	7271740.0
2008-01-08 09:00:00	AAPL	Stock	6.4043	6.4821	6.3614	6.4079	185656520.0
2008-01-08 10:00:00	AAPL	Stock	6.4086	6.5164	6.3921	6.4471	231625492.0
2008-01-08 11:00:00	AAPL	Stock	6.4475	6.4614	6.3571	6.3936	206070256.0
2008-01-08 12:00:00	AAPL	Stock	6.3921	6.4329	6.3611	6.4143	117722696.0
2008-01-08 13:00:00	AAPL	Stock	6.4153	6.4621	6.3839	6.4579	134876084.0
2008-01-08 14:00:00	AAPL	Stock	6.4579	6.4986	6.3571	6.3704	193516204.0
2008-01-08 15:00:00	AAPL	Stock	6.3714	6.3829	6.1	6.1154	422108792.0
2008-01-08 16:00:00	AAPL	Stock	6.1143	6.3855	6.1044	6.1211	18586792.0
2008-01-08 17:00:00	AAPL	Stock	6.1204	6.3767	6.1096	6.1279	3468808.0
2008-01-08 18:00:00	AAPL	Stock	6.1268	6.1282	6.1179	6.1243	1123108.0
2008-01-08 19:00:00	AAPL	Stock	6.1211	6.1429	6.1071	6.1411	1009820.0
2008-01-08 07:00:00	MSFT	Stock	34.71	34.88	34.71	34.87	1550.0
2008-01-08 08:00:00	MSFT	Stock	34.61	34.89	34.61	34.85	17600.0
2008-01-08 09:00:00	MSFT	Stock	34.78	34.8	34.34	34.36	5045132.0
2008-01-08 10:00:00	MSFT	Stock	34.35	34.54	34.23	34.33	8385368.0
2008-01-08 11:00:00	MSFT	Stock	34.32	34.38	33.89	33.978	9294330.0
2008-01-08 12:00:00	MSFT	Stock	33.97	34.19	33.9	34.14	6026828.0
2008-01-08 13:00:00	MSFT	Stock	34.14	34.33	34.04	34.22	9159135.0
2008-01-08 14:00:00	MSFT	Stock	34.21	34.26	33.85	33.89	11133592.0
2008-01-08 15:00:00	MSFT	Stock	33.88	34.25	33.4	33.46	34921986.0
2008-01-08 16:00:00	MSFT	Stock	33.46	34.659	33.45	33.45	3793960.0
2008-01-08 17:00:00	MSFT	Stock	33.46	34.849	33.45	33.49	401559.0
2008-01-08 18:00:00	MSFT	Stock	33.49	33.5	33.46	33.5	3400.0
2008-01-08 19:00:00	MSFT	Stock	33.48	33.56	33.48	33.56	3870.0
2008-01-08 07:00:00	NVDA	Stock	0.6788	0.6872	0.6788	0.6872	16000.0
2008-01-08 08:00:00	NVDA	Stock	0.68	0.6872	0.6762	0.6838	642000.0
2008-01-08 09:00:00	NVDA	Stock	0.6838	0.6948	0.6605	0.6895	126679320.0
2008-01-08 10:00:00	NVDA	Stock	0.69	0.7095	0.6888	0.7015	190410320.0
2008-01-08 11:00:00	NVDA	Stock	0.7012	0.7045	0.692	0.7025	139553920.0
2008-01-08 12:00:00	NVDA	Stock	0.7025	0.7245	0.7	0.7203	108595240.0
2008-01-08 13:00:00	NVDA	Stock	0.7203	0.7323	0.7125	0.726	122575840.0
2008-01-08 14:00:00	NVDA	Stock	0.726	0.7275	0.7088	0.709	106632600.0
2008-01-08 15:00:00	NVDA	Stock	0.709	0.715	0.684	0.686	196318720.0
2008-01-08 16:00:00	NVDA	Stock	0.686	0.7118	0.6828	0.7	45421080.0
2008-01-08 17:00:00	NVDA	Stock	0.7041	0.7048	0.6858	0.6912	58369720.0
2008-01-08 18:00:00	NVDA	Stock	0.6925	0.6935	0.6925	0.6925	28600.0
2008-01-08 19:00:00	NVDA	Stock	0.6925	0.6935	0.6925	0.6935	58680.0
2008-01-08 07:00:00	AMZN	Stock	4.485	4.485	4.485	4.485	2000.0
2008-01-08 08:00:00	AMZN	Stock	4.475	4.4815	4.355	4.375	464020.0
2008-01-08 09:00:00	AMZN	Stock	4.3705	4.5825	4.3465	4.48	41747460.0
2008-01-08 10:00:00	AMZN	Stock	4.4795	4.5915	4.4725	4.518	37366080.0
2008-01-08 11:00:00	AMZN	Stock	4.5185	4.55	4.444	4.478	28526460.0
2008-01-08 12:00:00	AMZN	Stock	4.477	4.516	4.4695	4.5025	15264060.0
2008-01-08 13:00:00	AMZN	Stock	4.5055	4.5285	4.475	4.522	19639300.0
2008-01-08 14:00:00	AMZN	Stock	4.522	4.55	4.481	4.485	26189040.0

> showing 50 of 41,003 rows — these rows as CSV

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