PREVIEW / stock_1hour / 2005-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-03.parquet
  size:    534 KB
  rows:    25,241
  symbols: 1,923

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
2005-02-03 08:00:00	AAPL	Stock	1.4154	1.4161	1.4104	1.4125	1203552.0
2005-02-03 09:00:00	AAPL	Stock	1.4125	1.4184	1.4043	1.4063	116634504.0
2005-02-03 10:00:00	AAPL	Stock	1.4059	1.4063	1.3809	1.392	268267832.0
2005-02-03 11:00:00	AAPL	Stock	1.392	1.397	1.3898	1.392	75212480.0
2005-02-03 12:00:00	AAPL	Stock	1.3923	1.3929	1.3841	1.3859	61312272.0
2005-02-03 13:00:00	AAPL	Stock	1.3859	1.4105	1.3857	1.3936	45247496.0
2005-02-03 14:00:00	AAPL	Stock	1.3938	1.3946	1.3896	1.3918	51526832.0
2005-02-03 15:00:00	AAPL	Stock	1.3914	1.3986	1.3884	1.3893	96419120.0
2005-02-03 16:00:00	AAPL	Stock	1.3893	1.3909	1.3886	1.3888	2086224.0
2005-02-03 17:00:00	AAPL	Stock	1.3893	1.3934	1.3879	1.3934	1036280.0
2005-02-03 18:00:00	AAPL	Stock	1.3875	1.3895	1.3861	1.3895	264712.0
2005-02-03 08:00:00	MSFT	Stock	26.53	26.53	26.34	26.4	72240.0
2005-02-03 09:00:00	MSFT	Stock	26.41	26.45	26.27	26.33	7039712.0
2005-02-03 10:00:00	MSFT	Stock	26.33	26.34	26.2	26.218	10005835.0
2005-02-03 11:00:00	MSFT	Stock	26.21	26.24	26.1	26.14	9332558.0
2005-02-03 12:00:00	MSFT	Stock	26.14	26.228	26.1	26.14	6929519.0
2005-02-03 13:00:00	MSFT	Stock	26.15	26.24	26.12	26.22	6752965.0
2005-02-03 14:00:00	MSFT	Stock	26.23	26.25	26.16	26.25	9952805.0
2005-02-03 15:00:00	MSFT	Stock	26.24	26.28	26.17	26.17	10440733.0
2005-02-03 16:00:00	MSFT	Stock	26.17	26.2	26.17	26.17	611540.0
2005-02-03 17:00:00	MSFT	Stock	26.16	26.19	26.16	26.19	87960.0
2005-02-03 18:00:00	MSFT	Stock	26.19	26.19	26.19	26.19	1475.0
2005-02-03 08:00:00	NVDA	Stock	0.205	0.205	0.205	0.205	120000.0
2005-02-03 09:00:00	NVDA	Stock	0.2042	0.2048	0.2022	0.2046	123524280.0
2005-02-03 10:00:00	NVDA	Stock	0.2044	0.2047	0.2013	0.2014	137850600.0
2005-02-03 11:00:00	NVDA	Stock	0.2014	0.2024	0.2004	0.2012	97337520.0
2005-02-03 12:00:00	NVDA	Stock	0.2012	0.202	0.2009	0.2014	56774520.0
2005-02-03 13:00:00	NVDA	Stock	0.2014	0.203	0.2013	0.2028	55233960.0
2005-02-03 14:00:00	NVDA	Stock	0.2029	0.2043	0.2028	0.2036	68718000.0
2005-02-03 15:00:00	NVDA	Stock	0.2036	0.2043	0.2031	0.2032	127159320.0
2005-02-03 16:00:00	NVDA	Stock	0.2032	0.2035	0.2032	0.2032	2494320.0
2005-02-03 17:00:00	NVDA	Stock	0.2032	0.2032	0.2032	0.2032	24000.0
2005-02-03 18:00:00	NVDA	Stock	0.2032	0.2032	0.2032	0.2032	48000.0
2005-02-03 08:00:00	AMZN	Stock	1.775	1.785	1.7375	1.759	50392560.0
2005-02-03 09:00:00	AMZN	Stock	1.759	1.7675	1.7375	1.7515	306285580.0
2005-02-03 10:00:00	AMZN	Stock	1.751	1.7565	1.7265	1.7495	271009780.0
2005-02-03 11:00:00	AMZN	Stock	1.7495	1.756	1.7415	1.7425	88037060.0
2005-02-03 12:00:00	AMZN	Stock	1.7425	1.7465	1.7325	1.7405	68307720.0
2005-02-03 13:00:00	AMZN	Stock	1.7405	1.7485	1.728	1.7475	96728300.0
2005-02-03 14:00:00	AMZN	Stock	1.7475	1.759	1.743	1.7515	105753100.0
2005-02-03 15:00:00	AMZN	Stock	1.7515	1.7945	1.747	1.788	204512200.0
2005-02-03 16:00:00	AMZN	Stock	1.7875	1.788	1.741	1.7795	6281320.0
2005-02-03 17:00:00	AMZN	Stock	1.7785	1.7875	1.778	1.783	646520.0
2005-02-03 18:00:00	AMZN	Stock	1.7795	1.786	1.7735	1.786	178460.0
2005-02-03 09:00:00	CL	Stock	27.25	27.4	27.155	27.4	871400.0
2005-02-03 10:00:00	CL	Stock	27.42	27.715	27.355	27.5	3227800.0
2005-02-03 11:00:00	CL	Stock	27.5	27.505	27.31	27.375	2194800.0
2005-02-03 12:00:00	CL	Stock	27.37	27.4	27.29	27.35	1536400.0
2005-02-03 13:00:00	CL	Stock	27.355	27.405	27.325	27.375	558800.0
2005-02-03 14:00:00	CL	Stock	27.385	27.405	27.295	27.305	1133000.0

> showing 50 of 25,241 rows — these rows as CSV

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