PREVIEW / stock_1hour / 2001-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-29.parquet
  size:    360 KB
  rows:    16,625
  symbols: 1,274

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
2001-01-29 08:00:00	AAPL	Stock	0.3516	0.3516	0.3482	0.3504	162400.0
2001-01-29 09:00:00	AAPL	Stock	0.346	0.3638	0.346	0.3616	62546400.0
2001-01-29 10:00:00	AAPL	Stock	0.3616	0.3694	0.3605	0.3683	156312800.0
2001-01-29 11:00:00	AAPL	Stock	0.3672	0.3728	0.3672	0.3705	120237600.0
2001-01-29 12:00:00	AAPL	Stock	0.3705	0.3783	0.3694	0.3728	122578400.0
2001-01-29 13:00:00	AAPL	Stock	0.3728	0.3817	0.3717	0.3817	78142400.0
2001-01-29 14:00:00	AAPL	Stock	0.3806	0.3884	0.3795	0.3828	147806400.0
2001-01-29 15:00:00	AAPL	Stock	0.3828	0.3884	0.3806	0.3873	109704000.0
2001-01-29 16:00:00	AAPL	Stock	0.3878	0.3906	0.3711	0.3873	9430400.0
2001-01-29 17:00:00	AAPL	Stock	0.3873	0.3873	0.385	0.385	789600.0
2001-01-29 18:00:00	AAPL	Stock	0.3839	0.3839	0.3839	0.3839	5600.0
2001-01-29 08:00:00	MSFT	Stock	31.7031	31.9844	31.5	31.75	70600.0
2001-01-29 09:00:00	MSFT	Stock	31.75	32.0	31.5625	31.7812	8103000.0
2001-01-29 10:00:00	MSFT	Stock	31.7812	31.8438	31.5938	31.7812	7089400.0
2001-01-29 11:00:00	MSFT	Stock	31.75	32.25	31.6875	32.1562	8104200.0
2001-01-29 12:00:00	MSFT	Stock	32.1875	32.2188	31.875	31.9375	6055000.0
2001-01-29 13:00:00	MSFT	Stock	31.9375	32.0938	31.9062	32.0312	7061600.0
2001-01-29 14:00:00	MSFT	Stock	32.0312	32.1875	32.0	32.0625	11076800.0
2001-01-29 15:00:00	MSFT	Stock	32.0625	32.3125	31.8281	32.2812	20208200.0
2001-01-29 16:00:00	MSFT	Stock	32.2812	32.375	31.6562	32.25	4736400.0
2001-01-29 17:00:00	MSFT	Stock	32.1875	32.375	32.1875	32.375	8064800.0
2001-01-29 18:00:00	MSFT	Stock	32.3438	32.3438	32.1875	32.1875	2200.0
2001-01-29 08:00:00	NVDA	Stock	0.2104	0.2104	0.2104	0.2104	24000.0
2001-01-29 09:00:00	NVDA	Stock	0.2099	0.2099	0.1979	0.2026	50736000.0
2001-01-29 10:00:00	NVDA	Stock	0.2022	0.2043	0.1995	0.2042	31032000.0
2001-01-29 11:00:00	NVDA	Stock	0.2036	0.2063	0.1979	0.2055	58224000.0
2001-01-29 12:00:00	NVDA	Stock	0.2052	0.2055	0.2005	0.2021	18096000.0
2001-01-29 13:00:00	NVDA	Stock	0.2031	0.2068	0.2026	0.2063	28992000.0
2001-01-29 14:00:00	NVDA	Stock	0.2068	0.212	0.2063	0.2102	61176000.0
2001-01-29 15:00:00	NVDA	Stock	0.2096	0.213	0.2076	0.2112	54168000.0
2001-01-29 16:00:00	NVDA	Stock	0.2125	0.213	0.2094	0.2122	6240000.0
2001-01-29 08:00:00	AMZN	Stock	0.9875	0.9875	0.9375	0.9438	536000.0
2001-01-29 09:00:00	AMZN	Stock	0.9406	0.9906	0.9375	0.9906	14152000.0
2001-01-29 10:00:00	AMZN	Stock	0.9844	1.0219	0.9781	1.0109	23810000.0
2001-01-29 11:00:00	AMZN	Stock	1.0125	1.0375	1.0062	1.025	22198000.0
2001-01-29 12:00:00	AMZN	Stock	1.025	1.0281	1.0094	1.0141	9658000.0
2001-01-29 13:00:00	AMZN	Stock	1.0156	1.0219	0.9938	1.0188	18048000.0
2001-01-29 14:00:00	AMZN	Stock	1.0156	1.0281	0.975	0.9781	29814000.0
2001-01-29 15:00:00	AMZN	Stock	0.9781	1.0094	0.9719	1.0062	22376000.0
2001-01-29 16:00:00	AMZN	Stock	1.0094	1.025	1.0047	1.0125	3264000.0
2001-01-29 17:00:00	AMZN	Stock	1.0125	1.0172	1.0062	1.0172	172000.0
2001-01-29 18:00:00	AMZN	Stock	1.0188	1.0219	1.0125	1.0203	138000.0
2001-01-29 09:00:00	CL	Stock	28.51	28.575	28.0	28.0	337600.0
2001-01-29 10:00:00	CL	Stock	27.95	28.125	27.875	28.115	455400.0
2001-01-29 11:00:00	CL	Stock	28.1	28.3	28.05	28.125	271000.0
2001-01-29 12:00:00	CL	Stock	28.125	28.125	28.05	28.085	204400.0
2001-01-29 13:00:00	CL	Stock	28.065	28.125	27.925	28.075	247400.0
2001-01-29 14:00:00	CL	Stock	28.05	28.055	27.935	27.99	291200.0
2001-01-29 15:00:00	CL	Stock	28.0	28.2	27.95	28.185	579400.0
2001-01-29 16:00:00	CL	Stock	28.19	28.19	28.055	28.19	42000.0

> showing 50 of 16,625 rows — these rows as CSV

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