PREVIEW / stock_1hour / 2001-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-14.parquet
  size:    361 KB
  rows:    17,171
  symbols: 1,303

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-14 08:00:00	AAPL	Stock	0.3654	0.3673	0.3625	0.3625	2200800.0
2001-06-14 09:00:00	AAPL	Stock	0.3618	0.3625	0.353	0.3595	72531200.0
2001-06-14 10:00:00	AAPL	Stock	0.3596	0.3625	0.3555	0.3596	71937600.0
2001-06-14 11:00:00	AAPL	Stock	0.3598	0.3632	0.3564	0.3632	25172000.0
2001-06-14 12:00:00	AAPL	Stock	0.363	0.3652	0.3593	0.3609	16962400.0
2001-06-14 13:00:00	AAPL	Stock	0.3609	0.3621	0.3571	0.3584	16839200.0
2001-06-14 14:00:00	AAPL	Stock	0.3584	0.3607	0.3557	0.3596	25922400.0
2001-06-14 15:00:00	AAPL	Stock	0.3593	0.3607	0.3538	0.355	40986400.0
2001-06-14 16:00:00	AAPL	Stock	0.3552	0.3586	0.3509	0.3518	12387200.0
2001-06-14 17:00:00	AAPL	Stock	0.355	0.355	0.355	0.355	1181600.0
2001-06-14 18:00:00	AAPL	Stock	0.3536	0.3536	0.3534	0.3534	56000.0
2001-06-14 08:00:00	MSFT	Stock	35.255	36.8	35.1	35.125	805600.0
2001-06-14 09:00:00	MSFT	Stock	35.225	35.275	34.95	35.095	9571200.0
2001-06-14 10:00:00	MSFT	Stock	35.09	35.105	34.75	34.9	11102200.0
2001-06-14 11:00:00	MSFT	Stock	34.905	34.945	34.75	34.895	6483200.0
2001-06-14 12:00:00	MSFT	Stock	34.895	34.965	34.585	34.62	8053200.0
2001-06-14 13:00:00	MSFT	Stock	34.605	34.695	34.44	34.49	6609200.0
2001-06-14 14:00:00	MSFT	Stock	34.485	34.55	34.2	34.45	10545800.0
2001-06-14 15:00:00	MSFT	Stock	34.445	34.75	34.255	34.455	12286000.0
2001-06-14 16:00:00	MSFT	Stock	34.45	34.735	34.25	34.305	1639200.0
2001-06-14 17:00:00	MSFT	Stock	34.45	34.45	34.31	34.365	652400.0
2001-06-14 18:00:00	MSFT	Stock	34.255	34.335	34.25	34.335	64800.0
2001-06-14 08:00:00	NVDA	Stock	0.3875	0.3908	0.3817	0.3854	2712720.0
2001-06-14 09:00:00	NVDA	Stock	0.3854	0.3966	0.3852	0.3958	123216000.0
2001-06-14 10:00:00	NVDA	Stock	0.3953	0.3958	0.3803	0.3817	177936000.0
2001-06-14 11:00:00	NVDA	Stock	0.3821	0.3896	0.3803	0.3883	118104000.0
2001-06-14 12:00:00	NVDA	Stock	0.3882	0.3896	0.3848	0.386	37008000.0
2001-06-14 13:00:00	NVDA	Stock	0.386	0.387	0.3813	0.3835	77064000.0
2001-06-14 14:00:00	NVDA	Stock	0.3835	0.3885	0.381	0.3862	129744000.0
2001-06-14 15:00:00	NVDA	Stock	0.3859	0.3942	0.3851	0.3904	194640000.0
2001-06-14 16:00:00	NVDA	Stock	0.39	0.3906	0.3838	0.39	32496000.0
2001-06-14 17:00:00	NVDA	Stock	0.386	0.39	0.3854	0.3867	240000.0
2001-06-14 08:00:00	AMZN	Stock	0.7075	0.7075	0.7	0.707	62000.0
2001-06-14 09:00:00	AMZN	Stock	0.705	0.7075	0.687	0.691	12942000.0
2001-06-14 10:00:00	AMZN	Stock	0.69	0.6935	0.6755	0.6765	13874000.0
2001-06-14 11:00:00	AMZN	Stock	0.676	0.6925	0.675	0.6915	9508000.0
2001-06-14 12:00:00	AMZN	Stock	0.6915	0.6935	0.68	0.6805	11790000.0
2001-06-14 13:00:00	AMZN	Stock	0.6825	0.684	0.6695	0.672	17606000.0
2001-06-14 14:00:00	AMZN	Stock	0.672	0.6725	0.658	0.6615	11346000.0
2001-06-14 15:00:00	AMZN	Stock	0.662	0.6855	0.659	0.664	18860000.0
2001-06-14 16:00:00	AMZN	Stock	0.665	0.6655	0.655	0.6645	2994000.0
2001-06-14 17:00:00	AMZN	Stock	0.6645	0.6645	0.66	0.66	64000.0
2001-06-14 18:00:00	AMZN	Stock	0.659	0.659	0.6505	0.6585	24000.0
2001-06-14 09:00:00	CL	Stock	28.925	29.075	28.835	28.955	217800.0
2001-06-14 10:00:00	CL	Stock	28.965	28.965	28.775	28.83	309400.0
2001-06-14 11:00:00	CL	Stock	28.85	28.865	28.755	28.775	146400.0
2001-06-14 12:00:00	CL	Stock	28.775	28.875	28.6	28.87	321400.0
2001-06-14 13:00:00	CL	Stock	28.84	28.875	28.775	28.855	120000.0
2001-06-14 14:00:00	CL	Stock	28.855	28.925	28.775	28.885	161400.0
2001-06-14 15:00:00	CL	Stock	28.885	29.05	28.81	28.86	390600.0

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

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