PREVIEW / stock_1hour / 2001-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-15.parquet
  size:    370 KB
  rows:    17,548
  symbols: 1,308

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-06-15 08:00:00	AAPL	Stock	0.3545	0.3545	0.3468	0.3473	196000.0
2001-06-15 09:00:00	AAPL	Stock	0.3473	0.3613	0.342	0.3511	76440000.0
2001-06-15 10:00:00	AAPL	Stock	0.3509	0.3584	0.3455	0.3575	81088000.0
2001-06-15 11:00:00	AAPL	Stock	0.3571	0.3605	0.3543	0.3577	43153600.0
2001-06-15 12:00:00	AAPL	Stock	0.358	0.3679	0.3577	0.3661	51744000.0
2001-06-15 13:00:00	AAPL	Stock	0.3655	0.3705	0.3609	0.3693	55552000.0
2001-06-15 14:00:00	AAPL	Stock	0.3695	0.3695	0.36	0.3623	35403200.0
2001-06-15 15:00:00	AAPL	Stock	0.3621	0.3663	0.3582	0.3646	37956800.0
2001-06-15 16:00:00	AAPL	Stock	0.3648	0.3661	0.3614	0.3646	13165600.0
2001-06-15 17:00:00	AAPL	Stock	0.365	0.365	0.362	0.3646	610400.0
2001-06-15 18:00:00	AAPL	Stock	0.3652	0.3661	0.3652	0.3661	72800.0
2001-06-15 08:00:00	MSFT	Stock	33.75	34.5	33.5	33.65	3068000.0
2001-06-15 09:00:00	MSFT	Stock	33.625	34.255	33.38	33.405	28666000.0
2001-06-15 10:00:00	MSFT	Stock	33.4	33.805	33.225	33.605	17590800.0
2001-06-15 11:00:00	MSFT	Stock	33.605	34.15	33.605	33.66	10640200.0
2001-06-15 12:00:00	MSFT	Stock	33.675	34.08	33.625	34.025	4380400.0
2001-06-15 13:00:00	MSFT	Stock	34.03	34.03	33.73	33.905	5047600.0
2001-06-15 14:00:00	MSFT	Stock	33.9	33.915	33.53	33.73	4873800.0
2001-06-15 15:00:00	MSFT	Stock	33.735	34.075	33.68	34.01	10652600.0
2001-06-15 16:00:00	MSFT	Stock	34.04	34.2	33.695	34.15	9136400.0
2001-06-15 17:00:00	MSFT	Stock	34.015	34.19	33.985	34.005	842000.0
2001-06-15 18:00:00	MSFT	Stock	34.12	34.12	34.015	34.015	31200.0
2001-06-15 08:00:00	NVDA	Stock	0.3833	0.3875	0.3825	0.3835	1656000.0
2001-06-15 09:00:00	NVDA	Stock	0.3838	0.3917	0.3806	0.3809	174768000.0
2001-06-15 10:00:00	NVDA	Stock	0.3802	0.3895	0.3783	0.3883	242424000.0
2001-06-15 11:00:00	NVDA	Stock	0.3883	0.4008	0.3879	0.3929	166512000.0
2001-06-15 12:00:00	NVDA	Stock	0.3929	0.4	0.3928	0.399	59448000.0
2001-06-15 13:00:00	NVDA	Stock	0.3989	0.4029	0.3967	0.402	118248000.0
2001-06-15 14:00:00	NVDA	Stock	0.402	0.4028	0.3948	0.3958	108912000.0
2001-06-15 15:00:00	NVDA	Stock	0.3961	0.3998	0.3931	0.3961	127416000.0
2001-06-15 16:00:00	NVDA	Stock	0.3961	0.3967	0.3957	0.396	24336000.0
2001-06-15 17:00:00	NVDA	Stock	0.3958	0.3975	0.3958	0.3975	408000.0
2001-06-15 18:00:00	NVDA	Stock	0.396	0.396	0.396	0.396	96000.0
2001-06-15 08:00:00	AMZN	Stock	0.6625	0.6625	0.6575	0.6575	42000.0
2001-06-15 09:00:00	AMZN	Stock	0.6595	0.6625	0.643	0.656	10454000.0
2001-06-15 10:00:00	AMZN	Stock	0.6545	0.6615	0.65	0.6565	28986000.0
2001-06-15 11:00:00	AMZN	Stock	0.656	0.673	0.6375	0.64	22768000.0
2001-06-15 12:00:00	AMZN	Stock	0.6435	0.655	0.628	0.654	12942000.0
2001-06-15 13:00:00	AMZN	Stock	0.6525	0.655	0.6425	0.6445	6242000.0
2001-06-15 14:00:00	AMZN	Stock	0.6445	0.649	0.6155	0.623	13552000.0
2001-06-15 15:00:00	AMZN	Stock	0.6225	0.6315	0.615	0.6245	35506000.0
2001-06-15 16:00:00	AMZN	Stock	0.625	0.6505	0.6105	0.6245	9170000.0
2001-06-15 17:00:00	AMZN	Stock	0.6245	0.6245	0.6235	0.6235	18000.0
2001-06-15 09:00:00	CL	Stock	28.86	28.925	28.775	28.925	1182200.0
2001-06-15 10:00:00	CL	Stock	28.925	29.25	28.775	29.215	895000.0
2001-06-15 11:00:00	CL	Stock	29.21	29.215	28.955	29.005	578400.0
2001-06-15 12:00:00	CL	Stock	29.005	29.15	29.0	29.11	336200.0
2001-06-15 13:00:00	CL	Stock	29.11	29.17	29.005	29.005	405000.0
2001-06-15 14:00:00	CL	Stock	29.01	29.15	28.925	29.03	511800.0
2001-06-15 15:00:00	CL	Stock	29.025	29.05	28.685	28.84	790200.0

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

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