PREVIEW / stock_1hour / 2004-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-18.parquet
  size:    484 KB
  rows:    23,069
  symbols: 1,774

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
2004-05-18 08:00:00	AAPL	Stock	0.4821	0.4821	0.4816	0.482	39200.0
2004-05-18 09:00:00	AAPL	Stock	0.4757	0.4821	0.4757	0.4809	25301640.0
2004-05-18 10:00:00	AAPL	Stock	0.4805	0.4855	0.4786	0.4843	39607008.0
2004-05-18 11:00:00	AAPL	Stock	0.4843	0.4854	0.4821	0.4829	26033784.0
2004-05-18 12:00:00	AAPL	Stock	0.4829	0.4873	0.4818	0.4857	28429408.0
2004-05-18 13:00:00	AAPL	Stock	0.4857	0.4866	0.4836	0.4846	18236512.0
2004-05-18 14:00:00	AAPL	Stock	0.4846	0.4866	0.4832	0.4834	16873584.0
2004-05-18 15:00:00	AAPL	Stock	0.4832	0.4848	0.4821	0.483	34606880.0
2004-05-18 16:00:00	AAPL	Stock	0.4832	0.4854	0.4825	0.483	4618208.0
2004-05-18 17:00:00	AAPL	Stock	0.483	0.4852	0.483	0.4852	78400.0
2004-05-18 18:00:00	AAPL	Stock	0.4848	0.4848	0.4839	0.4839	330400.0
2004-05-18 08:00:00	MSFT	Stock	25.63	25.76	25.63	25.73	38360.0
2004-05-18 09:00:00	MSFT	Stock	25.71	25.75	25.54	25.7	6787191.0
2004-05-18 10:00:00	MSFT	Stock	25.7	25.81	25.65	25.799	7185585.0
2004-05-18 11:00:00	MSFT	Stock	25.8	25.9	25.79	25.88	8025503.0
2004-05-18 12:00:00	MSFT	Stock	25.88	25.97	25.81	25.82	5662765.0
2004-05-18 13:00:00	MSFT	Stock	25.82	25.88	25.73	25.73	6379322.0
2004-05-18 14:00:00	MSFT	Stock	25.73	25.85	25.73	25.81	7184573.0
2004-05-18 15:00:00	MSFT	Stock	25.81	25.95	25.8	25.83	9171948.0
2004-05-18 16:00:00	MSFT	Stock	25.82	25.96	25.8	25.95	5055633.0
2004-05-18 17:00:00	MSFT	Stock	25.83	25.96	25.83	25.91	7755.0
2004-05-18 18:00:00	MSFT	Stock	25.86	25.9	25.86	25.9	300.0
2004-05-18 08:00:00	NVDA	Stock	0.1764	0.1764	0.1764	0.1764	60000.0
2004-05-18 09:00:00	NVDA	Stock	0.1763	0.1808	0.1763	0.1797	52924560.0
2004-05-18 10:00:00	NVDA	Stock	0.18	0.1807	0.1792	0.1802	28029960.0
2004-05-18 11:00:00	NVDA	Stock	0.1803	0.1806	0.18	0.1803	12878280.0
2004-05-18 12:00:00	NVDA	Stock	0.1805	0.1813	0.1797	0.1797	26755920.0
2004-05-18 13:00:00	NVDA	Stock	0.1797	0.1799	0.1787	0.1787	20944440.0
2004-05-18 14:00:00	NVDA	Stock	0.1787	0.1797	0.1787	0.1789	16156560.0
2004-05-18 15:00:00	NVDA	Stock	0.1789	0.1799	0.1787	0.1793	37307400.0
2004-05-18 16:00:00	NVDA	Stock	0.1793	0.1795	0.1785	0.1791	3422160.0
2004-05-18 17:00:00	NVDA	Stock	0.1792	0.1792	0.1785	0.1785	60000.0
2004-05-18 08:00:00	AMZN	Stock	2.104	2.155	2.104	2.155	14000.0
2004-05-18 09:00:00	AMZN	Stock	2.1225	2.131	2.0965	2.0965	18166480.0
2004-05-18 10:00:00	AMZN	Stock	2.0965	2.109	2.096	2.1015	20308000.0
2004-05-18 11:00:00	AMZN	Stock	2.102	2.109	2.096	2.1005	14283180.0
2004-05-18 12:00:00	AMZN	Stock	2.1005	2.1085	2.0985	2.1026	8552680.0
2004-05-18 13:00:00	AMZN	Stock	2.1035	2.105	2.0995	2.101	5510020.0
2004-05-18 14:00:00	AMZN	Stock	2.1	2.105	2.0955	2.0955	8609960.0
2004-05-18 15:00:00	AMZN	Stock	2.0955	2.1	2.0915	2.0995	30145420.0
2004-05-18 16:00:00	AMZN	Stock	2.1	2.1005	2.0875	2.0875	1737020.0
2004-05-18 17:00:00	AMZN	Stock	2.1	2.1	2.0875	2.1	127600.0
2004-05-18 18:00:00	AMZN	Stock	2.09	2.09	2.09	2.09	38000.0
2004-05-18 09:00:00	CL	Stock	28.175	28.23	28.0	28.095	291600.0
2004-05-18 10:00:00	CL	Stock	28.11	28.275	28.045	28.265	363600.0
2004-05-18 11:00:00	CL	Stock	28.26	28.325	28.11	28.135	260200.0
2004-05-18 12:00:00	CL	Stock	28.14	28.15	28.08	28.095	276600.0
2004-05-18 13:00:00	CL	Stock	28.085	28.11	28.02	28.02	184400.0
2004-05-18 14:00:00	CL	Stock	28.0	28.12	27.995	28.11	319800.0
2004-05-18 15:00:00	CL	Stock	28.115	28.15	28.05	28.075	430600.0

> showing 50 of 23,069 rows — these rows as CSV

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