PREVIEW / stock_1hour / 2004-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-12.parquet
  size:    510 KB
  rows:    23,699
  symbols: 1,776

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-12 08:00:00	AAPL	Stock	0.4846	0.4846	0.4814	0.4814	117600.0
2004-05-12 09:00:00	AAPL	Stock	0.4814	0.4846	0.4752	0.4825	28625632.0
2004-05-12 10:00:00	AAPL	Stock	0.4825	0.4829	0.4757	0.4763	35174328.0
2004-05-12 11:00:00	AAPL	Stock	0.4763	0.4768	0.4698	0.4727	28629776.0
2004-05-12 12:00:00	AAPL	Stock	0.4727	0.4732	0.4689	0.4707	27854624.0
2004-05-12 13:00:00	AAPL	Stock	0.4707	0.4738	0.4688	0.4698	17408328.0
2004-05-12 14:00:00	AAPL	Stock	0.4696	0.4775	0.4686	0.4745	26803392.0
2004-05-12 15:00:00	AAPL	Stock	0.4745	0.4882	0.4741	0.4871	73830960.0
2004-05-12 16:00:00	AAPL	Stock	0.4871	0.4884	0.4866	0.4866	1904504.0
2004-05-12 17:00:00	AAPL	Stock	0.4861	0.4886	0.4861	0.4882	182560.0
2004-05-12 18:00:00	AAPL	Stock	0.4886	0.4911	0.4886	0.4911	166320.0
2004-05-12 08:00:00	MSFT	Stock	25.945	25.99	25.88	25.93	83783.0
2004-05-12 09:00:00	MSFT	Stock	25.94	26.0	25.85	25.88	7213254.0
2004-05-12 10:00:00	MSFT	Stock	25.88	25.88	25.57	25.66	10813980.0
2004-05-12 11:00:00	MSFT	Stock	25.66	25.66	25.51	25.51	6772731.0
2004-05-12 12:00:00	MSFT	Stock	25.51	25.61	25.45	25.51	6814430.0
2004-05-12 13:00:00	MSFT	Stock	25.51	25.6	25.43	25.48	5306988.0
2004-05-12 14:00:00	MSFT	Stock	25.49	25.67	25.48	25.57	9052414.0
2004-05-12 15:00:00	MSFT	Stock	25.57	26.0	25.56	25.95	15257344.0
2004-05-12 16:00:00	MSFT	Stock	25.96	26.04	25.9389	25.94	816642.0
2004-05-12 17:00:00	MSFT	Stock	25.97	26.01	25.7547	26.01	41160.0
2004-05-12 18:00:00	MSFT	Stock	25.97	26.01	25.97	25.98	14900.0
2004-05-12 08:00:00	NVDA	Stock	0.1816	0.1816	0.1816	0.1816	240000.0
2004-05-12 09:00:00	NVDA	Stock	0.181	0.181	0.1787	0.1797	38227680.0
2004-05-12 10:00:00	NVDA	Stock	0.1797	0.1797	0.1761	0.1763	71339760.0
2004-05-12 11:00:00	NVDA	Stock	0.1764	0.1764	0.1735	0.1743	76643040.0
2004-05-12 12:00:00	NVDA	Stock	0.1743	0.1757	0.1737	0.1747	50569440.0
2004-05-12 13:00:00	NVDA	Stock	0.1747	0.175	0.1724	0.1729	44545320.0
2004-05-12 14:00:00	NVDA	Stock	0.173	0.1763	0.1729	0.1758	52594080.0
2004-05-12 15:00:00	NVDA	Stock	0.1758	0.1791	0.1757	0.1786	115453200.0
2004-05-12 16:00:00	NVDA	Stock	0.1786	0.1792	0.1784	0.1784	3752640.0
2004-05-12 08:00:00	AMZN	Stock	2.13	2.13	2.1295	2.1295	40000.0
2004-05-12 09:00:00	AMZN	Stock	2.1255	2.1305	2.099	2.106	11991800.0
2004-05-12 10:00:00	AMZN	Stock	2.106	2.11	2.0805	2.089	28372440.0
2004-05-12 11:00:00	AMZN	Stock	2.0875	2.094	2.0645	2.0725	16960480.0
2004-05-12 12:00:00	AMZN	Stock	2.0725	2.093	2.0625	2.087	16756700.0
2004-05-12 13:00:00	AMZN	Stock	2.087	2.09	2.0645	2.067	10373760.0
2004-05-12 14:00:00	AMZN	Stock	2.067	2.11	2.0655	2.107	16730380.0
2004-05-12 15:00:00	AMZN	Stock	2.1075	2.1575	2.1065	2.1525	42149920.0
2004-05-12 16:00:00	AMZN	Stock	2.1515	2.1645	2.1425	2.1645	1573320.0
2004-05-12 17:00:00	AMZN	Stock	2.151	2.1815	2.151	2.1625	116420.0
2004-05-12 18:00:00	AMZN	Stock	2.1785	2.1785	2.1625	2.1625	82960.0
2004-05-12 09:00:00	CL	Stock	28.435	28.445	28.34	28.41	280600.0
2004-05-12 10:00:00	CL	Stock	28.41	28.55	28.35	28.39	403000.0
2004-05-12 11:00:00	CL	Stock	28.385	28.42	28.3	28.375	367800.0
2004-05-12 12:00:00	CL	Stock	28.375	28.38	28.29	28.32	234200.0
2004-05-12 13:00:00	CL	Stock	28.3	28.34	28.17	28.2	285800.0
2004-05-12 14:00:00	CL	Stock	28.2	28.3	28.195	28.26	404400.0
2004-05-12 15:00:00	CL	Stock	28.255	28.53	28.25	28.475	865000.0
2004-05-12 16:00:00	CL	Stock	28.445	28.458	28.445	28.455	14600.0

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

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