PREVIEW / stock_1hour / 2002-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-15.parquet
  size:    411 KB
  rows:    19,225
  symbols: 1,457

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-15 09:00:00	AAPL	Stock	0.3123	0.3132	0.3052	0.3082	26392800.0
2002-07-15 10:00:00	AAPL	Stock	0.3079	0.3079	0.3025	0.3038	47084800.0
2002-07-15 11:00:00	AAPL	Stock	0.3036	0.3105	0.3027	0.3089	33348000.0
2002-07-15 12:00:00	AAPL	Stock	0.3093	0.3093	0.3043	0.3045	20490400.0
2002-07-15 13:00:00	AAPL	Stock	0.3045	0.3054	0.3027	0.303	26717600.0
2002-07-15 14:00:00	AAPL	Stock	0.3034	0.3039	0.3002	0.3034	32838400.0
2002-07-15 15:00:00	AAPL	Stock	0.3036	0.327	0.3021	0.3256	68331200.0
2002-07-15 16:00:00	AAPL	Stock	0.3255	0.3268	0.3018	0.3232	21672000.0
2002-07-15 17:00:00	AAPL	Stock	0.3125	0.3125	0.3125	0.3125	268800.0
2002-07-15 18:00:00	AAPL	Stock	0.3196	0.3196	0.3196	0.3196	5600.0
2002-07-15 08:00:00	MSFT	Stock	25.93	25.995	25.85	25.929	44200.0
2002-07-15 09:00:00	MSFT	Stock	25.9	25.935	25.475	25.59	11423000.0
2002-07-15 10:00:00	MSFT	Stock	25.59	25.795	25.355	25.575	15948000.0
2002-07-15 11:00:00	MSFT	Stock	25.57	25.675	25.3	25.545	11738000.0
2002-07-15 12:00:00	MSFT	Stock	25.545	25.5495	25.23	25.28	12802800.0
2002-07-15 13:00:00	MSFT	Stock	25.295	25.365	25.015	25.12	11463400.0
2002-07-15 14:00:00	MSFT	Stock	25.118	25.15	24.3	24.7435	30022800.0
2002-07-15 15:00:00	MSFT	Stock	24.75	25.93	24.7	25.91	34718600.0
2002-07-15 16:00:00	MSFT	Stock	25.895	26.135	25.675	26.04	5748000.0
2002-07-15 17:00:00	MSFT	Stock	26.03	26.145	24.49	26.09	188600.0
2002-07-15 18:00:00	MSFT	Stock	26.065	26.1	26.005	26.025	7400.0
2002-07-15 08:00:00	NVDA	Stock	0.1662	0.1662	0.1662	0.1662	744000.0
2002-07-15 09:00:00	NVDA	Stock	0.1662	0.1667	0.1588	0.1622	170340000.0
2002-07-15 10:00:00	NVDA	Stock	0.1622	0.1697	0.1611	0.1681	241956000.0
2002-07-15 11:00:00	NVDA	Stock	0.1682	0.1708	0.1667	0.1702	161220000.0
2002-07-15 12:00:00	NVDA	Stock	0.1704	0.1747	0.1683	0.1717	169032000.0
2002-07-15 13:00:00	NVDA	Stock	0.1717	0.1737	0.1702	0.1715	147120000.0
2002-07-15 14:00:00	NVDA	Stock	0.1714	0.1716	0.1653	0.1698	228204000.0
2002-07-15 15:00:00	NVDA	Stock	0.1698	0.1825	0.1692	0.1823	308700000.0
2002-07-15 16:00:00	NVDA	Stock	0.1823	0.1829	0.1645	0.1808	31788000.0
2002-07-15 17:00:00	NVDA	Stock	0.1807	0.1829	0.1659	0.1829	2064000.0
2002-07-15 18:00:00	NVDA	Stock	0.1825	0.1831	0.1819	0.1825	1260000.0
2002-07-15 08:00:00	AMZN	Stock	0.77	0.783	0.765	0.78	214000.0
2002-07-15 09:00:00	AMZN	Stock	0.78	0.7945	0.772	0.784	18572000.0
2002-07-15 10:00:00	AMZN	Stock	0.784	0.786	0.7595	0.77	18214000.0
2002-07-15 11:00:00	AMZN	Stock	0.77	0.7725	0.76	0.7695	12848000.0
2002-07-15 12:00:00	AMZN	Stock	0.769	0.78	0.76	0.775	13276000.0
2002-07-15 13:00:00	AMZN	Stock	0.775	0.7795	0.764	0.7695	11440000.0
2002-07-15 14:00:00	AMZN	Stock	0.77	0.77	0.75	0.763	11814000.0
2002-07-15 15:00:00	AMZN	Stock	0.7635	0.799	0.7625	0.799	23412000.0
2002-07-15 16:00:00	AMZN	Stock	0.7985	0.8	0.791	0.797	5284000.0
2002-07-15 17:00:00	AMZN	Stock	0.797	0.8	0.797	0.8	114000.0
2002-07-15 18:00:00	AMZN	Stock	0.7975	0.7975	0.7975	0.7975	20000.0
2002-07-15 09:00:00	CL	Stock	24.5	24.55	24.235	24.275	421200.0
2002-07-15 10:00:00	CL	Stock	24.25	24.335	24.055	24.15	496400.0
2002-07-15 11:00:00	CL	Stock	24.15	24.2	23.6	23.69	890400.0
2002-07-15 12:00:00	CL	Stock	23.69	23.7	23.45	23.615	620800.0
2002-07-15 13:00:00	CL	Stock	23.615	23.615	23.3	23.475	489400.0
2002-07-15 14:00:00	CL	Stock	23.475	23.475	22.985	23.425	1269600.0
2002-07-15 15:00:00	CL	Stock	23.475	24.33	23.435	24.29	1111400.0

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

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