PREVIEW / stock_1hour / 2000-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-03-27.parquet
  size:    278 KB
  rows:    14,386
  symbols: 1,147

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
2000-03-27 09:00:00	AAPL	Stock	1.2288	1.2511	1.2221	1.2402	36332800.0
2000-03-27 10:00:00	AAPL	Stock	1.2416	1.2684	1.2338	1.2444	50321600.0
2000-03-27 11:00:00	AAPL	Stock	1.2444	1.2768	1.2433	1.2667	41563200.0
2000-03-27 12:00:00	AAPL	Stock	1.2673	1.2824	1.2662	1.2796	22624000.0
2000-03-27 13:00:00	AAPL	Stock	1.2796	1.2893	1.2768	1.2877	21660800.0
2000-03-27 14:00:00	AAPL	Stock	1.2885	1.2924	1.2628	1.2765	39099200.0
2000-03-27 15:00:00	AAPL	Stock	1.2779	1.2779	1.2411	1.2455	52796800.0
2000-03-27 16:00:00	AAPL	Stock	1.2422	1.2461	1.2422	1.2461	750400.0
2000-03-27 09:00:00	MSFT	Stock	53.875	54.0312	52.75	52.875	21321000.0
2000-03-27 10:00:00	MSFT	Stock	52.875	53.25	52.375	52.5	18522600.0
2000-03-27 11:00:00	MSFT	Stock	52.4688	53.75	52.375	53.6562	16928400.0
2000-03-27 12:00:00	MSFT	Stock	53.6562	54.125	53.3125	53.5938	8696600.0
2000-03-27 13:00:00	MSFT	Stock	53.625	53.6562	52.8125	53.0312	7770800.0
2000-03-27 14:00:00	MSFT	Stock	52.9688	53.0625	52.4062	52.5625	11827000.0
2000-03-27 15:00:00	MSFT	Stock	52.5938	52.6562	51.9688	52.0312	17913600.0
2000-03-27 16:00:00	MSFT	Stock	52.0312	52.0312	52.0	52.0312	71400.0
2000-03-27 09:00:00	NVDA	Stock	0.1937	0.2	0.1926	0.1982	33648000.0
2000-03-27 10:00:00	NVDA	Stock	0.1982	0.1984	0.1867	0.1867	90528000.0
2000-03-27 11:00:00	NVDA	Stock	0.1883	0.1911	0.1857	0.1884	40368000.0
2000-03-27 12:00:00	NVDA	Stock	0.1891	0.1907	0.1885	0.1901	22224000.0
2000-03-27 13:00:00	NVDA	Stock	0.1887	0.1902	0.1884	0.1889	29328000.0
2000-03-27 14:00:00	NVDA	Stock	0.1889	0.1896	0.1833	0.1846	59856000.0
2000-03-27 15:00:00	NVDA	Stock	0.1846	0.1846	0.1797	0.1814	85824000.0
2000-03-27 16:00:00	NVDA	Stock	0.1812	0.1814	0.1812	0.1814	1632000.0
2000-03-27 09:00:00	AMZN	Stock	3.6125	3.65	3.5875	3.6281	10208000.0
2000-03-27 10:00:00	AMZN	Stock	3.6281	3.725	3.6219	3.6375	19614000.0
2000-03-27 11:00:00	AMZN	Stock	3.625	3.7	3.625	3.6781	10544000.0
2000-03-27 12:00:00	AMZN	Stock	3.6781	3.6875	3.6594	3.675	3710000.0
2000-03-27 13:00:00	AMZN	Stock	3.6734	3.7188	3.6734	3.6969	12776000.0
2000-03-27 14:00:00	AMZN	Stock	3.6969	3.75	3.6875	3.7406	16168000.0
2000-03-27 15:00:00	AMZN	Stock	3.7406	3.7562	3.65	3.6594	18460000.0
2000-03-27 16:00:00	AMZN	Stock	3.6562	3.6594	3.6562	3.6594	276000.0
2000-03-27 09:00:00	CL	Stock	27.5	27.75	27.4375	27.4375	408400.0
2000-03-27 10:00:00	CL	Stock	27.4375	27.4375	27.0	27.1875	616400.0
2000-03-27 11:00:00	CL	Stock	27.2188	27.2812	26.9688	27.0625	388400.0
2000-03-27 12:00:00	CL	Stock	27.0625	27.5	27.0625	27.5	378600.0
2000-03-27 13:00:00	CL	Stock	27.5	27.5	27.2812	27.375	284400.0
2000-03-27 14:00:00	CL	Stock	27.4062	27.5	27.25	27.25	441400.0
2000-03-27 15:00:00	CL	Stock	27.2812	27.2812	27.0312	27.0938	686200.0
2000-03-27 16:00:00	CL	Stock	27.0938	27.5	27.0938	27.0938	124600.0

> showing 40 of 14,386 rows — these rows as CSV

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