PREVIEW / stock_1hour / 2003-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-06-24.parquet
  size:    447 KB
  rows:    20,957
  symbols: 1,587

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
2003-06-24 08:00:00	AAPL	Stock	0.3491	0.3534	0.3439	0.3509	2002000.0
2003-06-24 09:00:00	AAPL	Stock	0.3509	0.3513	0.3454	0.3489	77734328.0
2003-06-24 10:00:00	AAPL	Stock	0.3488	0.3502	0.3402	0.3427	70393176.0
2003-06-24 11:00:00	AAPL	Stock	0.3427	0.3463	0.3418	0.3434	32056080.0
2003-06-24 12:00:00	AAPL	Stock	0.3434	0.3466	0.3429	0.3448	48664112.0
2003-06-24 13:00:00	AAPL	Stock	0.3448	0.3454	0.3438	0.345	31272192.0
2003-06-24 14:00:00	AAPL	Stock	0.345	0.3454	0.34	0.3405	72215640.0
2003-06-24 15:00:00	AAPL	Stock	0.3405	0.3411	0.3368	0.3377	81216688.0
2003-06-24 16:00:00	AAPL	Stock	0.3377	0.3426	0.3343	0.3368	27211744.0
2003-06-24 17:00:00	AAPL	Stock	0.3357	0.3368	0.335	0.335	207200.0
2003-06-24 18:00:00	AAPL	Stock	0.335	0.335	0.3339	0.3339	171528.0
2003-06-24 08:00:00	MSFT	Stock	25.82	25.82	25.719	25.75	17040.0
2003-06-24 09:00:00	MSFT	Stock	25.75	25.99	25.46	25.9	5969738.0
2003-06-24 10:00:00	MSFT	Stock	25.9	26.01	25.59	25.7	11232324.0
2003-06-24 11:00:00	MSFT	Stock	25.69	25.885	25.64	25.843	5453506.0
2003-06-24 12:00:00	MSFT	Stock	25.842	25.96	25.75	25.88	4902585.0
2003-06-24 13:00:00	MSFT	Stock	25.87	26.01	25.87	25.99	4013987.0
2003-06-24 14:00:00	MSFT	Stock	26.0	26.03	25.71	25.74	4792987.0
2003-06-24 15:00:00	MSFT	Stock	25.74	25.96	25.71	25.75	8990804.0
2003-06-24 16:00:00	MSFT	Stock	25.75	25.82	25.62	25.7	1096781.0
2003-06-24 17:00:00	MSFT	Stock	25.8135	25.8135	25.69	25.719	186400.0
2003-06-24 18:00:00	MSFT	Stock	25.719	25.719	25.71	25.71	1947.0
2003-06-24 08:00:00	NVDA	Stock	0.1905	0.1911	0.1905	0.1907	336000.0
2003-06-24 09:00:00	NVDA	Stock	0.1907	0.191	0.1857	0.1872	159287040.0
2003-06-24 10:00:00	NVDA	Stock	0.1872	0.1896	0.1838	0.1856	193368480.0
2003-06-24 11:00:00	NVDA	Stock	0.1857	0.186	0.1843	0.1858	71158800.0
2003-06-24 12:00:00	NVDA	Stock	0.1856	0.1904	0.1855	0.19	106542000.0
2003-06-24 13:00:00	NVDA	Stock	0.1898	0.1917	0.1884	0.1917	146052840.0
2003-06-24 14:00:00	NVDA	Stock	0.1916	0.1933	0.189	0.1892	122764320.0
2003-06-24 15:00:00	NVDA	Stock	0.1893	0.1916	0.1884	0.1899	115939680.0
2003-06-24 16:00:00	NVDA	Stock	0.1899	0.1913	0.1891	0.19	7358400.0
2003-06-24 17:00:00	NVDA	Stock	0.1897	0.1903	0.1896	0.1903	1251600.0
2003-06-24 18:00:00	NVDA	Stock	0.1906	0.1915	0.1906	0.1915	384000.0
2003-06-24 08:00:00	AMZN	Stock	1.778	1.7995	1.7775	1.7944	16000.0
2003-06-24 09:00:00	AMZN	Stock	1.779	1.781	1.7655	1.771	16225800.0
2003-06-24 10:00:00	AMZN	Stock	1.771	1.7755	1.727	1.756	52179820.0
2003-06-24 11:00:00	AMZN	Stock	1.7575	1.7575	1.7425	1.747	15252200.0
2003-06-24 12:00:00	AMZN	Stock	1.747	1.7595	1.745	1.7585	8888440.0
2003-06-24 13:00:00	AMZN	Stock	1.7585	1.7802	1.753	1.779	10295720.0
2003-06-24 14:00:00	AMZN	Stock	1.7795	1.78	1.755	1.7603	13229740.0
2003-06-24 15:00:00	AMZN	Stock	1.76	1.791	1.7574	1.7755	31089580.0
2003-06-24 16:00:00	AMZN	Stock	1.777	1.777	1.76	1.7715	620960.0
2003-06-24 17:00:00	AMZN	Stock	1.7566	1.7755	1.7566	1.7675	486000.0
2003-06-24 18:00:00	AMZN	Stock	1.7675	1.7695	1.7675	1.7695	8000.0
2003-06-24 09:00:00	CL	Stock	29.725	29.845	29.7	29.825	250200.0
2003-06-24 10:00:00	CL	Stock	29.815	29.875	29.665	29.825	529800.0
2003-06-24 11:00:00	CL	Stock	29.825	29.89	29.775	29.885	268800.0
2003-06-24 12:00:00	CL	Stock	29.875	29.93	29.86	29.9	152000.0
2003-06-24 13:00:00	CL	Stock	29.9	29.975	29.82	29.97	121400.0
2003-06-24 14:00:00	CL	Stock	29.97	30.1	29.965	30.08	289800.0

> showing 50 of 20,957 rows — these rows as CSV

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