PREVIEW / stock_1hour / 2003-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-11.parquet
  size:    480 KB
  rows:    22,581
  symbols: 1,609

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-09-11 08:00:00	AAPL	Stock	0.3978	0.3978	0.3978	0.3978	543200.0
2003-09-11 09:00:00	AAPL	Stock	0.3984	0.402	0.3966	0.398	19594176.0
2003-09-11 10:00:00	AAPL	Stock	0.398	0.4002	0.3946	0.3971	24018344.0
2003-09-11 11:00:00	AAPL	Stock	0.3966	0.4036	0.395	0.4034	33910072.0
2003-09-11 12:00:00	AAPL	Stock	0.4032	0.4034	0.4	0.4018	18924080.0
2003-09-11 13:00:00	AAPL	Stock	0.4018	0.4055	0.4014	0.4032	17563056.0
2003-09-11 14:00:00	AAPL	Stock	0.4032	0.407	0.4032	0.4064	16396072.0
2003-09-11 15:00:00	AAPL	Stock	0.4064	0.4066	0.4011	0.4027	49334992.0
2003-09-11 16:00:00	AAPL	Stock	0.4032	0.4057	0.4014	0.4029	8134896.0
2003-09-11 17:00:00	AAPL	Stock	0.4029	0.4029	0.4029	0.4029	168000.0
2003-09-11 18:00:00	AAPL	Stock	0.4025	0.4025	0.4025	0.4025	84000.0
2003-09-11 08:00:00	MSFT	Stock	27.53	27.63	27.512	27.59	44150.0
2003-09-11 09:00:00	MSFT	Stock	27.59	27.78	27.55	27.71	4406492.0
2003-09-11 10:00:00	MSFT	Stock	27.71	27.88	27.67	27.7	5293165.0
2003-09-11 11:00:00	MSFT	Stock	27.7	27.83	27.6	27.8	4926593.0
2003-09-11 12:00:00	MSFT	Stock	27.79	27.93	27.77	27.93	3134147.0
2003-09-11 13:00:00	MSFT	Stock	27.93	27.99	27.84	27.93	3083692.0
2003-09-11 14:00:00	MSFT	Stock	27.93	28.1	27.93	28.07	3584838.0
2003-09-11 15:00:00	MSFT	Stock	28.08	28.09	27.82	27.87	6721535.0
2003-09-11 16:00:00	MSFT	Stock	27.85	27.99	27.73	27.91	1415032.0
2003-09-11 17:00:00	MSFT	Stock	27.94	27.96	27.88	27.95	99800.0
2003-09-11 18:00:00	MSFT	Stock	27.86	28.0	27.86	27.97	54300.0
2003-09-11 08:00:00	NVDA	Stock	0.1611	0.1621	0.1608	0.1621	972000.0
2003-09-11 09:00:00	NVDA	Stock	0.1621	0.1637	0.1529	0.1539	343320240.0
2003-09-11 10:00:00	NVDA	Stock	0.1538	0.1565	0.1534	0.1538	277153800.0
2003-09-11 11:00:00	NVDA	Stock	0.1537	0.1555	0.1525	0.1541	268872240.0
2003-09-11 12:00:00	NVDA	Stock	0.154	0.1599	0.1536	0.1599	195193440.0
2003-09-11 13:00:00	NVDA	Stock	0.1599	0.1605	0.1572	0.1584	153699960.0
2003-09-11 14:00:00	NVDA	Stock	0.1584	0.1679	0.1577	0.164	660266400.0
2003-09-11 15:00:00	NVDA	Stock	0.164	0.164	0.1587	0.1587	526218720.0
2003-09-11 16:00:00	NVDA	Stock	0.1587	0.1591	0.1572	0.1587	14588760.0
2003-09-11 17:00:00	NVDA	Stock	0.1583	0.1592	0.158	0.1583	1488000.0
2003-09-11 18:00:00	NVDA	Stock	0.1585	0.1588	0.154	0.1588	744000.0
2003-09-11 08:00:00	AMZN	Stock	2.3	2.305	2.3	2.305	247000.0
2003-09-11 09:00:00	AMZN	Stock	2.303	2.3175	2.275	2.28	31108700.0
2003-09-11 10:00:00	AMZN	Stock	2.2795	2.2925	2.2505	2.2575	40045600.0
2003-09-11 11:00:00	AMZN	Stock	2.257	2.2725	2.2385	2.257	36777620.0
2003-09-11 12:00:00	AMZN	Stock	2.2576	2.269	2.2475	2.259	20858900.0
2003-09-11 13:00:00	AMZN	Stock	2.2594	2.2665	2.248	2.253	16270620.0
2003-09-11 14:00:00	AMZN	Stock	2.254	2.257	2.2455	2.2535	23533460.0
2003-09-11 15:00:00	AMZN	Stock	2.2535	2.265	2.248	2.256	34537580.0
2003-09-11 16:00:00	AMZN	Stock	2.256	2.2595	2.25	2.2515	1745120.0
2003-09-11 17:00:00	AMZN	Stock	2.2515	2.2542	2.251	2.251	157000.0
2003-09-11 18:00:00	AMZN	Stock	2.252	2.252	2.251	2.251	18000.0
2003-09-11 09:00:00	CL	Stock	28.075	28.34	28.075	28.335	200000.0
2003-09-11 10:00:00	CL	Stock	28.34	28.425	28.25	28.405	366200.0
2003-09-11 11:00:00	CL	Stock	28.405	28.49	28.375	28.4	388600.0
2003-09-11 12:00:00	CL	Stock	28.4	28.425	28.33	28.395	189000.0
2003-09-11 13:00:00	CL	Stock	28.385	28.45	28.36	28.425	332000.0
2003-09-11 14:00:00	CL	Stock	28.415	28.455	28.315	28.32	250800.0

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

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