PREVIEW / stock_1hour / 2003-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-25.parquet
  size:    459 KB
  rows:    21,533
  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-25 09:00:00	AAPL	Stock	0.3661	0.3732	0.3643	0.3718	16596272.0
2003-07-25 10:00:00	AAPL	Stock	0.3723	0.3723	0.3652	0.3673	22352120.0
2003-07-25 11:00:00	AAPL	Stock	0.3673	0.372	0.3663	0.3716	16998688.0
2003-07-25 12:00:00	AAPL	Stock	0.3716	0.3741	0.3713	0.3739	11963448.0
2003-07-25 13:00:00	AAPL	Stock	0.3738	0.3795	0.3738	0.377	23548896.0
2003-07-25 14:00:00	AAPL	Stock	0.377	0.3823	0.3752	0.3816	29530704.0
2003-07-25 15:00:00	AAPL	Stock	0.3815	0.3852	0.3802	0.3846	57164688.0
2003-07-25 16:00:00	AAPL	Stock	0.3846	0.3891	0.3839	0.3891	6942600.0
2003-07-25 17:00:00	AAPL	Stock	0.3846	0.385	0.3846	0.385	487200.0
2003-07-25 18:00:00	AAPL	Stock	0.385	0.385	0.3839	0.385	89600.0
2003-07-25 08:00:00	MSFT	Stock	26.25	26.41	26.2	26.25	567186.0
2003-07-25 09:00:00	MSFT	Stock	26.251	26.49	26.16	26.44	6318362.0
2003-07-25 10:00:00	MSFT	Stock	26.43	26.45	26.07	26.18	8141430.0
2003-07-25 11:00:00	MSFT	Stock	26.18	26.553	26.15	26.54	7124184.0
2003-07-25 12:00:00	MSFT	Stock	26.55	26.58	26.43	26.509	3053329.0
2003-07-25 13:00:00	MSFT	Stock	26.5	26.75	26.44	26.56	5589557.0
2003-07-25 14:00:00	MSFT	Stock	26.55	26.76	26.52	26.74	4988885.0
2003-07-25 15:00:00	MSFT	Stock	26.75	26.94	26.71	26.89	11564838.0
2003-07-25 16:00:00	MSFT	Stock	26.89	26.94	26.24	26.9	588675.0
2003-07-25 17:00:00	MSFT	Stock	26.88	26.92	26.87	26.91	14253.0
2003-07-25 18:00:00	MSFT	Stock	26.9	26.9	26.88	26.9	7970.0
2003-07-25 08:00:00	NVDA	Stock	0.1732	0.1733	0.1732	0.1733	84000.0
2003-07-25 09:00:00	NVDA	Stock	0.1732	0.1765	0.1717	0.1737	100093320.0
2003-07-25 10:00:00	NVDA	Stock	0.1737	0.1741	0.1667	0.1677	211081560.0
2003-07-25 11:00:00	NVDA	Stock	0.1677	0.1712	0.1677	0.1711	143960040.0
2003-07-25 12:00:00	NVDA	Stock	0.1711	0.1723	0.169	0.1709	101022120.0
2003-07-25 13:00:00	NVDA	Stock	0.1709	0.1732	0.1708	0.1717	84879000.0
2003-07-25 14:00:00	NVDA	Stock	0.1719	0.1747	0.1715	0.1741	56808240.0
2003-07-25 15:00:00	NVDA	Stock	0.174	0.1759	0.1732	0.1754	168138240.0
2003-07-25 16:00:00	NVDA	Stock	0.1754	0.1762	0.1752	0.1762	3473520.0
2003-07-25 17:00:00	NVDA	Stock	0.1755	0.1755	0.175	0.175	490200.0
2003-07-25 08:00:00	AMZN	Stock	2.0425	2.0645	2.039	2.05	2173900.0
2003-07-25 09:00:00	AMZN	Stock	2.05	2.05	1.9965	2.018	57027000.0
2003-07-25 10:00:00	AMZN	Stock	2.018	2.025	1.9875	2.005	37772240.0
2003-07-25 11:00:00	AMZN	Stock	2.0045	2.0195	2.0025	2.015	17469740.0
2003-07-25 12:00:00	AMZN	Stock	2.0155	2.0225	2.0095	2.0175	9176240.0
2003-07-25 13:00:00	AMZN	Stock	2.018	2.0455	2.017	2.0336	18242140.0
2003-07-25 14:00:00	AMZN	Stock	2.034	2.0595	2.0338	2.054	16942580.0
2003-07-25 15:00:00	AMZN	Stock	2.054	2.0825	2.053	2.082	31183560.0
2003-07-25 16:00:00	AMZN	Stock	2.079	2.0975	2.071	2.09	3909860.0
2003-07-25 17:00:00	AMZN	Stock	2.0905	2.091	2.0214	2.085	418180.0
2003-07-25 18:00:00	AMZN	Stock	2.085	2.085	2.085	2.085	38000.0
2003-07-25 09:00:00	CL	Stock	27.9	27.93	27.675	27.869	474600.0
2003-07-25 10:00:00	CL	Stock	27.875	28.045	27.7	27.725	396000.0
2003-07-25 11:00:00	CL	Stock	27.73	27.755	27.625	27.695	273000.0
2003-07-25 12:00:00	CL	Stock	27.695	27.7575	27.645	27.715	214400.0
2003-07-25 13:00:00	CL	Stock	27.71	27.805	27.7	27.765	329000.0
2003-07-25 14:00:00	CL	Stock	27.765	27.93	27.71	27.9	246400.0
2003-07-25 15:00:00	CL	Stock	27.9	28.025	27.9	27.945	555600.0
2003-07-25 16:00:00	CL	Stock	27.945	27.95	27.94	27.94	111200.0

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

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