PREVIEW / stock_1hour / 2002-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-10.parquet
  size:    412 KB
  rows:    19,460
  symbols: 1,449

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
2002-07-10 08:00:00	AAPL	Stock	0.3129	0.3204	0.3129	0.3196	1097600.0
2002-07-10 09:00:00	AAPL	Stock	0.3189	0.3214	0.3145	0.3209	19700800.0
2002-07-10 10:00:00	AAPL	Stock	0.321	0.3245	0.3184	0.3213	33997600.0
2002-07-10 11:00:00	AAPL	Stock	0.3209	0.3211	0.3143	0.3143	26224800.0
2002-07-10 12:00:00	AAPL	Stock	0.3143	0.3209	0.3132	0.3195	21095200.0
2002-07-10 13:00:00	AAPL	Stock	0.3191	0.3214	0.3127	0.313	16312800.0
2002-07-10 14:00:00	AAPL	Stock	0.3132	0.317	0.3098	0.3159	33348000.0
2002-07-10 15:00:00	AAPL	Stock	0.3159	0.3161	0.308	0.3105	38567200.0
2002-07-10 16:00:00	AAPL	Stock	0.3093	0.3188	0.309	0.3188	11995200.0
2002-07-10 17:00:00	AAPL	Stock	0.3116	0.3162	0.3116	0.3162	184800.0
2002-07-10 18:00:00	AAPL	Stock	0.3152	0.3152	0.3152	0.3152	22400.0
2002-07-10 08:00:00	MSFT	Stock	26.6125	27.5	26.6125	26.905	91400.0
2002-07-10 09:00:00	MSFT	Stock	27.375	27.5	26.67	26.91	8830800.0
2002-07-10 10:00:00	MSFT	Stock	26.9	27.1	26.76	26.9685	13450800.0
2002-07-10 11:00:00	MSFT	Stock	26.969	26.97	26.7345	26.81	10602200.0
2002-07-10 12:00:00	MSFT	Stock	26.815	27.025	26.71	26.995	9810800.0
2002-07-10 13:00:00	MSFT	Stock	26.98	27.1	26.75	26.795	8235800.0
2002-07-10 14:00:00	MSFT	Stock	26.8	26.83	26.4	26.605	15303000.0
2002-07-10 15:00:00	MSFT	Stock	26.615	26.63	26.065	26.13	19324400.0
2002-07-10 16:00:00	MSFT	Stock	26.105	26.8716	26.005	26.225	2717600.0
2002-07-10 17:00:00	MSFT	Stock	26.25	26.702	26.12	26.21	40400.0
2002-07-10 18:00:00	MSFT	Stock	26.245	26.25	26.195	26.195	10800.0
2002-07-10 08:00:00	NVDA	Stock	0.1571	0.16	0.1555	0.1587	1500000.0
2002-07-10 09:00:00	NVDA	Stock	0.1586	0.16	0.1546	0.1573	166752000.0
2002-07-10 10:00:00	NVDA	Stock	0.1573	0.1588	0.1533	0.1562	157476000.0
2002-07-10 11:00:00	NVDA	Stock	0.1562	0.1565	0.1529	0.1539	109800000.0
2002-07-10 12:00:00	NVDA	Stock	0.1539	0.1553	0.1519	0.1546	123876000.0
2002-07-10 13:00:00	NVDA	Stock	0.1548	0.1562	0.1499	0.1504	99684000.0
2002-07-10 14:00:00	NVDA	Stock	0.1503	0.1525	0.1497	0.1518	102480000.0
2002-07-10 15:00:00	NVDA	Stock	0.1517	0.1519	0.1497	0.1508	122448000.0
2002-07-10 16:00:00	NVDA	Stock	0.1507	0.1559	0.1504	0.1505	15912000.0
2002-07-10 17:00:00	NVDA	Stock	0.1512	0.1517	0.1512	0.1516	456000.0
2002-07-10 18:00:00	NVDA	Stock	0.1517	0.1517	0.1516	0.1517	468000.0
2002-07-10 08:00:00	AMZN	Stock	0.7785	0.788	0.7785	0.7875	104000.0
2002-07-10 09:00:00	AMZN	Stock	0.7875	0.7881	0.7585	0.7585	17868000.0
2002-07-10 10:00:00	AMZN	Stock	0.76	0.783	0.756	0.7775	15952000.0
2002-07-10 11:00:00	AMZN	Stock	0.7779	0.7825	0.766	0.776	12414000.0
2002-07-10 12:00:00	AMZN	Stock	0.776	0.7885	0.771	0.788	12240000.0
2002-07-10 13:00:00	AMZN	Stock	0.7865	0.797	0.77	0.7725	19386000.0
2002-07-10 14:00:00	AMZN	Stock	0.773	0.7775	0.766	0.772	15334000.0
2002-07-10 15:00:00	AMZN	Stock	0.7715	0.772	0.7325	0.7485	34560000.0
2002-07-10 16:00:00	AMZN	Stock	0.7485	0.775	0.7445	0.7575	3546000.0
2002-07-10 17:00:00	AMZN	Stock	0.7575	0.765	0.748	0.765	74000.0
2002-07-10 18:00:00	AMZN	Stock	0.765	0.765	0.7625	0.7625	70000.0
2002-07-10 09:00:00	CL	Stock	25.0	25.025	24.9	25.0	304200.0
2002-07-10 10:00:00	CL	Stock	24.995	25.055	24.905	24.905	606200.0
2002-07-10 11:00:00	CL	Stock	24.9	25.0	24.87	24.945	632200.0
2002-07-10 12:00:00	CL	Stock	24.945	25.1	24.9	24.98	374000.0
2002-07-10 13:00:00	CL	Stock	24.98	25.06	24.85	24.855	312800.0
2002-07-10 14:00:00	CL	Stock	24.855	24.99	24.765	24.955	388800.0

> showing 50 of 19,460 rows — these rows as CSV

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