PREVIEW / stock_1hour / 2004-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-12-23.parquet
  size:    522 KB
  rows:    24,542
  symbols: 1,904

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
2004-12-23 08:00:00	AAPL	Stock	1.1391	1.1395	1.1375	1.1393	597968.0
2004-12-23 09:00:00	AAPL	Stock	1.14	1.1473	1.1357	1.1452	55019048.0
2004-12-23 10:00:00	AAPL	Stock	1.1452	1.147	1.1405	1.143	52900568.0
2004-12-23 11:00:00	AAPL	Stock	1.1429	1.1446	1.1393	1.1409	36457400.0
2004-12-23 12:00:00	AAPL	Stock	1.1411	1.142	1.14	1.1411	13468448.0
2004-12-23 13:00:00	AAPL	Stock	1.1409	1.1454	1.1396	1.1432	29748320.0
2004-12-23 14:00:00	AAPL	Stock	1.143	1.1446	1.1427	1.1432	18973248.0
2004-12-23 15:00:00	AAPL	Stock	1.1432	1.1446	1.1427	1.143	33152000.0
2004-12-23 16:00:00	AAPL	Stock	1.1438	1.1448	1.1414	1.1446	1668688.0
2004-12-23 17:00:00	AAPL	Stock	1.1427	1.1427	1.1427	1.1427	22400.0
2004-12-23 18:00:00	AAPL	Stock	1.1436	1.1436	1.1436	1.1436	5600.0
2004-12-23 08:00:00	MSFT	Stock	26.91	26.97	26.91	26.94	17450.0
2004-12-23 09:00:00	MSFT	Stock	26.95	27.14	26.83	27.091	10927901.0
2004-12-23 10:00:00	MSFT	Stock	27.09	27.14	27.02	27.09	11317109.0
2004-12-23 11:00:00	MSFT	Stock	27.09	27.12	27.04	27.11	9108868.0
2004-12-23 12:00:00	MSFT	Stock	27.1	27.15	27.05	27.09	7971268.0
2004-12-23 13:00:00	MSFT	Stock	27.09	27.12	27.02	27.03	5923197.0
2004-12-23 14:00:00	MSFT	Stock	27.04	27.07	26.98	27.0	9442606.0
2004-12-23 15:00:00	MSFT	Stock	27.001	27.07	26.98	27.01	7278033.0
2004-12-23 16:00:00	MSFT	Stock	27.02	27.1	27.0	27.03	2677667.0
2004-12-23 17:00:00	MSFT	Stock	27.03	27.05	27.01	27.04	16092.0
2004-12-23 18:00:00	MSFT	Stock	27.03	27.03	27.01	27.01	5785.0
2004-12-23 08:00:00	NVDA	Stock	0.1919	0.1919	0.1919	0.1919	12000.0
2004-12-23 09:00:00	NVDA	Stock	0.1922	0.1935	0.1897	0.1928	62538960.0
2004-12-23 10:00:00	NVDA	Stock	0.1929	0.1933	0.1921	0.1924	48844560.0
2004-12-23 11:00:00	NVDA	Stock	0.1925	0.1927	0.1916	0.1919	42525480.0
2004-12-23 12:00:00	NVDA	Stock	0.1919	0.1922	0.1913	0.192	20322600.0
2004-12-23 13:00:00	NVDA	Stock	0.1919	0.194	0.1917	0.194	43190880.0
2004-12-23 14:00:00	NVDA	Stock	0.1938	0.1944	0.1927	0.1927	53566200.0
2004-12-23 15:00:00	NVDA	Stock	0.1928	0.193	0.1917	0.1927	75770400.0
2004-12-23 16:00:00	NVDA	Stock	0.1922	0.1929	0.1921	0.1929	1047000.0
2004-12-23 17:00:00	NVDA	Stock	0.193	0.193	0.193	0.193	144000.0
2004-12-23 08:00:00	AMZN	Stock	1.971	1.9765	1.971	1.974	34000.0
2004-12-23 09:00:00	AMZN	Stock	1.975	1.976	1.9575	1.965	9350160.0
2004-12-23 10:00:00	AMZN	Stock	1.965	1.9665	1.961	1.962	10612720.0
2004-12-23 11:00:00	AMZN	Stock	1.962	1.963	1.954	1.9545	11462600.0
2004-12-23 12:00:00	AMZN	Stock	1.954	1.954	1.9475	1.9505	9987000.0
2004-12-23 13:00:00	AMZN	Stock	1.951	1.9565	1.9485	1.956	3648740.0
2004-12-23 14:00:00	AMZN	Stock	1.956	1.96	1.948	1.949	6339180.0
2004-12-23 15:00:00	AMZN	Stock	1.9495	1.952	1.9475	1.9475	10180160.0
2004-12-23 16:00:00	AMZN	Stock	1.9465	1.948	1.943	1.945	690580.0
2004-12-23 17:00:00	AMZN	Stock	1.9455	1.9465	1.9455	1.9465	63760.0
2004-12-23 18:00:00	AMZN	Stock	1.951	1.97	1.951	1.97	4000.0
2004-12-23 09:00:00	CL	Stock	25.25	25.405	25.25	25.395	396400.0
2004-12-23 10:00:00	CL	Stock	25.39	25.515	25.345	25.425	740600.0
2004-12-23 11:00:00	CL	Stock	25.425	25.44	25.33	25.38	335600.0
2004-12-23 12:00:00	CL	Stock	25.385	25.385	25.31	25.33	278400.0
2004-12-23 13:00:00	CL	Stock	25.325	25.385	25.305	25.36	224400.0
2004-12-23 14:00:00	CL	Stock	25.37	25.375	25.315	25.335	212600.0
2004-12-23 15:00:00	CL	Stock	25.335	25.395	25.325	25.37	510800.0

> showing 50 of 24,542 rows — these rows as CSV

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