PREVIEW / stock_1hour / 2004-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-03-08.parquet
  size:    489 KB
  rows:    22,914
  symbols: 1,735

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-03-08 08:00:00	AAPL	Stock	0.4821	0.483	0.4775	0.4782	991760.0
2004-03-08 09:00:00	AAPL	Stock	0.4777	0.4784	0.4661	0.47	101611608.0
2004-03-08 10:00:00	AAPL	Stock	0.4698	0.4775	0.4695	0.47	82134696.0
2004-03-08 11:00:00	AAPL	Stock	0.47	0.4726	0.4686	0.4707	54981248.0
2004-03-08 12:00:00	AAPL	Stock	0.4709	0.4736	0.4696	0.4709	29134392.0
2004-03-08 13:00:00	AAPL	Stock	0.4709	0.4709	0.4616	0.4625	77604352.0
2004-03-08 14:00:00	AAPL	Stock	0.4625	0.4673	0.4607	0.463	73128496.0
2004-03-08 15:00:00	AAPL	Stock	0.463	0.4645	0.4614	0.463	70060984.0
2004-03-08 16:00:00	AAPL	Stock	0.4632	0.4659	0.4621	0.4659	7988232.0
2004-03-08 17:00:00	AAPL	Stock	0.4621	0.4643	0.4621	0.4638	1059016.0
2004-03-08 08:00:00	MSFT	Stock	26.37	26.42	26.25	26.36	33019.0
2004-03-08 09:00:00	MSFT	Stock	26.39	26.4	26.25	26.3	6045240.0
2004-03-08 10:00:00	MSFT	Stock	26.3	26.33	26.21	26.23	9031669.0
2004-03-08 11:00:00	MSFT	Stock	26.23	26.28	26.2	26.271	6075686.0
2004-03-08 12:00:00	MSFT	Stock	26.28	26.29	26.13	26.17	5534063.0
2004-03-08 13:00:00	MSFT	Stock	26.17	26.19	25.97	26.0	12757671.0
2004-03-08 14:00:00	MSFT	Stock	25.99	26.04	25.88	26.02	11753651.0
2004-03-08 15:00:00	MSFT	Stock	26.02	26.05	25.81	25.83	14360974.0
2004-03-08 16:00:00	MSFT	Stock	25.84	26.0198	25.75	25.79	1057257.0
2004-03-08 17:00:00	MSFT	Stock	25.9951	25.9951	25.74	25.76	81999.0
2004-03-08 18:00:00	MSFT	Stock	25.74	25.78	25.74	25.75	20050.0
2004-03-08 08:00:00	NVDA	Stock	0.185	0.185	0.185	0.185	72000.0
2004-03-08 09:00:00	NVDA	Stock	0.1849	0.1875	0.1847	0.1863	45401640.0
2004-03-08 10:00:00	NVDA	Stock	0.1862	0.187	0.1854	0.1854	36214680.0
2004-03-08 11:00:00	NVDA	Stock	0.1854	0.1871	0.185	0.1857	33982680.0
2004-03-08 12:00:00	NVDA	Stock	0.1857	0.1858	0.1845	0.1847	30026280.0
2004-03-08 13:00:00	NVDA	Stock	0.1847	0.1848	0.1813	0.1816	45355320.0
2004-03-08 14:00:00	NVDA	Stock	0.1816	0.1817	0.1771	0.1791	114869400.0
2004-03-08 15:00:00	NVDA	Stock	0.1791	0.1803	0.178	0.1781	133311960.0
2004-03-08 16:00:00	NVDA	Stock	0.1781	0.181	0.1777	0.181	8481480.0
2004-03-08 17:00:00	NVDA	Stock	0.1794	0.1794	0.1781	0.1781	1453680.0
2004-03-08 18:00:00	NVDA	Stock	0.1783	0.1783	0.1783	0.1783	12000.0
2004-03-08 08:00:00	AMZN	Stock	2.188	2.1885	2.188	2.188	40000.0
2004-03-08 09:00:00	AMZN	Stock	2.195	2.235	2.1905	2.227	13248820.0
2004-03-08 10:00:00	AMZN	Stock	2.2275	2.253	2.223	2.238	29297600.0
2004-03-08 11:00:00	AMZN	Stock	2.238	2.247	2.237	2.2415	9513220.0
2004-03-08 12:00:00	AMZN	Stock	2.2415	2.2465	2.2245	2.233	9558400.0
2004-03-08 13:00:00	AMZN	Stock	2.233	2.2365	2.203	2.205	11784160.0
2004-03-08 14:00:00	AMZN	Stock	2.205	2.209	2.1705	2.1855	26084760.0
2004-03-08 15:00:00	AMZN	Stock	2.1855	2.186	2.1565	2.1745	26998100.0
2004-03-08 16:00:00	AMZN	Stock	2.174	2.2068	2.1655	2.2068	2472740.0
2004-03-08 17:00:00	AMZN	Stock	2.1672	2.175	2.1672	2.175	295120.0
2004-03-08 18:00:00	AMZN	Stock	2.1685	2.1685	2.1685	2.1685	20000.0
2004-03-08 09:00:00	CL	Stock	28.14	28.18	28.09	28.125	133400.0
2004-03-08 10:00:00	CL	Stock	28.12	28.305	28.115	28.245	230400.0
2004-03-08 11:00:00	CL	Stock	28.25	28.385	28.225	28.37	344800.0
2004-03-08 12:00:00	CL	Stock	28.375	28.39	28.31	28.34	490600.0
2004-03-08 13:00:00	CL	Stock	28.34	28.355	28.3	28.325	271400.0
2004-03-08 14:00:00	CL	Stock	28.31	28.37	28.3	28.34	371200.0
2004-03-08 15:00:00	CL	Stock	28.33	28.335	28.26	28.275	758600.0

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

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