PREVIEW / stock_1hour / 2001-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-02-09.parquet
  size:    356 KB
  rows:    16,383
  symbols: 1,268

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-02-09 08:00:00	AAPL	Stock	0.37	0.37	0.3666	0.3666	2144800.0
2001-02-09 09:00:00	AAPL	Stock	0.3661	0.3717	0.3638	0.3661	36780800.0
2001-02-09 10:00:00	AAPL	Stock	0.3661	0.3677	0.3605	0.3616	39692800.0
2001-02-09 11:00:00	AAPL	Stock	0.3616	0.3627	0.3482	0.3516	199130400.0
2001-02-09 12:00:00	AAPL	Stock	0.3504	0.3571	0.3471	0.3493	54672800.0
2001-02-09 13:00:00	AAPL	Stock	0.3493	0.3516	0.3393	0.3426	54264000.0
2001-02-09 14:00:00	AAPL	Stock	0.3426	0.3449	0.3404	0.3404	60676000.0
2001-02-09 15:00:00	AAPL	Stock	0.3404	0.3438	0.3337	0.3426	126039200.0
2001-02-09 16:00:00	AAPL	Stock	0.3415	0.3504	0.3371	0.3415	9262400.0
2001-02-09 17:00:00	AAPL	Stock	0.3415	0.3415	0.3415	0.3415	487200.0
2001-02-09 08:00:00	MSFT	Stock	30.8125	31.125	30.6562	30.8438	160000.0
2001-02-09 09:00:00	MSFT	Stock	30.8125	30.875	30.3438	30.5312	13951800.0
2001-02-09 10:00:00	MSFT	Stock	30.5	30.7812	30.125	30.3125	12797000.0
2001-02-09 11:00:00	MSFT	Stock	30.3125	30.3438	29.8125	30.0312	15613400.0
2001-02-09 12:00:00	MSFT	Stock	30.0312	30.1875	29.75	29.7812	9635400.0
2001-02-09 13:00:00	MSFT	Stock	29.8125	30.0625	29.6562	29.7812	13426400.0
2001-02-09 14:00:00	MSFT	Stock	29.75	29.9062	29.5312	29.5312	11602000.0
2001-02-09 15:00:00	MSFT	Stock	29.5312	29.7188	29.25	29.5312	17694800.0
2001-02-09 16:00:00	MSFT	Stock	29.5312	29.9688	29.3438	29.8125	2778600.0
2001-02-09 17:00:00	MSFT	Stock	29.4375	29.5625	29.4375	29.4688	274400.0
2001-02-09 18:00:00	MSFT	Stock	29.5	29.5	29.3125	29.375	4400.0
2001-02-09 08:00:00	NVDA	Stock	0.1874	0.1874	0.1874	0.1874	24000.0
2001-02-09 09:00:00	NVDA	Stock	0.1859	0.1865	0.1792	0.1802	35232000.0
2001-02-09 10:00:00	NVDA	Stock	0.1802	0.1854	0.1794	0.1802	45456000.0
2001-02-09 11:00:00	NVDA	Stock	0.1818	0.1818	0.1779	0.1785	32808000.0
2001-02-09 12:00:00	NVDA	Stock	0.1784	0.1831	0.1784	0.1818	20328000.0
2001-02-09 13:00:00	NVDA	Stock	0.1818	0.1854	0.181	0.182	34272000.0
2001-02-09 14:00:00	NVDA	Stock	0.1826	0.1833	0.1807	0.1823	25200000.0
2001-02-09 15:00:00	NVDA	Stock	0.1826	0.1857	0.1802	0.1849	46992000.0
2001-02-09 16:00:00	NVDA	Stock	0.1846	0.1854	0.181	0.1849	17856000.0
2001-02-09 08:00:00	AMZN	Stock	0.7188	0.7188	0.7188	0.7188	10000.0
2001-02-09 09:00:00	AMZN	Stock	0.725	0.7375	0.7156	0.7219	9204000.0
2001-02-09 10:00:00	AMZN	Stock	0.725	0.7313	0.7125	0.7156	16854000.0
2001-02-09 11:00:00	AMZN	Stock	0.7188	0.725	0.7	0.7062	21786000.0
2001-02-09 12:00:00	AMZN	Stock	0.7062	0.7125	0.7	0.7094	18950000.0
2001-02-09 13:00:00	AMZN	Stock	0.7031	0.7094	0.6969	0.6969	12184000.0
2001-02-09 14:00:00	AMZN	Stock	0.6969	0.7	0.6812	0.6844	22748000.0
2001-02-09 15:00:00	AMZN	Stock	0.6875	0.6875	0.6688	0.6688	41432000.0
2001-02-09 16:00:00	AMZN	Stock	0.6688	0.675	0.6625	0.675	2668000.0
2001-02-09 17:00:00	AMZN	Stock	0.6688	0.675	0.6625	0.675	36000.0
2001-02-09 18:00:00	AMZN	Stock	0.675	0.675	0.6625	0.675	58000.0
2001-02-09 09:00:00	CL	Stock	30.04	30.05	29.725	29.935	406400.0
2001-02-09 10:00:00	CL	Stock	29.935	29.935	29.74	29.77	272200.0
2001-02-09 11:00:00	CL	Stock	29.77	29.875	29.75	29.875	237800.0
2001-02-09 12:00:00	CL	Stock	29.895	29.895	29.785	29.82	127600.0
2001-02-09 13:00:00	CL	Stock	29.82	29.88	29.775	29.87	403200.0
2001-02-09 14:00:00	CL	Stock	29.86	29.875	29.725	29.725	339200.0
2001-02-09 15:00:00	CL	Stock	29.7	29.745	29.6	29.69	370600.0
2001-02-09 16:00:00	CL	Stock	29.69	29.81	29.69	29.81	38800.0

> showing 49 of 16,383 rows — these rows as CSV

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