PREVIEW / stock_1hour / 2001-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-23.parquet
  size:    362 KB
  rows:    17,157
  symbols: 1,327

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-08-23 08:00:00	AAPL	Stock	0.3257	0.3257	0.3257	0.3257	1153600.0
2001-08-23 09:00:00	AAPL	Stock	0.3232	0.3266	0.3229	0.3246	13770400.0
2001-08-23 10:00:00	AAPL	Stock	0.3246	0.3275	0.3234	0.3259	26958400.0
2001-08-23 11:00:00	AAPL	Stock	0.3261	0.3261	0.3219	0.3222	10264800.0
2001-08-23 12:00:00	AAPL	Stock	0.3221	0.3234	0.3205	0.3209	12751200.0
2001-08-23 13:00:00	AAPL	Stock	0.3207	0.3216	0.3175	0.3175	22310400.0
2001-08-23 14:00:00	AAPL	Stock	0.3175	0.32	0.3145	0.3195	52500000.0
2001-08-23 15:00:00	AAPL	Stock	0.3193	0.3211	0.3139	0.318	24752000.0
2001-08-23 16:00:00	AAPL	Stock	0.318	0.3192	0.3145	0.318	16055200.0
2001-08-23 17:00:00	AAPL	Stock	0.3186	0.3189	0.318	0.318	2839200.0
2001-08-23 18:00:00	AAPL	Stock	0.318	0.3225	0.318	0.3225	1422400.0
2001-08-23 08:00:00	MSFT	Stock	30.33	30.75	30.3	30.4	64000.0
2001-08-23 09:00:00	MSFT	Stock	30.375	30.755	30.22	30.72	5314600.0
2001-08-23 10:00:00	MSFT	Stock	30.66	30.765	30.395	30.51	5858600.0
2001-08-23 11:00:00	MSFT	Stock	30.515	30.65	30.405	30.505	4484000.0
2001-08-23 12:00:00	MSFT	Stock	30.5098	30.625	30.43	30.52	3461400.0
2001-08-23 13:00:00	MSFT	Stock	30.525	30.575	30.375	30.415	2853200.0
2001-08-23 14:00:00	MSFT	Stock	30.42	30.55	29.89	30.075	5595000.0
2001-08-23 15:00:00	MSFT	Stock	30.075	30.195	29.55	29.56	9221000.0
2001-08-23 16:00:00	MSFT	Stock	29.56	30.73	29.45	29.56	6055000.0
2001-08-23 17:00:00	MSFT	Stock	29.875	29.95	29.56	29.95	403800.0
2001-08-23 18:00:00	MSFT	Stock	29.95	29.985	29.56	29.97	205200.0
2001-08-23 08:00:00	NVDA	Stock	0.3527	0.3552	0.3506	0.3541	2592000.0
2001-08-23 09:00:00	NVDA	Stock	0.3542	0.3552	0.3465	0.3548	183408000.0
2001-08-23 10:00:00	NVDA	Stock	0.3548	0.3566	0.3479	0.3491	206400000.0
2001-08-23 11:00:00	NVDA	Stock	0.349	0.3518	0.348	0.3496	57744000.0
2001-08-23 12:00:00	NVDA	Stock	0.3498	0.3544	0.3494	0.3521	67776000.0
2001-08-23 13:00:00	NVDA	Stock	0.3521	0.3538	0.3479	0.3495	50736000.0
2001-08-23 14:00:00	NVDA	Stock	0.3494	0.3506	0.3438	0.3455	152616000.0
2001-08-23 15:00:00	NVDA	Stock	0.3462	0.3491	0.3438	0.3455	128592000.0
2001-08-23 16:00:00	NVDA	Stock	0.3455	0.352	0.3441	0.3488	17400000.0
2001-08-23 17:00:00	NVDA	Stock	0.3489	0.3501	0.3455	0.3495	2688000.0
2001-08-23 18:00:00	NVDA	Stock	0.3455	0.35	0.3455	0.35	1056000.0
2001-08-23 08:00:00	AMZN	Stock	0.51	0.51	0.51	0.51	36000.0
2001-08-23 09:00:00	AMZN	Stock	0.5095	0.511	0.495	0.4995	12250000.0
2001-08-23 10:00:00	AMZN	Stock	0.4985	0.5034	0.495	0.498	11266000.0
2001-08-23 11:00:00	AMZN	Stock	0.499	0.499	0.486	0.4885	7998000.0
2001-08-23 12:00:00	AMZN	Stock	0.4885	0.496	0.4785	0.4945	8102000.0
2001-08-23 13:00:00	AMZN	Stock	0.495	0.495	0.4875	0.4875	2952000.0
2001-08-23 14:00:00	AMZN	Stock	0.488	0.4895	0.479	0.486	11920000.0
2001-08-23 15:00:00	AMZN	Stock	0.486	0.495	0.4815	0.4815	10768000.0
2001-08-23 16:00:00	AMZN	Stock	0.481	0.4936	0.48	0.4815	6286000.0
2001-08-23 17:00:00	AMZN	Stock	0.485	0.485	0.4815	0.4815	516000.0
2001-08-23 18:00:00	AMZN	Stock	0.4875	0.49	0.4815	0.49	378000.0
2001-08-23 09:00:00	CL	Stock	28.1	28.1	27.925	27.93	216800.0
2001-08-23 10:00:00	CL	Stock	27.93	28.025	27.75	27.795	464000.0
2001-08-23 11:00:00	CL	Stock	27.79	27.85	27.7	27.825	1243400.0
2001-08-23 12:00:00	CL	Stock	27.82	28.0	27.81	27.915	210200.0
2001-08-23 13:00:00	CL	Stock	27.9	28.075	27.875	28.05	271400.0
2001-08-23 14:00:00	CL	Stock	28.05	28.105	27.885	28.05	331200.0

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

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