PREVIEW / stock_1hour / 2003-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-05-27.parquet
  size:    454 KB
  rows:    21,962
  symbols: 1,574

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-05-27 08:00:00	AAPL	Stock	0.3237	0.3248	0.3205	0.3206	1436680.0
2003-05-27 09:00:00	AAPL	Stock	0.3204	0.327	0.3198	0.3257	38250464.0
2003-05-27 10:00:00	AAPL	Stock	0.3255	0.3339	0.3238	0.3338	54778472.0
2003-05-27 11:00:00	AAPL	Stock	0.3338	0.3357	0.3327	0.3339	37985864.0
2003-05-27 12:00:00	AAPL	Stock	0.3339	0.3357	0.3332	0.334	19671680.0
2003-05-27 13:00:00	AAPL	Stock	0.3341	0.3352	0.333	0.3336	29967448.0
2003-05-27 14:00:00	AAPL	Stock	0.3338	0.3352	0.3327	0.335	27911184.0
2003-05-27 15:00:00	AAPL	Stock	0.335	0.3375	0.3345	0.3375	38403624.0
2003-05-27 16:00:00	AAPL	Stock	0.3371	0.3375	0.3345	0.3364	5512640.0
2003-05-27 18:00:00	AAPL	Stock	0.3365	0.3371	0.3365	0.3371	168000.0
2003-05-27 08:00:00	MSFT	Stock	24.15	24.26	24.11	24.18	378430.0
2003-05-27 09:00:00	MSFT	Stock	24.18	24.45	24.18	24.381	8229861.0
2003-05-27 10:00:00	MSFT	Stock	24.39	24.65	24.33	24.65	14178008.0
2003-05-27 11:00:00	MSFT	Stock	24.64	24.75	24.6	24.699	8592115.0
2003-05-27 12:00:00	MSFT	Stock	24.7	24.76	24.66	24.7	7881613.0
2003-05-27 13:00:00	MSFT	Stock	24.7	24.804	24.64	24.73	5698482.0
2003-05-27 14:00:00	MSFT	Stock	24.723	24.82	24.66	24.81	5724575.0
2003-05-27 15:00:00	MSFT	Stock	24.81	24.89	24.74	24.78	10077297.0
2003-05-27 16:00:00	MSFT	Stock	24.78	24.82	24.25	24.75	838747.0
2003-05-27 17:00:00	MSFT	Stock	24.79	24.79	24.71	24.75	59180.0
2003-05-27 18:00:00	MSFT	Stock	24.87	24.87	24.75	24.79	23185.0
2003-05-27 08:00:00	NVDA	Stock	0.174	0.1742	0.1726	0.1726	1026000.0
2003-05-27 09:00:00	NVDA	Stock	0.1739	0.1742	0.1707	0.1729	118499880.0
2003-05-27 10:00:00	NVDA	Stock	0.173	0.1792	0.1721	0.1789	232005360.0
2003-05-27 11:00:00	NVDA	Stock	0.1789	0.1814	0.1779	0.1807	171549360.0
2003-05-27 12:00:00	NVDA	Stock	0.1808	0.1872	0.1806	0.1863	328388760.0
2003-05-27 13:00:00	NVDA	Stock	0.1862	0.1887	0.1852	0.1863	257648040.0
2003-05-27 14:00:00	NVDA	Stock	0.1862	0.1882	0.1861	0.188	107714760.0
2003-05-27 15:00:00	NVDA	Stock	0.188	0.19	0.1871	0.1892	331417800.0
2003-05-27 16:00:00	NVDA	Stock	0.1892	0.1894	0.1883	0.189	14020080.0
2003-05-27 17:00:00	NVDA	Stock	0.1892	0.1893	0.1888	0.1892	760680.0
2003-05-27 18:00:00	NVDA	Stock	0.1897	0.1897	0.189	0.1892	1920000.0
2003-05-27 08:00:00	AMZN	Stock	1.6325	1.6325	1.6325	1.6325	20000.0
2003-05-27 09:00:00	AMZN	Stock	1.638	1.6585	1.6225	1.655	19181420.0
2003-05-27 10:00:00	AMZN	Stock	1.655	1.74	1.652	1.73	74142240.0
2003-05-27 11:00:00	AMZN	Stock	1.73	1.735	1.7215	1.7225	24895860.0
2003-05-27 12:00:00	AMZN	Stock	1.723	1.737	1.7225	1.7255	18749220.0
2003-05-27 13:00:00	AMZN	Stock	1.7255	1.726	1.712	1.7215	21908560.0
2003-05-27 14:00:00	AMZN	Stock	1.7215	1.7375	1.716	1.7345	18371660.0
2003-05-27 15:00:00	AMZN	Stock	1.7345	1.7515	1.7305	1.743	46257600.0
2003-05-27 16:00:00	AMZN	Stock	1.742	1.747	1.74	1.742	2020860.0
2003-05-27 17:00:00	AMZN	Stock	1.741	1.745	1.7406	1.743	195260.0
2003-05-27 18:00:00	AMZN	Stock	1.739	1.7455	1.739	1.745	98280.0
2003-05-27 09:00:00	CL	Stock	29.3	29.515	29.25	29.505	326200.0
2003-05-27 10:00:00	CL	Stock	29.5	29.52	29.395	29.4	691400.0
2003-05-27 11:00:00	CL	Stock	29.4	29.4	29.25	29.27	475200.0
2003-05-27 12:00:00	CL	Stock	29.27	29.44	29.27	29.425	463800.0
2003-05-27 13:00:00	CL	Stock	29.43	29.51	29.42	29.445	336200.0
2003-05-27 14:00:00	CL	Stock	29.44	29.52	29.37	29.505	421000.0
2003-05-27 15:00:00	CL	Stock	29.51	29.51	29.44	29.475	685800.0

> showing 50 of 21,962 rows — these rows as CSV

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