PREVIEW / stock_1hour / 2001-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-10-12.parquet
  size:    370 KB
  rows:    17,539
  symbols: 1,338

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
2001-10-12 08:00:00	AAPL	Stock	0.3167	0.3167	0.3143	0.3146	173600.0
2001-10-12 09:00:00	AAPL	Stock	0.3141	0.3175	0.3073	0.3139	23245600.0
2001-10-12 10:00:00	AAPL	Stock	0.3145	0.3171	0.3114	0.3125	55098400.0
2001-10-12 11:00:00	AAPL	Stock	0.3121	0.315	0.3011	0.3073	44307200.0
2001-10-12 12:00:00	AAPL	Stock	0.3073	0.3152	0.3054	0.3116	61342400.0
2001-10-12 13:00:00	AAPL	Stock	0.3114	0.3143	0.3107	0.3129	23928800.0
2001-10-12 14:00:00	AAPL	Stock	0.3129	0.3163	0.3125	0.315	18446400.0
2001-10-12 15:00:00	AAPL	Stock	0.3155	0.3229	0.3136	0.3218	43607200.0
2001-10-12 16:00:00	AAPL	Stock	0.3216	0.3273	0.3214	0.3273	5056800.0
2001-10-12 17:00:00	AAPL	Stock	0.323	0.3232	0.3193	0.3193	403200.0
2001-10-12 18:00:00	AAPL	Stock	0.3218	0.3245	0.3218	0.3245	72800.0
2001-10-12 08:00:00	MSFT	Stock	28.16	28.25	27.8	27.87	214600.0
2001-10-12 09:00:00	MSFT	Stock	27.8	28.32	27.75	27.805	9015400.0
2001-10-12 10:00:00	MSFT	Stock	27.815	28.3005	27.76	28.0	11788000.0
2001-10-12 11:00:00	MSFT	Stock	27.9845	28.1	27.375	27.8005	8217800.0
2001-10-12 12:00:00	MSFT	Stock	27.815	27.9	27.275	27.48	9046600.0
2001-10-12 13:00:00	MSFT	Stock	27.4795	27.7495	27.4	27.53	4424000.0
2001-10-12 14:00:00	MSFT	Stock	27.53	27.87	27.4695	27.85	5316600.0
2001-10-12 15:00:00	MSFT	Stock	27.845	28.2505	27.515	28.2	9902200.0
2001-10-12 16:00:00	MSFT	Stock	28.18	28.2	27.7296	28.07	2479800.0
2001-10-12 17:00:00	MSFT	Stock	28.03	28.19	27.475	28.12	167400.0
2001-10-12 18:00:00	MSFT	Stock	28.11	28.11	28.045	28.045	2000.0
2001-10-12 08:00:00	NVDA	Stock	0.3217	0.3217	0.3092	0.3093	1224000.0
2001-10-12 09:00:00	NVDA	Stock	0.3093	0.3192	0.3071	0.3127	141612000.0
2001-10-12 10:00:00	NVDA	Stock	0.3129	0.3325	0.3129	0.3256	233676000.0
2001-10-12 11:00:00	NVDA	Stock	0.3256	0.3283	0.3114	0.3176	155724000.0
2001-10-12 12:00:00	NVDA	Stock	0.3179	0.3202	0.3075	0.3097	128748000.0
2001-10-12 13:00:00	NVDA	Stock	0.3094	0.3162	0.3084	0.3131	70680000.0
2001-10-12 14:00:00	NVDA	Stock	0.3122	0.3222	0.3113	0.3214	119832000.0
2001-10-12 15:00:00	NVDA	Stock	0.3214	0.3371	0.3149	0.3366	270852000.0
2001-10-12 16:00:00	NVDA	Stock	0.3371	0.3375	0.3302	0.3361	52212000.0
2001-10-12 17:00:00	NVDA	Stock	0.3342	0.3369	0.3183	0.3183	852000.0
2001-10-12 08:00:00	AMZN	Stock	0.4	0.41	0.389	0.393	430000.0
2001-10-12 09:00:00	AMZN	Stock	0.3925	0.3925	0.381	0.3825	10070000.0
2001-10-12 10:00:00	AMZN	Stock	0.383	0.4025	0.383	0.389	16754000.0
2001-10-12 11:00:00	AMZN	Stock	0.389	0.39	0.375	0.376	9348000.0
2001-10-12 12:00:00	AMZN	Stock	0.376	0.387	0.3735	0.379	11816000.0
2001-10-12 13:00:00	AMZN	Stock	0.3785	0.3825	0.378	0.382	2474000.0
2001-10-12 14:00:00	AMZN	Stock	0.3815	0.3925	0.3815	0.3915	3752000.0
2001-10-12 15:00:00	AMZN	Stock	0.3915	0.4075	0.39	0.404	13328000.0
2001-10-12 16:00:00	AMZN	Stock	0.404	0.406	0.4015	0.4035	1260000.0
2001-10-12 17:00:00	AMZN	Stock	0.4075	0.4075	0.3985	0.405	910000.0
2001-10-12 18:00:00	AMZN	Stock	0.405	0.405	0.405	0.405	110000.0
2001-10-12 09:00:00	CL	Stock	28.85	28.925	28.58	28.585	309200.0
2001-10-12 10:00:00	CL	Stock	28.585	28.675	28.465	28.605	494000.0
2001-10-12 11:00:00	CL	Stock	28.6	28.725	28.5	28.52	279800.0
2001-10-12 12:00:00	CL	Stock	28.535	28.645	28.35	28.505	252600.0
2001-10-12 13:00:00	CL	Stock	28.505	28.6	28.46	28.505	88600.0
2001-10-12 14:00:00	CL	Stock	28.505	28.725	28.505	28.725	124400.0
2001-10-12 15:00:00	CL	Stock	28.745	28.75	28.56	28.72	556000.0

> showing 50 of 17,539 rows — these rows as CSV

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