PREVIEW / stock_1hour / 2008-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-09.parquet
  size:    793 KB
  rows:    40,019
  symbols: 3,344

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-12-09 07:00:00	AAPL	Stock	3.55	3.5536	3.5393	3.5393	22176.0
2008-12-09 08:00:00	AAPL	Stock	3.5357	3.5357	3.5089	3.5107	811692.0
2008-12-09 09:00:00	AAPL	Stock	3.5114	3.5421	3.4718	3.5261	118420652.0
2008-12-09 10:00:00	AAPL	Stock	3.5198	3.7	3.5154	3.6821	269829308.0
2008-12-09 11:00:00	AAPL	Stock	3.6825	3.6893	3.6182	3.6343	163879744.0
2008-12-09 12:00:00	AAPL	Stock	3.6349	3.6689	3.6236	3.6493	94123064.0
2008-12-09 13:00:00	AAPL	Stock	3.6496	3.6568	3.5786	3.6061	130724748.0
2008-12-09 14:00:00	AAPL	Stock	3.6061	3.6121	3.5436	3.5946	156467668.0
2008-12-09 15:00:00	AAPL	Stock	3.5946	3.6196	3.5536	3.5732	204772904.0
2008-12-09 16:00:00	AAPL	Stock	3.5732	3.6039	3.565	3.5671	60095028.0
2008-12-09 17:00:00	AAPL	Stock	3.5686	3.575	3.5679	3.5721	627900.0
2008-12-09 18:00:00	AAPL	Stock	3.5721	3.5736	3.5679	3.5711	225148.0
2008-12-09 19:00:00	AAPL	Stock	3.5714	3.5775	3.5689	3.5775	433832.0
2008-12-09 08:00:00	MSFT	Stock	20.9	20.9	20.66	20.75	20229.0
2008-12-09 09:00:00	MSFT	Stock	20.75	20.9	20.57	20.7	5304711.0
2008-12-09 10:00:00	MSFT	Stock	20.72	21.25	20.69	21.18	11356789.0
2008-12-09 11:00:00	MSFT	Stock	21.19	21.25	21.055	21.07	9044397.0
2008-12-09 12:00:00	MSFT	Stock	21.07	21.23	20.94	21.083	7797257.0
2008-12-09 13:00:00	MSFT	Stock	21.09	21.15	20.75	20.81	6472778.0
2008-12-09 14:00:00	MSFT	Stock	20.81	20.84	20.47	20.76	9702514.0
2008-12-09 15:00:00	MSFT	Stock	20.76	20.93	20.46	20.64	18705224.0
2008-12-09 16:00:00	MSFT	Stock	20.64	20.888	20.58	20.6	7284705.0
2008-12-09 17:00:00	MSFT	Stock	20.59	20.63	20.58	20.62	1601.0
2008-12-09 18:00:00	MSFT	Stock	20.63	20.63	20.6	20.6	15433.0
2008-12-09 19:00:00	MSFT	Stock	20.64	20.64	20.62	20.62	950.0
2008-12-09 08:00:00	NVDA	Stock	0.1765	0.1783	0.1765	0.1765	209000.0
2008-12-09 09:00:00	NVDA	Stock	0.1765	0.1848	0.1738	0.1828	67902280.0
2008-12-09 10:00:00	NVDA	Stock	0.1823	0.2	0.1823	0.2	169834280.0
2008-12-09 11:00:00	NVDA	Stock	0.1998	0.2023	0.1938	0.1978	120431920.0
2008-12-09 12:00:00	NVDA	Stock	0.1976	0.2007	0.1962	0.1982	58167080.0
2008-12-09 13:00:00	NVDA	Stock	0.1982	0.1985	0.194	0.1975	81379320.0
2008-12-09 14:00:00	NVDA	Stock	0.1973	0.1975	0.1915	0.1965	66562360.0
2008-12-09 15:00:00	NVDA	Stock	0.1966	0.1998	0.1938	0.1958	182456840.0
2008-12-09 16:00:00	NVDA	Stock	0.1955	0.1962	0.1913	0.1925	5031520.0
2008-12-09 17:00:00	NVDA	Stock	0.1938	0.1945	0.1925	0.1945	90000.0
2008-12-09 18:00:00	NVDA	Stock	0.195	0.195	0.195	0.195	68000.0
2008-12-09 19:00:00	NVDA	Stock	0.1945	0.1945	0.1925	0.1935	20000.0
2008-12-09 08:00:00	AMZN	Stock	2.53	2.53	2.494	2.5	403300.0
2008-12-09 09:00:00	AMZN	Stock	2.5	2.595	2.48	2.5535	36580080.0
2008-12-09 10:00:00	AMZN	Stock	2.555	2.724	2.5495	2.693	61832240.0
2008-12-09 11:00:00	AMZN	Stock	2.6925	2.697	2.5915	2.6485	45955840.0
2008-12-09 12:00:00	AMZN	Stock	2.6475	2.668	2.6005	2.6085	17212520.0
2008-12-09 13:00:00	AMZN	Stock	2.6085	2.6205	2.557	2.577	19462700.0
2008-12-09 14:00:00	AMZN	Stock	2.5765	2.5785	2.505	2.567	25524660.0
2008-12-09 15:00:00	AMZN	Stock	2.567	2.589	2.5425	2.5625	43124840.0
2008-12-09 16:00:00	AMZN	Stock	2.5625	2.5755	2.5555	2.5645	2784320.0
2008-12-09 17:00:00	AMZN	Stock	2.5625	2.5645	2.562	2.562	8000.0
2008-12-09 18:00:00	AMZN	Stock	2.568	2.568	2.56	2.56	105640.0
2008-12-09 19:00:00	AMZN	Stock	2.5675	2.57	2.5675	2.5675	27000.0
2008-12-09 08:00:00	TLT	Stock	110.57	110.57	110.37	110.37	500.0

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

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