PREVIEW / stock_1hour / 2002-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-18.parquet
  size:    402 KB
  rows:    18,510
  symbols: 1,388

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-18 08:00:00	AAPL	Stock	0.458	0.458	0.4468	0.4545	470400.0
2002-04-18 09:00:00	AAPL	Stock	0.4554	0.4571	0.4473	0.4491	70336000.0
2002-04-18 10:00:00	AAPL	Stock	0.4491	0.4534	0.4443	0.445	78103200.0
2002-04-18 11:00:00	AAPL	Stock	0.4455	0.452	0.4454	0.4466	54812800.0
2002-04-18 12:00:00	AAPL	Stock	0.4466	0.4518	0.4464	0.45	47672800.0
2002-04-18 13:00:00	AAPL	Stock	0.45	0.4506	0.4473	0.448	15316000.0
2002-04-18 14:00:00	AAPL	Stock	0.448	0.4514	0.4479	0.4498	22052800.0
2002-04-18 15:00:00	AAPL	Stock	0.45	0.4555	0.4496	0.4539	44609600.0
2002-04-18 16:00:00	AAPL	Stock	0.4539	0.457	0.4377	0.4384	19516000.0
2002-04-18 17:00:00	AAPL	Stock	0.4386	0.4473	0.4384	0.4473	375200.0
2002-04-18 18:00:00	AAPL	Stock	0.4509	0.4514	0.4509	0.4514	106400.0
2002-04-18 08:00:00	MSFT	Stock	28.1	28.375	27.825	28.375	140000.0
2002-04-18 09:00:00	MSFT	Stock	28.35	28.65	28.22	28.62	7215400.0
2002-04-18 10:00:00	MSFT	Stock	28.62	28.655	28.205	28.275	8481200.0
2002-04-18 11:00:00	MSFT	Stock	28.27	28.5	28.205	28.27	6810000.0
2002-04-18 12:00:00	MSFT	Stock	28.256	28.41	27.92	28.3205	10703400.0
2002-04-18 13:00:00	MSFT	Stock	28.32	28.41	28.23	28.315	4220400.0
2002-04-18 14:00:00	MSFT	Stock	28.315	28.615	28.275	28.4	5024200.0
2002-04-18 15:00:00	MSFT	Stock	28.405	28.495	28.19	28.205	6792200.0
2002-04-18 16:00:00	MSFT	Stock	28.205	28.429	25.895	26.6	17562400.0
2002-04-18 17:00:00	MSFT	Stock	26.58	27.049	26.19	26.97	4541800.0
2002-04-18 18:00:00	MSFT	Stock	26.955	27.5505	26.655	27.445	1718400.0
2002-04-18 08:00:00	NVDA	Stock	0.3357	0.3357	0.3258	0.335	5688000.0
2002-04-18 09:00:00	NVDA	Stock	0.3362	0.3362	0.3297	0.3338	87504000.0
2002-04-18 10:00:00	NVDA	Stock	0.334	0.3343	0.3277	0.3309	118836000.0
2002-04-18 11:00:00	NVDA	Stock	0.3308	0.3314	0.3252	0.3262	89928000.0
2002-04-18 12:00:00	NVDA	Stock	0.3262	0.3292	0.3229	0.3287	98532000.0
2002-04-18 13:00:00	NVDA	Stock	0.3287	0.3307	0.3262	0.3279	56892000.0
2002-04-18 14:00:00	NVDA	Stock	0.3281	0.3337	0.3279	0.3299	85080000.0
2002-04-18 15:00:00	NVDA	Stock	0.3296	0.3322	0.329	0.3302	85008000.0
2002-04-18 16:00:00	NVDA	Stock	0.3302	0.331	0.3167	0.3167	17328000.0
2002-04-18 17:00:00	NVDA	Stock	0.3173	0.3183	0.3129	0.3142	10644000.0
2002-04-18 18:00:00	NVDA	Stock	0.3139	0.3183	0.3133	0.3167	2808000.0
2002-04-18 08:00:00	AMZN	Stock	0.7375	0.7428	0.735	0.735	74000.0
2002-04-18 09:00:00	AMZN	Stock	0.735	0.743	0.729	0.7415	7436000.0
2002-04-18 10:00:00	AMZN	Stock	0.741	0.741	0.715	0.7235	17136000.0
2002-04-18 11:00:00	AMZN	Stock	0.7235	0.724	0.7055	0.7065	7984000.0
2002-04-18 12:00:00	AMZN	Stock	0.707	0.716	0.6975	0.7135	15970000.0
2002-04-18 13:00:00	AMZN	Stock	0.7135	0.719	0.71	0.7105	6472000.0
2002-04-18 14:00:00	AMZN	Stock	0.7102	0.7245	0.71	0.713	4428000.0
2002-04-18 15:00:00	AMZN	Stock	0.713	0.7265	0.7125	0.7145	8502000.0
2002-04-18 16:00:00	AMZN	Stock	0.716	0.7177	0.6925	0.6975	3254000.0
2002-04-18 17:00:00	AMZN	Stock	0.696	0.713	0.6895	0.713	212000.0
2002-04-18 18:00:00	AMZN	Stock	0.6975	0.7	0.6975	0.7	30000.0
2002-04-18 09:00:00	CL	Stock	27.25	27.375	27.0	27.14	2324400.0
2002-04-18 10:00:00	CL	Stock	27.135	27.425	26.85	27.325	4489400.0
2002-04-18 11:00:00	CL	Stock	27.33	27.9	27.275	27.275	3224200.0
2002-04-18 12:00:00	CL	Stock	27.28	27.29	26.55	27.085	3275000.0
2002-04-18 13:00:00	CL	Stock	27.1	27.125	26.59	26.925	2550600.0
2002-04-18 14:00:00	CL	Stock	26.91	26.985	26.775	26.775	2806800.0

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

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