PREVIEW / stock_1hour / 2008-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-18.parquet
  size:    816 KB
  rows:    40,670
  symbols: 3,274

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-18 05:00:00	AAPL	Stock	5.82	5.82	5.82	5.82	28000.0
2008-01-18 06:00:00	AAPL	Stock	5.8482	5.8482	5.8482	5.8482	2800.0
2008-01-18 07:00:00	AAPL	Stock	5.8211	5.8571	5.8179	5.8482	1881152.0
2008-01-18 08:00:00	AAPL	Stock	5.8571	5.8929	5.8321	5.8743	10200428.0
2008-01-18 09:00:00	AAPL	Stock	5.8718	5.8821	5.7754	5.8482	275610692.0
2008-01-18 10:00:00	AAPL	Stock	5.8482	5.9196	5.8382	5.8729	273956620.0
2008-01-18 11:00:00	AAPL	Stock	5.8725	5.8893	5.7282	5.7639	293980512.0
2008-01-18 12:00:00	AAPL	Stock	5.765	5.8593	5.7464	5.8175	188172320.0
2008-01-18 13:00:00	AAPL	Stock	5.8175	5.8539	5.7529	5.7818	156974132.0
2008-01-18 14:00:00	AAPL	Stock	5.7814	5.7857	5.7004	5.7471	206794504.0
2008-01-18 15:00:00	AAPL	Stock	5.7471	5.7771	5.7179	5.7579	278379388.0
2008-01-18 16:00:00	AAPL	Stock	5.7579	5.8893	5.7469	5.7586	31939908.0
2008-01-18 17:00:00	AAPL	Stock	5.7582	5.8839	5.7536	5.7604	7716772.0
2008-01-18 18:00:00	AAPL	Stock	5.7604	5.7625	5.7518	5.7571	518000.0
2008-01-18 19:00:00	AAPL	Stock	5.7543	5.7625	5.75	5.7596	821940.0
2008-01-18 07:00:00	MSFT	Stock	33.6	33.6	33.43	33.6	3300.0
2008-01-18 08:00:00	MSFT	Stock	33.65	33.65	33.5	33.51	44012.0
2008-01-18 09:00:00	MSFT	Stock	33.51	33.51	33.05	33.3	19876952.0
2008-01-18 10:00:00	MSFT	Stock	33.3	33.89	33.293	33.78	16057231.0
2008-01-18 11:00:00	MSFT	Stock	33.78	34.0	33.2	33.28	17771071.0
2008-01-18 12:00:00	MSFT	Stock	33.27	33.53	33.24	33.43	11912393.0
2008-01-18 13:00:00	MSFT	Stock	33.43	33.57	33.06	33.16	9040850.0
2008-01-18 14:00:00	MSFT	Stock	33.16	33.4	33.07	33.23	12985834.0
2008-01-18 15:00:00	MSFT	Stock	33.23	33.3	32.97	33.06	20939259.0
2008-01-18 16:00:00	MSFT	Stock	33.06	33.397	32.98	33.01	6830395.0
2008-01-18 17:00:00	MSFT	Stock	33.01	33.04	33.01	33.02	577444.0
2008-01-18 18:00:00	MSFT	Stock	33.02	33.23	33.02	33.19	136903.0
2008-01-18 19:00:00	MSFT	Stock	33.18	33.22	32.5	33.18	1626949.0
2008-01-18 08:00:00	NVDA	Stock	0.603	0.6063	0.5963	0.605	448480.0
2008-01-18 09:00:00	NVDA	Stock	0.605	0.605	0.563	0.5992	126273600.0
2008-01-18 10:00:00	NVDA	Stock	0.5992	0.622	0.598	0.6168	141280600.0
2008-01-18 11:00:00	NVDA	Stock	0.6168	0.6195	0.5938	0.5943	124551200.0
2008-01-18 12:00:00	NVDA	Stock	0.5943	0.6125	0.5943	0.6116	91961000.0
2008-01-18 13:00:00	NVDA	Stock	0.6118	0.6173	0.607	0.6122	70703000.0
2008-01-18 14:00:00	NVDA	Stock	0.6122	0.614	0.6065	0.612	102717680.0
2008-01-18 15:00:00	NVDA	Stock	0.6119	0.6242	0.6103	0.6208	223651720.0
2008-01-18 16:00:00	NVDA	Stock	0.621	0.621	0.5825	0.621	13605560.0
2008-01-18 17:00:00	NVDA	Stock	0.6185	0.621	0.5961	0.621	8218120.0
2008-01-18 19:00:00	NVDA	Stock	0.6188	0.6188	0.615	0.615	12000.0
2008-01-18 07:00:00	AMZN	Stock	4.0945	4.0945	4.0945	4.0945	2000.0
2008-01-18 08:00:00	AMZN	Stock	4.0575	4.0865	4.05	4.05	90840.0
2008-01-18 09:00:00	AMZN	Stock	4.05	4.108	3.99	4.075	48997280.0
2008-01-18 10:00:00	AMZN	Stock	4.075	4.1155	4.0365	4.04	34319420.0
2008-01-18 11:00:00	AMZN	Stock	4.0415	4.0495	3.9025	3.9075	49595520.0
2008-01-18 12:00:00	AMZN	Stock	3.908	4.006	3.902	3.976	30911600.0
2008-01-18 13:00:00	AMZN	Stock	3.9765	4.006	3.9575	3.9985	19190200.0
2008-01-18 14:00:00	AMZN	Stock	3.9985	4.0095	3.9505	3.9865	35896320.0
2008-01-18 15:00:00	AMZN	Stock	3.986	4.0065	3.969	3.9855	45585840.0
2008-01-18 16:00:00	AMZN	Stock	3.9855	4.0084	3.975	3.988	1378120.0
2008-01-18 17:00:00	AMZN	Stock	3.9825	3.988	3.95	3.988	1099700.0

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

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