PREVIEW / stock_1hour / 2003-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-21.parquet
  size:    460 KB
  rows:    22,098
  symbols: 1,583

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-21 08:00:00	AAPL	Stock	0.3714	0.3714	0.3714	0.3714	5600.0
2003-07-21 09:00:00	AAPL	Stock	0.3718	0.3718	0.367	0.3702	25589144.0
2003-07-21 10:00:00	AAPL	Stock	0.37	0.3702	0.3643	0.3654	39628008.0
2003-07-21 11:00:00	AAPL	Stock	0.3654	0.3663	0.3625	0.363	28669256.0
2003-07-21 12:00:00	AAPL	Stock	0.363	0.3648	0.363	0.3641	14022512.0
2003-07-21 13:00:00	AAPL	Stock	0.3641	0.3663	0.3641	0.3659	10328304.0
2003-07-21 14:00:00	AAPL	Stock	0.3654	0.3663	0.3632	0.3643	19807592.0
2003-07-21 15:00:00	AAPL	Stock	0.3648	0.3682	0.363	0.368	27062280.0
2003-07-21 16:00:00	AAPL	Stock	0.368	0.3688	0.367	0.368	2492000.0
2003-07-21 17:00:00	AAPL	Stock	0.368	0.368	0.3678	0.368	1747200.0
2003-07-21 08:00:00	MSFT	Stock	26.95	27.01	26.89	26.9	51230.0
2003-07-21 09:00:00	MSFT	Stock	26.9	26.93	26.51	26.52	5907031.0
2003-07-21 10:00:00	MSFT	Stock	26.52	26.53	26.1399	26.162	10005614.0
2003-07-21 11:00:00	MSFT	Stock	26.161	26.22	26.06	26.08	5597146.0
2003-07-21 12:00:00	MSFT	Stock	26.08	26.21	26.06	26.17	3374047.0
2003-07-21 13:00:00	MSFT	Stock	26.17	26.21	26.1	26.14	2909523.0
2003-07-21 14:00:00	MSFT	Stock	26.14	26.25	26.05	26.08	5990688.0
2003-07-21 15:00:00	MSFT	Stock	26.09	26.15	26.01	26.04	8824891.0
2003-07-21 16:00:00	MSFT	Stock	26.04	26.07	26.01	26.04	379289.0
2003-07-21 17:00:00	MSFT	Stock	26.05	26.678	26.04	26.12	636700.0
2003-07-21 18:00:00	MSFT	Stock	26.135	26.135	26.11	26.12	8846.0
2003-07-21 08:00:00	NVDA	Stock	0.1758	0.1772	0.1758	0.1767	198000.0
2003-07-21 09:00:00	NVDA	Stock	0.1767	0.1787	0.1751	0.1772	124932240.0
2003-07-21 10:00:00	NVDA	Stock	0.1772	0.1773	0.1708	0.1726	211724760.0
2003-07-21 11:00:00	NVDA	Stock	0.1726	0.1727	0.1703	0.1716	117339840.0
2003-07-21 12:00:00	NVDA	Stock	0.1717	0.1728	0.1711	0.1717	83691000.0
2003-07-21 13:00:00	NVDA	Stock	0.1717	0.1747	0.1717	0.1742	92888400.0
2003-07-21 14:00:00	NVDA	Stock	0.1741	0.1748	0.1722	0.1722	85033440.0
2003-07-21 15:00:00	NVDA	Stock	0.1722	0.1749	0.1715	0.1745	149778240.0
2003-07-21 16:00:00	NVDA	Stock	0.1745	0.1762	0.1742	0.1745	4428000.0
2003-07-21 17:00:00	NVDA	Stock	0.1747	0.1754	0.1744	0.175	2207880.0
2003-07-21 18:00:00	NVDA	Stock	0.175	0.175	0.175	0.175	24000.0
2003-07-21 08:00:00	AMZN	Stock	1.755	1.755	1.7495	1.7495	131000.0
2003-07-21 09:00:00	AMZN	Stock	1.7495	1.785	1.73	1.7755	28710660.0
2003-07-21 10:00:00	AMZN	Stock	1.7755	1.7975	1.7675	1.772	43829440.0
2003-07-21 11:00:00	AMZN	Stock	1.772	1.79	1.77	1.783	19471120.0
2003-07-21 12:00:00	AMZN	Stock	1.783	1.787	1.7625	1.773	18664880.0
2003-07-21 13:00:00	AMZN	Stock	1.7731	1.7815	1.773	1.7765	8532480.0
2003-07-21 14:00:00	AMZN	Stock	1.7765	1.7775	1.757	1.76	18927520.0
2003-07-21 15:00:00	AMZN	Stock	1.7595	1.773	1.751	1.7645	32013760.0
2003-07-21 16:00:00	AMZN	Stock	1.768	1.769	1.75	1.7675	675100.0
2003-07-21 17:00:00	AMZN	Stock	1.7625	1.768	1.7625	1.7625	370800.0
2003-07-21 18:00:00	AMZN	Stock	1.7625	1.7625	1.76	1.76	26000.0
2003-07-21 09:00:00	CL	Stock	28.275	28.305	28.15	28.295	356400.0
2003-07-21 10:00:00	CL	Stock	28.295	28.35	28.25	28.315	399200.0
2003-07-21 11:00:00	CL	Stock	28.295	28.295	28.07	28.08	544000.0
2003-07-21 12:00:00	CL	Stock	28.075	28.19	28.055	28.155	576400.0
2003-07-21 13:00:00	CL	Stock	28.15	28.235	28.125	28.205	249600.0
2003-07-21 14:00:00	CL	Stock	28.195	28.295	28.13	28.21	717200.0
2003-07-21 15:00:00	CL	Stock	28.225	28.3	28.13	28.155	1414800.0

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

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