PREVIEW / stock_1hour / 2003-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-18.parquet
  size:    458 KB
  rows:    21,407
  symbols: 1,585

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
2003-07-18 08:00:00	AAPL	Stock	0.3736	0.375	0.3736	0.375	386400.0
2003-07-18 09:00:00	AAPL	Stock	0.3734	0.375	0.3679	0.3686	48933136.0
2003-07-18 10:00:00	AAPL	Stock	0.3686	0.3698	0.3643	0.3686	43032472.0
2003-07-18 11:00:00	AAPL	Stock	0.3689	0.3695	0.3661	0.3675	25624984.0
2003-07-18 12:00:00	AAPL	Stock	0.3675	0.3727	0.3671	0.3727	27279840.0
2003-07-18 13:00:00	AAPL	Stock	0.3725	0.3727	0.3693	0.3704	21914536.0
2003-07-18 14:00:00	AAPL	Stock	0.3704	0.3782	0.3702	0.3759	52336704.0
2003-07-18 15:00:00	AAPL	Stock	0.3761	0.3777	0.3704	0.372	46487784.0
2003-07-18 16:00:00	AAPL	Stock	0.3727	0.3727	0.3705	0.3723	1717912.0
2003-07-18 17:00:00	AAPL	Stock	0.372	0.3723	0.372	0.3723	39200.0
2003-07-18 08:00:00	MSFT	Stock	26.67	27.1	26.55	26.85	673898.0
2003-07-18 09:00:00	MSFT	Stock	26.87	27.23	26.6	27.02	16284704.0
2003-07-18 10:00:00	MSFT	Stock	27.02	27.09	26.75	26.952	11293277.0
2003-07-18 11:00:00	MSFT	Stock	26.96	26.98	26.82	26.87	4127951.0
2003-07-18 12:00:00	MSFT	Stock	26.8799	26.99	26.86	26.892	3971401.0
2003-07-18 13:00:00	MSFT	Stock	26.89	26.91	26.817	26.83	2754868.0
2003-07-18 14:00:00	MSFT	Stock	26.84	27.01	26.83	26.96	4501062.0
2003-07-18 15:00:00	MSFT	Stock	26.9697	27.11	26.838	26.87	13133252.0
2003-07-18 16:00:00	MSFT	Stock	26.92	27.2051	26.85	26.88	830336.0
2003-07-18 17:00:00	MSFT	Stock	26.91	26.9818	26.87	26.87	8519.0
2003-07-18 18:00:00	MSFT	Stock	26.9035	26.92	26.87	26.9	6769.0
2003-07-18 08:00:00	NVDA	Stock	0.1829	0.1829	0.1739	0.1783	9562680.0
2003-07-18 09:00:00	NVDA	Stock	0.1783	0.1803	0.1718	0.1727	209760000.0
2003-07-18 10:00:00	NVDA	Stock	0.1727	0.1753	0.1706	0.1741	262004160.0
2003-07-18 11:00:00	NVDA	Stock	0.1741	0.1776	0.1736	0.1768	130861200.0
2003-07-18 12:00:00	NVDA	Stock	0.1768	0.1782	0.1753	0.1773	104434800.0
2003-07-18 13:00:00	NVDA	Stock	0.1772	0.1773	0.1754	0.1764	67780920.0
2003-07-18 14:00:00	NVDA	Stock	0.1763	0.1786	0.1762	0.1774	96508560.0
2003-07-18 15:00:00	NVDA	Stock	0.1773	0.1788	0.1764	0.1772	249288720.0
2003-07-18 16:00:00	NVDA	Stock	0.1772	0.1775	0.1763	0.1771	17473200.0
2003-07-18 17:00:00	NVDA	Stock	0.1768	0.1779	0.1759	0.1779	1625400.0
2003-07-18 18:00:00	NVDA	Stock	0.1779	0.1779	0.1759	0.1759	451200.0
2003-07-18 08:00:00	AMZN	Stock	1.818	1.818	1.818	1.818	7000.0
2003-07-18 09:00:00	AMZN	Stock	1.819	1.8425	1.7895	1.792	25572240.0
2003-07-18 10:00:00	AMZN	Stock	1.7905	1.8	1.752	1.7635	63471700.0
2003-07-18 11:00:00	AMZN	Stock	1.764	1.7675	1.7395	1.7505	42211320.0
2003-07-18 12:00:00	AMZN	Stock	1.75	1.767	1.748	1.761	27793780.0
2003-07-18 13:00:00	AMZN	Stock	1.761	1.7615	1.7505	1.7545	18583160.0
2003-07-18 14:00:00	AMZN	Stock	1.7548	1.7565	1.749	1.7555	23995960.0
2003-07-18 15:00:00	AMZN	Stock	1.755	1.762	1.745	1.7485	36292620.0
2003-07-18 16:00:00	AMZN	Stock	1.749	1.7515	1.74	1.7475	7801900.0
2003-07-18 17:00:00	AMZN	Stock	1.7475	1.749	1.746	1.7476	180000.0
2003-07-18 09:00:00	CL	Stock	28.0	28.005	27.94	27.98	477600.0
2003-07-18 10:00:00	CL	Stock	27.99	28.07	27.94	27.98	700200.0
2003-07-18 11:00:00	CL	Stock	27.98	28.0	27.88	27.9	493800.0
2003-07-18 12:00:00	CL	Stock	27.9	28.035	27.9	28.025	468000.0
2003-07-18 13:00:00	CL	Stock	28.015	28.025	27.97	27.99	474000.0
2003-07-18 14:00:00	CL	Stock	27.995	28.05	27.975	28.045	479000.0
2003-07-18 15:00:00	CL	Stock	28.05	28.225	28.0475	28.13	784400.0
2003-07-18 16:00:00	CL	Stock	28.135	28.15	28.135	28.15	118800.0

> showing 50 of 21,407 rows — these rows as CSV

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