PREVIEW / stock_1hour / 2002-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-24.parquet
  size:    415 KB
  rows:    19,718
  symbols: 1,444

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
2002-06-24 08:00:00	AAPL	Stock	0.3009	0.3009	0.3009	0.3009	16800.0
2002-06-24 09:00:00	AAPL	Stock	0.298	0.305	0.298	0.3018	48109600.0
2002-06-24 10:00:00	AAPL	Stock	0.3018	0.308	0.3014	0.3038	51962400.0
2002-06-24 11:00:00	AAPL	Stock	0.3038	0.3059	0.3025	0.3041	34697600.0
2002-06-24 12:00:00	AAPL	Stock	0.3041	0.305	0.3029	0.3043	34669600.0
2002-06-24 13:00:00	AAPL	Stock	0.3039	0.3139	0.3039	0.3121	54034400.0
2002-06-24 14:00:00	AAPL	Stock	0.3121	0.3166	0.3104	0.313	57092000.0
2002-06-24 15:00:00	AAPL	Stock	0.3129	0.3143	0.3027	0.308	61824000.0
2002-06-24 16:00:00	AAPL	Stock	0.3084	0.3105	0.3072	0.3084	16234400.0
2002-06-24 17:00:00	AAPL	Stock	0.3036	0.3079	0.3036	0.3061	100800.0
2002-06-24 18:00:00	AAPL	Stock	0.3062	0.3087	0.3054	0.3082	56000.0
2002-06-24 08:00:00	MSFT	Stock	26.005	26.275	25.975	26.025	68400.0
2002-06-24 09:00:00	MSFT	Stock	26.01	26.33	26.0	26.085	10102200.0
2002-06-24 10:00:00	MSFT	Stock	26.085	26.465	25.934	26.25	13592000.0
2002-06-24 11:00:00	MSFT	Stock	26.245	26.395	25.93	26.04	8160000.0
2002-06-24 12:00:00	MSFT	Stock	26.04	26.19	25.975	26.1795	9192000.0
2002-06-24 13:00:00	MSFT	Stock	26.18	27.09	26.16	26.925	13275600.0
2002-06-24 14:00:00	MSFT	Stock	26.925	27.32	26.915	27.245	15942200.0
2002-06-24 15:00:00	MSFT	Stock	27.2315	27.29	26.93	27.09	13404800.0
2002-06-24 16:00:00	MSFT	Stock	27.075	27.25	26.49	27.125	2423800.0
2002-06-24 17:00:00	MSFT	Stock	27.135	27.175	26.9555	27.1495	36400.0
2002-06-24 18:00:00	MSFT	Stock	26.9395	27.2155	26.9395	27.165	11800.0
2002-06-24 08:00:00	NVDA	Stock	0.1833	0.1883	0.1833	0.1838	1944000.0
2002-06-24 09:00:00	NVDA	Stock	0.1838	0.1885	0.1783	0.1802	182904000.0
2002-06-24 10:00:00	NVDA	Stock	0.1804	0.1879	0.1792	0.1833	200232000.0
2002-06-24 11:00:00	NVDA	Stock	0.1829	0.1872	0.1822	0.1837	99972000.0
2002-06-24 12:00:00	NVDA	Stock	0.1838	0.1858	0.1831	0.1853	82644000.0
2002-06-24 13:00:00	NVDA	Stock	0.1852	0.1937	0.1852	0.1926	195096000.0
2002-06-24 14:00:00	NVDA	Stock	0.1926	0.1982	0.1917	0.1982	185676000.0
2002-06-24 15:00:00	NVDA	Stock	0.1982	0.1982	0.19	0.1922	169092000.0
2002-06-24 16:00:00	NVDA	Stock	0.1923	0.1971	0.1884	0.1924	15108000.0
2002-06-24 17:00:00	NVDA	Stock	0.1929	0.195	0.1906	0.195	624000.0
2002-06-24 18:00:00	NVDA	Stock	0.1934	0.1937	0.1927	0.1937	336000.0
2002-06-24 08:00:00	AMZN	Stock	0.8775	0.8825	0.874	0.874	74000.0
2002-06-24 09:00:00	AMZN	Stock	0.8685	0.8725	0.8535	0.855	12162000.0
2002-06-24 10:00:00	AMZN	Stock	0.855	0.8695	0.854	0.865	14210000.0
2002-06-24 11:00:00	AMZN	Stock	0.865	0.8845	0.8625	0.864	10804000.0
2002-06-24 12:00:00	AMZN	Stock	0.864	0.87	0.847	0.8555	17358000.0
2002-06-24 13:00:00	AMZN	Stock	0.8555	0.88	0.855	0.877	13772000.0
2002-06-24 14:00:00	AMZN	Stock	0.8765	0.889	0.8765	0.8815	15854000.0
2002-06-24 15:00:00	AMZN	Stock	0.8815	0.8885	0.875	0.8755	13842000.0
2002-06-24 16:00:00	AMZN	Stock	0.8765	0.8844	0.875	0.8795	1850000.0
2002-06-24 17:00:00	AMZN	Stock	0.8795	0.88	0.8703	0.8765	228000.0
2002-06-24 18:00:00	AMZN	Stock	0.88	0.883	0.88	0.883	32000.0
2002-06-24 09:00:00	CL	Stock	25.125	25.4	25.08	25.13	349400.0
2002-06-24 10:00:00	CL	Stock	25.125	25.14	24.7	24.7	848600.0
2002-06-24 11:00:00	CL	Stock	24.695	24.75	24.455	24.455	720200.0
2002-06-24 12:00:00	CL	Stock	24.475	24.55	24.035	24.17	1121000.0
2002-06-24 13:00:00	CL	Stock	24.15	24.465	24.15	24.325	866000.0
2002-06-24 14:00:00	CL	Stock	24.33	24.64	24.27	24.63	1276000.0

> showing 50 of 19,718 rows — these rows as CSV

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