PREVIEW / stock_1hour / 2002-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-23.parquet
  size:    393 KB
  rows:    18,557
  symbols: 1,462

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-23 09:00:00	AAPL	Stock	0.2661	0.2702	0.2634	0.2691	38140704.0
2002-07-23 10:00:00	AAPL	Stock	0.2691	0.2693	0.2638	0.267	56074928.0
2002-07-23 11:00:00	AAPL	Stock	0.267	0.2686	0.2652	0.2671	28696808.0
2002-07-23 12:00:00	AAPL	Stock	0.2671	0.2677	0.263	0.2645	42822080.0
2002-07-23 13:00:00	AAPL	Stock	0.265	0.265	0.2602	0.2621	54469184.0
2002-07-23 14:00:00	AAPL	Stock	0.2613	0.265	0.2589	0.2616	65001496.0
2002-07-23 15:00:00	AAPL	Stock	0.2616	0.2641	0.2582	0.2582	85120560.0
2002-07-23 16:00:00	AAPL	Stock	0.2582	0.2584	0.2582	0.2582	554400.0
2002-07-23 09:00:00	MSFT	Stock	23.245	23.4025	22.755	23.23	23478644.0
2002-07-23 10:00:00	MSFT	Stock	23.23	23.2965	22.76	22.89	25994966.0
2002-07-23 11:00:00	MSFT	Stock	22.8895	22.99	22.555	22.865	18030648.0
2002-07-23 12:00:00	MSFT	Stock	22.87	22.95	22.35	22.43	17781236.0
2002-07-23 13:00:00	MSFT	Stock	22.435	22.45	22.015	22.3505	20230090.0
2002-07-23 14:00:00	MSFT	Stock	22.35	22.75	22.05	22.1	24640158.0
2002-07-23 15:00:00	MSFT	Stock	22.1	22.235	21.485	21.525	29925948.0
2002-07-23 16:00:00	MSFT	Stock	21.495	23.4	21.485	21.505	128923000.0
2002-07-23 09:00:00	NVDA	Stock	0.1449	0.1458	0.1381	0.1414	183647400.0
2002-07-23 10:00:00	NVDA	Stock	0.1414	0.1414	0.1358	0.1361	229836600.0
2002-07-23 11:00:00	NVDA	Stock	0.1362	0.1366	0.1334	0.1341	160777440.0
2002-07-23 12:00:00	NVDA	Stock	0.1341	0.1349	0.1329	0.1338	162470040.0
2002-07-23 13:00:00	NVDA	Stock	0.1337	0.1358	0.1329	0.1351	159491400.0
2002-07-23 14:00:00	NVDA	Stock	0.1352	0.1367	0.1331	0.1336	172509480.0
2002-07-23 15:00:00	NVDA	Stock	0.1338	0.1342	0.1284	0.1333	295277760.0
2002-07-23 16:00:00	NVDA	Stock	0.1336	0.1458	0.1284	0.1333	1134072000.0
2002-07-23 09:00:00	AMZN	Stock	0.777	0.794	0.777	0.7816	22600420.0
2002-07-23 10:00:00	AMZN	Stock	0.782	0.7825	0.754	0.7625	41263880.0
2002-07-23 11:00:00	AMZN	Stock	0.7625	0.765	0.7345	0.7475	29394680.0
2002-07-23 12:00:00	AMZN	Stock	0.7475	0.7515	0.7275	0.75	17668100.0
2002-07-23 13:00:00	AMZN	Stock	0.75	0.7505	0.73	0.743	23953700.0
2002-07-23 14:00:00	AMZN	Stock	0.7425	0.7455	0.7283	0.7406	25886300.0
2002-07-23 15:00:00	AMZN	Stock	0.7405	0.7435	0.72	0.73	31823340.0
2002-07-23 16:00:00	AMZN	Stock	0.728	0.73	0.7265	0.7275	412000.0
2002-07-23 08:00:00	CL	Stock	23.25	23.25	23.25	23.25	200.0
2002-07-23 09:00:00	CL	Stock	23.025	23.04	22.695	22.9	811000.0
2002-07-23 10:00:00	CL	Stock	22.925	23.185	22.7	23.13	901000.0
2002-07-23 11:00:00	CL	Stock	23.13	23.5	23.03	23.305	923800.0
2002-07-23 12:00:00	CL	Stock	23.325	23.565	23.325	23.445	845000.0
2002-07-23 13:00:00	CL	Stock	23.41	23.465	23.3	23.45	597800.0
2002-07-23 14:00:00	CL	Stock	23.45	24.1	23.33	23.625	1075000.0
2002-07-23 15:00:00	CL	Stock	23.65	24.1	23.51	23.65	1811000.0
2002-07-23 16:00:00	CL	Stock	23.65	23.65	23.6	23.6	248200.0

> showing 41 of 18,557 rows — these rows as CSV

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