PREVIEW / stock_1hour / 2003-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-04.parquet
  size:    458 KB
  rows:    21,672
  symbols: 1,599

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-08-04 09:00:00	AAPL	Stock	0.368	0.3716	0.3642	0.3657	12610976.0
2003-08-04 10:00:00	AAPL	Stock	0.3657	0.3691	0.3621	0.3641	29841504.0
2003-08-04 11:00:00	AAPL	Stock	0.3641	0.3677	0.3634	0.3657	22391656.0
2003-08-04 12:00:00	AAPL	Stock	0.3657	0.368	0.3652	0.3659	19290208.0
2003-08-04 13:00:00	AAPL	Stock	0.3661	0.3698	0.3657	0.3695	16756712.0
2003-08-04 14:00:00	AAPL	Stock	0.3691	0.3839	0.3689	0.3807	46374216.0
2003-08-04 15:00:00	AAPL	Stock	0.3807	0.3821	0.3761	0.3786	38001880.0
2003-08-04 16:00:00	AAPL	Stock	0.3795	0.3802	0.3764	0.3764	1831200.0
2003-08-04 17:00:00	AAPL	Stock	0.3795	0.3795	0.3654	0.3654	571200.0
2003-08-04 08:00:00	MSFT	Stock	26.26	26.33	26.15	26.171	47005.0
2003-08-04 09:00:00	MSFT	Stock	26.171	26.22	25.8	25.92	6346879.0
2003-08-04 10:00:00	MSFT	Stock	25.93	26.004	25.75	25.8	9884096.0
2003-08-04 11:00:00	MSFT	Stock	25.8	25.87	25.77	25.82	4451172.0
2003-08-04 12:00:00	MSFT	Stock	25.82	25.98	25.78	25.9	3924842.0
2003-08-04 13:00:00	MSFT	Stock	25.9	26.02	25.86	25.89	4623800.0
2003-08-04 14:00:00	MSFT	Stock	25.899	26.41	25.84	26.27	9765163.0
2003-08-04 15:00:00	MSFT	Stock	26.27	26.39	26.11	26.14	6594023.0
2003-08-04 16:00:00	MSFT	Stock	26.18	26.19	25.916	26.11	628227.0
2003-08-04 17:00:00	MSFT	Stock	26.12	26.16	26.12	26.16	57500.0
2003-08-04 18:00:00	MSFT	Stock	26.16	26.17	26.15	26.16	8784.0
2003-08-04 08:00:00	NVDA	Stock	0.1641	0.1657	0.1641	0.1657	618000.0
2003-08-04 09:00:00	NVDA	Stock	0.1649	0.1735	0.1631	0.1717	382644720.0
2003-08-04 10:00:00	NVDA	Stock	0.1717	0.1727	0.1684	0.1696	291374280.0
2003-08-04 11:00:00	NVDA	Stock	0.1696	0.1706	0.1691	0.1692	110404080.0
2003-08-04 12:00:00	NVDA	Stock	0.1692	0.1711	0.1687	0.1706	124197960.0
2003-08-04 13:00:00	NVDA	Stock	0.1706	0.1707	0.1689	0.1697	71749800.0
2003-08-04 14:00:00	NVDA	Stock	0.1697	0.1709	0.1687	0.1701	135620160.0
2003-08-04 15:00:00	NVDA	Stock	0.1702	0.1708	0.1697	0.1707	174821760.0
2003-08-04 16:00:00	NVDA	Stock	0.1705	0.1712	0.1691	0.1712	23161200.0
2003-08-04 17:00:00	NVDA	Stock	0.1712	0.1712	0.1695	0.1707	912000.0
2003-08-04 18:00:00	NVDA	Stock	0.1708	0.1708	0.1708	0.1708	120000.0
2003-08-04 08:00:00	AMZN	Stock	2.005	2.005	2.001	2.001	90000.0
2003-08-04 09:00:00	AMZN	Stock	1.998	2.014	1.975	1.9775	22565340.0
2003-08-04 10:00:00	AMZN	Stock	1.9775	1.983	1.9485	1.9555	30169200.0
2003-08-04 11:00:00	AMZN	Stock	1.9555	1.968	1.9515	1.9515	13429520.0
2003-08-04 12:00:00	AMZN	Stock	1.9515	1.968	1.9475	1.954	14558220.0
2003-08-04 13:00:00	AMZN	Stock	1.9545	1.9725	1.953	1.965	10554580.0
2003-08-04 14:00:00	AMZN	Stock	1.965	1.9975	1.963	1.9955	16431800.0
2003-08-04 15:00:00	AMZN	Stock	1.995	2.0	1.9775	1.9825	18945660.0
2003-08-04 16:00:00	AMZN	Stock	1.982	1.9915	1.9795	1.985	932880.0
2003-08-04 17:00:00	AMZN	Stock	1.9864	1.9865	1.982	1.983	274000.0
2003-08-04 18:00:00	AMZN	Stock	1.983	1.983	1.983	1.983	2000.0
2003-08-04 09:00:00	CL	Stock	27.06	27.22	26.871	26.905	392000.0
2003-08-04 10:00:00	CL	Stock	26.915	26.985	26.775	26.885	464800.0
2003-08-04 11:00:00	CL	Stock	26.89	26.93	26.86	26.905	360600.0
2003-08-04 12:00:00	CL	Stock	26.905	27.085	26.895	26.91	354600.0
2003-08-04 13:00:00	CL	Stock	26.92	27.105	26.915	26.95	284600.0
2003-08-04 14:00:00	CL	Stock	26.95	27.235	26.95	27.175	433200.0
2003-08-04 15:00:00	CL	Stock	27.175	27.225	27.135	27.16	374000.0
2003-08-04 16:00:00	CL	Stock	27.165	27.165	27.165	27.165	52200.0

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

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