PREVIEW / stock_1hour / 2002-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-12.parquet
  size:    405 KB
  rows:    18,731
  symbols: 1,401

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-04-12 08:00:00	AAPL	Stock	0.4384	0.4764	0.4384	0.4459	229600.0
2002-04-12 09:00:00	AAPL	Stock	0.4466	0.447	0.4388	0.4446	27003200.0
2002-04-12 10:00:00	AAPL	Stock	0.4444	0.4446	0.4391	0.4413	47040000.0
2002-04-12 11:00:00	AAPL	Stock	0.4418	0.4443	0.4389	0.4434	41882400.0
2002-04-12 12:00:00	AAPL	Stock	0.4434	0.4479	0.4434	0.445	28470400.0
2002-04-12 13:00:00	AAPL	Stock	0.445	0.4471	0.4445	0.445	21912800.0
2002-04-12 14:00:00	AAPL	Stock	0.4452	0.4488	0.445	0.4468	56056000.0
2002-04-12 15:00:00	AAPL	Stock	0.4468	0.4495	0.445	0.4473	63520800.0
2002-04-12 16:00:00	AAPL	Stock	0.448	0.4486	0.4451	0.4475	12712000.0
2002-04-12 17:00:00	AAPL	Stock	0.4475	0.4475	0.4475	0.4475	397600.0
2002-04-12 08:00:00	MSFT	Stock	27.6	27.735	27.55	27.635	59800.0
2002-04-12 09:00:00	MSFT	Stock	27.635	27.745	27.43	27.73	7492600.0
2002-04-12 10:00:00	MSFT	Stock	27.73	27.985	27.6606	27.815	9800800.0
2002-04-12 11:00:00	MSFT	Stock	27.81	27.86	27.515	27.6635	6250800.0
2002-04-12 12:00:00	MSFT	Stock	27.655	27.85	27.63	27.75	5848000.0
2002-04-12 13:00:00	MSFT	Stock	27.74	27.85	27.625	27.725	3340200.0
2002-04-12 14:00:00	MSFT	Stock	27.73	28.095	27.715	27.99	6086000.0
2002-04-12 15:00:00	MSFT	Stock	27.98	28.13	27.7495	27.96	8535400.0
2002-04-12 16:00:00	MSFT	Stock	27.96	27.99	27.7614	27.945	1875800.0
2002-04-12 17:00:00	MSFT	Stock	27.94	27.965	27.94	27.95	59600.0
2002-04-12 18:00:00	MSFT	Stock	27.955	27.965	27.955	27.96	5000.0
2002-04-12 08:00:00	NVDA	Stock	0.31	0.3129	0.3083	0.3121	2676000.0
2002-04-12 09:00:00	NVDA	Stock	0.3147	0.3299	0.3059	0.312	151032000.0
2002-04-12 10:00:00	NVDA	Stock	0.3117	0.3118	0.3012	0.3017	304596000.0
2002-04-12 11:00:00	NVDA	Stock	0.3017	0.3028	0.2962	0.2997	273180000.0
2002-04-12 12:00:00	NVDA	Stock	0.2998	0.3033	0.2983	0.3019	129048000.0
2002-04-12 13:00:00	NVDA	Stock	0.3019	0.3024	0.2985	0.2987	79152000.0
2002-04-12 14:00:00	NVDA	Stock	0.2986	0.3107	0.2986	0.3076	195648000.0
2002-04-12 15:00:00	NVDA	Stock	0.3072	0.3102	0.3033	0.3057	174480000.0
2002-04-12 16:00:00	NVDA	Stock	0.3057	0.3078	0.3033	0.3072	16800000.0
2002-04-12 17:00:00	NVDA	Stock	0.3062	0.3074	0.3057	0.3062	648000.0
2002-04-12 18:00:00	NVDA	Stock	0.3057	0.3057	0.3057	0.3057	60000.0
2002-04-12 08:00:00	AMZN	Stock	0.65	0.6525	0.65	0.6515	32000.0
2002-04-12 09:00:00	AMZN	Stock	0.65	0.6565	0.6425	0.6555	18112000.0
2002-04-12 10:00:00	AMZN	Stock	0.6555	0.669	0.6525	0.6595	18084000.0
2002-04-12 11:00:00	AMZN	Stock	0.66	0.6615	0.6475	0.6525	13804000.0
2002-04-12 12:00:00	AMZN	Stock	0.6525	0.6605	0.6515	0.6585	7688000.0
2002-04-12 13:00:00	AMZN	Stock	0.659	0.6685	0.657	0.6665	14936000.0
2002-04-12 14:00:00	AMZN	Stock	0.666	0.6805	0.665	0.674	11982000.0
2002-04-12 15:00:00	AMZN	Stock	0.674	0.6755	0.6615	0.6635	16886000.0
2002-04-12 16:00:00	AMZN	Stock	0.664	0.667	0.6607	0.6645	1426000.0
2002-04-12 17:00:00	AMZN	Stock	0.664	0.6655	0.66	0.66	236000.0
2002-04-12 18:00:00	AMZN	Stock	0.656	0.656	0.656	0.656	18000.0
2002-04-12 09:00:00	CL	Stock	28.71	28.97	28.71	28.95	212200.0
2002-04-12 10:00:00	CL	Stock	28.97	29.075	28.95	28.995	542000.0
2002-04-12 11:00:00	CL	Stock	28.995	29.12	28.9	29.075	312400.0
2002-04-12 12:00:00	CL	Stock	29.075	29.25	29.065	29.19	268000.0
2002-04-12 13:00:00	CL	Stock	29.19	29.275	29.105	29.255	397000.0
2002-04-12 14:00:00	CL	Stock	29.255	29.375	29.255	29.3	321000.0
2002-04-12 15:00:00	CL	Stock	29.3	29.43	29.28	29.32	619600.0

> showing 50 of 18,731 rows — these rows as CSV

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