PREVIEW / stock_1hour / 2003-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-11-18.parquet
  size:    487 KB
  rows:    22,524
  symbols: 1,670

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-11-18 08:00:00	AAPL	Stock	0.3866	0.3866	0.3855	0.3857	33600.0
2003-11-18 09:00:00	AAPL	Stock	0.3786	0.3811	0.3771	0.3796	15090320.0
2003-11-18 10:00:00	AAPL	Stock	0.3798	0.3798	0.3732	0.3763	32451328.0
2003-11-18 11:00:00	AAPL	Stock	0.3763	0.3798	0.3752	0.3782	21009968.0
2003-11-18 12:00:00	AAPL	Stock	0.378	0.3786	0.3759	0.3766	24004624.0
2003-11-18 13:00:00	AAPL	Stock	0.3771	0.3771	0.3698	0.3702	30955120.0
2003-11-18 14:00:00	AAPL	Stock	0.3702	0.3727	0.3686	0.3689	29118824.0
2003-11-18 15:00:00	AAPL	Stock	0.3693	0.3696	0.3634	0.3634	86854376.0
2003-11-18 16:00:00	AAPL	Stock	0.3634	0.3659	0.3618	0.3639	6164648.0
2003-11-18 17:00:00	AAPL	Stock	0.364	0.3681	0.3639	0.3681	1824480.0
2003-11-18 08:00:00	MSFT	Stock	25.15	25.42	25.1	25.34	347790.0
2003-11-18 09:00:00	MSFT	Stock	25.32	25.4	25.21	25.329	7120992.0
2003-11-18 10:00:00	MSFT	Stock	25.32	25.62	25.23	25.62	16078369.0
2003-11-18 11:00:00	MSFT	Stock	25.62	25.81	25.55	25.59	18347026.0
2003-11-18 12:00:00	MSFT	Stock	25.59	25.64	25.51	25.58	7234146.0
2003-11-18 13:00:00	MSFT	Stock	25.58	25.64	25.37	25.4	8599858.0
2003-11-18 14:00:00	MSFT	Stock	25.4	25.4	25.25	25.34	14261688.0
2003-11-18 15:00:00	MSFT	Stock	25.34	25.36	25.14	25.16	18638008.0
2003-11-18 16:00:00	MSFT	Stock	25.16	25.2	25.11	25.18	6041456.0
2003-11-18 17:00:00	MSFT	Stock	25.18	25.2	25.1457	25.19	284406.0
2003-11-18 18:00:00	MSFT	Stock	25.19	25.4133	25.17	25.19	3047260.0
2003-11-18 08:00:00	NVDA	Stock	0.1673	0.1707	0.1673	0.17	4212000.0
2003-11-18 09:00:00	NVDA	Stock	0.1702	0.1725	0.1663	0.1711	188053320.0
2003-11-18 10:00:00	NVDA	Stock	0.1711	0.1712	0.1692	0.1702	167384880.0
2003-11-18 11:00:00	NVDA	Stock	0.1702	0.1706	0.1695	0.1695	97449600.0
2003-11-18 12:00:00	NVDA	Stock	0.1695	0.17	0.1691	0.1692	51370920.0
2003-11-18 13:00:00	NVDA	Stock	0.1693	0.1698	0.1683	0.1686	64805880.0
2003-11-18 14:00:00	NVDA	Stock	0.1686	0.1692	0.1671	0.1672	83829360.0
2003-11-18 15:00:00	NVDA	Stock	0.1672	0.1674	0.1636	0.1638	153054360.0
2003-11-18 16:00:00	NVDA	Stock	0.1636	0.1654	0.1633	0.1636	8822400.0
2003-11-18 17:00:00	NVDA	Stock	0.1636	0.1642	0.1635	0.1642	2142720.0
2003-11-18 18:00:00	NVDA	Stock	0.1642	0.1687	0.1641	0.1642	137681760.0
2003-11-18 08:00:00	AMZN	Stock	2.5325	2.5365	2.53	2.535	234000.0
2003-11-18 09:00:00	AMZN	Stock	2.535	2.5489	2.508	2.5275	33460860.0
2003-11-18 10:00:00	AMZN	Stock	2.5275	2.539	2.4975	2.5075	41488600.0
2003-11-18 11:00:00	AMZN	Stock	2.5075	2.534	2.5041	2.515	22803620.0
2003-11-18 12:00:00	AMZN	Stock	2.5155	2.518	2.5005	2.5075	12148060.0
2003-11-18 13:00:00	AMZN	Stock	2.5075	2.5125	2.468	2.471	20680480.0
2003-11-18 14:00:00	AMZN	Stock	2.473	2.489	2.4435	2.452	41627980.0
2003-11-18 15:00:00	AMZN	Stock	2.452	2.455	2.4225	2.4235	58641620.0
2003-11-18 16:00:00	AMZN	Stock	2.427	2.432	2.403	2.4205	2043960.0
2003-11-18 17:00:00	AMZN	Stock	2.4185	2.4267	2.4155	2.4185	333040.0
2003-11-18 18:00:00	AMZN	Stock	2.4175	2.4185	2.4175	2.4175	112260.0
2003-11-18 09:00:00	CL	Stock	26.025	26.085	25.91	26.07	320400.0
2003-11-18 10:00:00	CL	Stock	26.065	26.11	26.025	26.095	995600.0
2003-11-18 11:00:00	CL	Stock	26.09	26.09	26.0	26.0	696600.0
2003-11-18 12:00:00	CL	Stock	26.0	26.03	25.915	25.945	610800.0
2003-11-18 13:00:00	CL	Stock	25.94	25.945	25.83	25.84	518400.0
2003-11-18 14:00:00	CL	Stock	25.84	25.88	25.71	25.725	766600.0
2003-11-18 15:00:00	CL	Stock	25.725	25.8	25.695	25.695	981600.0

> showing 50 of 22,524 rows — these rows as CSV

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