PREVIEW / stock_1hour / 2001-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-31.parquet
  size:    373 KB
  rows:    17,876
  symbols: 1,329

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-07-31 08:00:00	AAPL	Stock	0.3386	0.3386	0.338	0.3384	263200.0
2001-07-31 09:00:00	AAPL	Stock	0.3384	0.3489	0.3305	0.3361	33297600.0
2001-07-31 10:00:00	AAPL	Stock	0.3359	0.3441	0.3321	0.3438	46726400.0
2001-07-31 11:00:00	AAPL	Stock	0.3438	0.3468	0.3411	0.3411	32188800.0
2001-07-31 12:00:00	AAPL	Stock	0.3411	0.3434	0.3393	0.3418	20591200.0
2001-07-31 13:00:00	AAPL	Stock	0.3416	0.3438	0.3409	0.3425	19930400.0
2001-07-31 14:00:00	AAPL	Stock	0.3425	0.3427	0.3371	0.3405	18132800.0
2001-07-31 15:00:00	AAPL	Stock	0.3409	0.3425	0.3348	0.3354	38337600.0
2001-07-31 16:00:00	AAPL	Stock	0.3359	0.3405	0.3348	0.3355	9189600.0
2001-07-31 17:00:00	AAPL	Stock	0.338	0.338	0.3352	0.3352	44800.0
2001-07-31 18:00:00	AAPL	Stock	0.3343	0.3343	0.3343	0.3343	5600.0
2001-07-31 08:00:00	MSFT	Stock	33.205	33.205	32.9	33.0	112800.0
2001-07-31 09:00:00	MSFT	Stock	33.005	33.245	32.91	33.06	4624400.0
2001-07-31 10:00:00	MSFT	Stock	33.06	33.485	32.925	33.42	11376800.0
2001-07-31 11:00:00	MSFT	Stock	33.42	33.695	33.34	33.485	7905000.0
2001-07-31 12:00:00	MSFT	Stock	33.485	33.615	33.44	33.54	7049400.0
2001-07-31 13:00:00	MSFT	Stock	33.535	33.54	33.42	33.525	5297000.0
2001-07-31 14:00:00	MSFT	Stock	33.525	33.535	33.35	33.46	5202800.0
2001-07-31 15:00:00	MSFT	Stock	33.46	33.505	33.05	33.095	11973400.0
2001-07-31 16:00:00	MSFT	Stock	33.095	33.37	33.065	33.36	2741400.0
2001-07-31 17:00:00	MSFT	Stock	33.1	33.175	33.095	33.175	55400.0
2001-07-31 18:00:00	MSFT	Stock	33.175	33.175	33.1	33.1	1200.0
2001-07-31 08:00:00	NVDA	Stock	0.3308	0.3308	0.3292	0.3292	384000.0
2001-07-31 09:00:00	NVDA	Stock	0.3294	0.3333	0.3221	0.3231	104760000.0
2001-07-31 10:00:00	NVDA	Stock	0.3233	0.3287	0.3179	0.3283	246576000.0
2001-07-31 11:00:00	NVDA	Stock	0.3283	0.329	0.324	0.3262	122088000.0
2001-07-31 12:00:00	NVDA	Stock	0.326	0.3337	0.326	0.328	97296000.0
2001-07-31 13:00:00	NVDA	Stock	0.3283	0.3314	0.3263	0.3288	50592000.0
2001-07-31 14:00:00	NVDA	Stock	0.3288	0.3295	0.3246	0.3275	131064000.0
2001-07-31 15:00:00	NVDA	Stock	0.3276	0.3385	0.3272	0.337	353280000.0
2001-07-31 16:00:00	NVDA	Stock	0.3371	0.3375	0.3343	0.3371	41448000.0
2001-07-31 17:00:00	NVDA	Stock	0.335	0.3373	0.3307	0.3354	1968000.0
2001-07-31 18:00:00	NVDA	Stock	0.3334	0.3334	0.3334	0.3334	24000.0
2001-07-31 08:00:00	AMZN	Stock	0.63	0.6375	0.625	0.6375	2004000.0
2001-07-31 09:00:00	AMZN	Stock	0.634	0.643	0.6275	0.6305	13772000.0
2001-07-31 10:00:00	AMZN	Stock	0.63	0.636	0.6165	0.6325	13458000.0
2001-07-31 11:00:00	AMZN	Stock	0.6325	0.6325	0.6205	0.621	9728000.0
2001-07-31 12:00:00	AMZN	Stock	0.621	0.625	0.6175	0.6215	7870000.0
2001-07-31 13:00:00	AMZN	Stock	0.62	0.6245	0.6195	0.623	3538000.0
2001-07-31 14:00:00	AMZN	Stock	0.625	0.6265	0.62	0.6245	9326000.0
2001-07-31 15:00:00	AMZN	Stock	0.6245	0.6275	0.6215	0.625	23660000.0
2001-07-31 16:00:00	AMZN	Stock	0.624	0.6325	0.621	0.6245	2404000.0
2001-07-31 17:00:00	AMZN	Stock	0.6115	0.6325	0.6115	0.6245	174000.0
2001-07-31 18:00:00	AMZN	Stock	0.6275	0.6275	0.6275	0.6275	2000.0
2001-07-31 09:00:00	CL	Stock	27.05	27.45	27.05	27.275	567200.0
2001-07-31 10:00:00	CL	Stock	27.25	27.5	27.115	27.12	484000.0
2001-07-31 11:00:00	CL	Stock	27.12	27.4	27.12	27.35	902800.0
2001-07-31 12:00:00	CL	Stock	27.35	27.39	27.275	27.29	514000.0
2001-07-31 13:00:00	CL	Stock	27.275	27.285	27.15	27.19	275000.0
2001-07-31 14:00:00	CL	Stock	27.19	27.22	27.04	27.11	844000.0

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

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