PREVIEW / stock_1hour / 2004-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-02-24.parquet
  size:    516 KB
  rows:    23,818
  symbols: 1,728

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-02-24 08:00:00	AAPL	Stock	0.3963	0.3963	0.3946	0.3957	72800.0
2004-02-24 09:00:00	AAPL	Stock	0.3955	0.3995	0.393	0.398	23494184.0
2004-02-24 10:00:00	AAPL	Stock	0.3979	0.4029	0.3929	0.4018	42493080.0
2004-02-24 11:00:00	AAPL	Stock	0.4018	0.4025	0.3996	0.4018	26160512.0
2004-02-24 12:00:00	AAPL	Stock	0.4014	0.4059	0.4011	0.405	17406816.0
2004-02-24 13:00:00	AAPL	Stock	0.4048	0.4061	0.4025	0.4036	29443456.0
2004-02-24 14:00:00	AAPL	Stock	0.4032	0.4034	0.3998	0.4	38066560.0
2004-02-24 15:00:00	AAPL	Stock	0.4	0.4023	0.3986	0.3995	51576616.0
2004-02-24 16:00:00	AAPL	Stock	0.3995	0.3996	0.3973	0.3993	6612480.0
2004-02-24 17:00:00	AAPL	Stock	0.3993	0.4005	0.3989	0.3989	470120.0
2004-02-24 08:00:00	MSFT	Stock	26.63	26.64	26.53	26.54	75400.0
2004-02-24 09:00:00	MSFT	Stock	26.52	26.7	26.52	26.68	7521336.0
2004-02-24 10:00:00	MSFT	Stock	26.69	26.931	26.59	26.79	14354278.0
2004-02-24 11:00:00	MSFT	Stock	26.79	26.92	26.79	26.88	6248362.0
2004-02-24 12:00:00	MSFT	Stock	26.88	26.91	26.82	26.84	3044951.0
2004-02-24 13:00:00	MSFT	Stock	26.85	26.95	26.79	26.9	5981502.0
2004-02-24 14:00:00	MSFT	Stock	26.9	26.9	26.69	26.74	7191622.0
2004-02-24 15:00:00	MSFT	Stock	26.73	26.9	26.71	26.83	8121822.0
2004-02-24 16:00:00	MSFT	Stock	26.83	26.918	26.8	26.86	973578.0
2004-02-24 17:00:00	MSFT	Stock	26.86	26.9	26.84	26.9	84422.0
2004-02-24 18:00:00	MSFT	Stock	26.9	26.9	26.88	26.9	10400.0
2004-02-24 08:00:00	NVDA	Stock	0.1947	0.1948	0.1921	0.1921	192000.0
2004-02-24 09:00:00	NVDA	Stock	0.1921	0.1932	0.1898	0.19	71176800.0
2004-02-24 10:00:00	NVDA	Stock	0.1899	0.1923	0.1878	0.1901	113422320.0
2004-02-24 11:00:00	NVDA	Stock	0.19	0.1904	0.188	0.1885	87141840.0
2004-02-24 12:00:00	NVDA	Stock	0.1886	0.189	0.1876	0.1884	41862480.0
2004-02-24 13:00:00	NVDA	Stock	0.1884	0.1885	0.186	0.1862	106394760.0
2004-02-24 14:00:00	NVDA	Stock	0.1863	0.187	0.1844	0.1847	100753320.0
2004-02-24 15:00:00	NVDA	Stock	0.1848	0.1867	0.1843	0.1865	158342880.0
2004-02-24 16:00:00	NVDA	Stock	0.1858	0.1917	0.1854	0.1861	5961360.0
2004-02-24 17:00:00	NVDA	Stock	0.1858	0.1864	0.1855	0.1863	731400.0
2004-02-24 08:00:00	AMZN	Stock	2.1965	2.1965	2.18	2.18	52000.0
2004-02-24 09:00:00	AMZN	Stock	2.18	2.1995	2.172	2.1825	26168840.0
2004-02-24 10:00:00	AMZN	Stock	2.1825	2.1825	2.1435	2.144	47746300.0
2004-02-24 11:00:00	AMZN	Stock	2.144	2.1525	2.1185	2.132	45318260.0
2004-02-24 12:00:00	AMZN	Stock	2.131	2.135	2.1175	2.13	21103940.0
2004-02-24 13:00:00	AMZN	Stock	2.13	2.149	2.1295	2.1395	22135420.0
2004-02-24 14:00:00	AMZN	Stock	2.14	2.143	2.1115	2.1171	23201280.0
2004-02-24 15:00:00	AMZN	Stock	2.117	2.13	2.1125	2.115	28951900.0
2004-02-24 16:00:00	AMZN	Stock	2.115	2.1165	2.113	2.1135	2154140.0
2004-02-24 17:00:00	AMZN	Stock	2.1145	2.1209	2.114	2.114	188480.0
2004-02-24 18:00:00	AMZN	Stock	2.1155	2.1155	2.1155	2.1155	10000.0
2004-02-24 09:00:00	CL	Stock	27.93	27.975	27.805	27.815	404000.0
2004-02-24 10:00:00	CL	Stock	27.805	27.905	27.665	27.865	1208200.0
2004-02-24 11:00:00	CL	Stock	27.87	27.89	27.745	27.755	650000.0
2004-02-24 12:00:00	CL	Stock	27.775	27.81	27.715	27.755	623400.0
2004-02-24 13:00:00	CL	Stock	27.75	27.765	27.66	27.68	315400.0
2004-02-24 14:00:00	CL	Stock	27.675	27.705	27.55	27.605	680600.0
2004-02-24 15:00:00	CL	Stock	27.605	27.725	27.6	27.635	865400.0
2004-02-24 16:00:00	CL	Stock	27.625	27.625	27.61	27.61	1400.0

> showing 50 of 23,818 rows — these rows as CSV

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