PREVIEW / stock_1hour / 2005-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-26.parquet
  size:    531 KB
  rows:    25,000
  symbols: 1,914

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
2005-01-26 08:00:00	AAPL	Stock	1.2945	1.2973	1.2916	1.2923	1762488.0
2005-01-26 09:00:00	AAPL	Stock	1.2929	1.3004	1.2777	1.2807	100324840.0
2005-01-26 10:00:00	AAPL	Stock	1.2805	1.292	1.2718	1.2882	194666808.0
2005-01-26 11:00:00	AAPL	Stock	1.2886	1.2964	1.2795	1.2866	145865888.0
2005-01-26 12:00:00	AAPL	Stock	1.2866	1.2938	1.2855	1.2876	54672408.0
2005-01-26 13:00:00	AAPL	Stock	1.2877	1.2955	1.2861	1.2936	53739672.0
2005-01-26 14:00:00	AAPL	Stock	1.293	1.2943	1.2845	1.2879	69239352.0
2005-01-26 15:00:00	AAPL	Stock	1.288	1.2973	1.2857	1.29	104127576.0
2005-01-26 16:00:00	AAPL	Stock	1.2896	1.2902	1.2875	1.2898	6184472.0
2005-01-26 17:00:00	AAPL	Stock	1.2902	1.2902	1.2895	1.2895	4657912.0
2005-01-26 18:00:00	AAPL	Stock	1.2891	1.2896	1.2888	1.2888	48888.0
2005-01-26 08:00:00	MSFT	Stock	26.14	26.14	26.09	26.09	149575.0
2005-01-26 09:00:00	MSFT	Stock	26.08	26.17	26.02	26.05	7383326.0
2005-01-26 10:00:00	MSFT	Stock	26.04	26.11	25.939	25.96	11113373.0
2005-01-26 11:00:00	MSFT	Stock	25.96	26.02	25.9	25.96	8697346.0
2005-01-26 12:00:00	MSFT	Stock	25.95	26.03	25.93	25.99	7532071.0
2005-01-26 13:00:00	MSFT	Stock	26.0	26.05	25.98	26.01	5888025.0
2005-01-26 14:00:00	MSFT	Stock	26.01	26.05	25.95	26.01	8125157.0
2005-01-26 15:00:00	MSFT	Stock	26.02	26.07	25.97	26.01	14816307.0
2005-01-26 16:00:00	MSFT	Stock	26.0	26.02	25.95	25.96	696164.0
2005-01-26 17:00:00	MSFT	Stock	25.99	26.01	25.99	26.0	4800.0
2005-01-26 18:00:00	MSFT	Stock	25.97	26.01	25.97	26.0	1790.0
2005-01-26 08:00:00	NVDA	Stock	0.1754	0.1754	0.1754	0.1754	48000.0
2005-01-26 09:00:00	NVDA	Stock	0.1746	0.1792	0.1746	0.1773	45732000.0
2005-01-26 10:00:00	NVDA	Stock	0.1773	0.1782	0.1737	0.1751	103801680.0
2005-01-26 11:00:00	NVDA	Stock	0.1751	0.1758	0.1722	0.1733	70842480.0
2005-01-26 12:00:00	NVDA	Stock	0.1733	0.1738	0.1728	0.1734	20256600.0
2005-01-26 13:00:00	NVDA	Stock	0.1735	0.1747	0.1734	0.1745	30140280.0
2005-01-26 14:00:00	NVDA	Stock	0.1747	0.1762	0.1739	0.1747	60930480.0
2005-01-26 15:00:00	NVDA	Stock	0.1747	0.1771	0.1742	0.1767	90874800.0
2005-01-26 16:00:00	NVDA	Stock	0.1767	0.1781	0.1762	0.1762	4617120.0
2005-01-26 17:00:00	NVDA	Stock	0.1762	0.1763	0.1762	0.1762	852000.0
2005-01-26 18:00:00	NVDA	Stock	0.176	0.1767	0.1759	0.1767	235200.0
2005-01-26 08:00:00	AMZN	Stock	2.06	2.06	2.06	2.06	74000.0
2005-01-26 09:00:00	AMZN	Stock	2.0625	2.0685	2.013	2.0345	30647520.0
2005-01-26 10:00:00	AMZN	Stock	2.037	2.0745	2.036	2.0525	37555540.0
2005-01-26 11:00:00	AMZN	Stock	2.053	2.066	2.04	2.047	25995360.0
2005-01-26 12:00:00	AMZN	Stock	2.0475	2.0545	2.041	2.043	9582820.0
2005-01-26 13:00:00	AMZN	Stock	2.043	2.0545	2.0365	2.05	11358380.0
2005-01-26 14:00:00	AMZN	Stock	2.051	2.067	2.046	2.067	11279100.0
2005-01-26 15:00:00	AMZN	Stock	2.0665	2.09	2.0595	2.0665	25341440.0
2005-01-26 16:00:00	AMZN	Stock	2.0665	2.071	2.066	2.068	574860.0
2005-01-26 17:00:00	AMZN	Stock	2.067	2.0715	2.067	2.069	48000.0
2005-01-26 18:00:00	AMZN	Stock	2.067	2.0715	2.0668	2.0715	140200.0
2005-01-26 09:00:00	CL	Stock	25.0	25.08	24.995	25.055	401800.0
2005-01-26 10:00:00	CL	Stock	25.055	25.1	24.98	25.075	377600.0
2005-01-26 11:00:00	CL	Stock	25.075	25.175	25.035	25.135	611400.0
2005-01-26 12:00:00	CL	Stock	25.14	25.195	24.945	24.96	316800.0
2005-01-26 13:00:00	CL	Stock	24.96	24.995	24.925	24.995	622000.0
2005-01-26 14:00:00	CL	Stock	24.99	25.035	24.935	25.03	365800.0

> showing 50 of 25,000 rows — these rows as CSV

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