PREVIEW / stock_1hour / 2007-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-18.parquet
  size:    761 KB
  rows:    37,646
  symbols: 3,121

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
2007-09-18 09:00:00	AAPL	Stock	4.9664	4.975	4.9257	4.9404	80619980.0
2007-09-18 10:00:00	AAPL	Stock	4.94	4.9536	4.9225	4.9514	96808656.0
2007-09-18 11:00:00	AAPL	Stock	4.9525	4.9768	4.9454	4.9521	90077316.0
2007-09-18 12:00:00	AAPL	Stock	4.9521	4.9654	4.9443	4.9582	36782424.0
2007-09-18 13:00:00	AAPL	Stock	4.9586	4.9611	4.9293	4.9446	50511188.0
2007-09-18 14:00:00	AAPL	Stock	4.9439	5.1018	4.9311	5.0618	335954164.0
2007-09-18 15:00:00	AAPL	Stock	5.0618	5.0636	5.0125	5.0318	248764656.0
2007-09-18 16:00:00	AAPL	Stock	5.0325	5.0329	5.0319	5.0329	12319160.0
2007-09-18 09:00:00	MSFT	Stock	28.7	28.87	28.42	28.43	4977563.0
2007-09-18 10:00:00	MSFT	Stock	28.44	28.55	28.4	28.5	6173182.0
2007-09-18 11:00:00	MSFT	Stock	28.5	28.58	28.4	28.43	6174912.0
2007-09-18 12:00:00	MSFT	Stock	28.43	28.44	28.32	28.36	4186054.0
2007-09-18 13:00:00	MSFT	Stock	28.36	28.41	28.32	28.36	6031146.0
2007-09-18 14:00:00	MSFT	Stock	28.36	28.75	28.27	28.65	14443257.0
2007-09-18 15:00:00	MSFT	Stock	28.65	28.96	28.57	28.91	18565006.0
2007-09-18 16:00:00	MSFT	Stock	28.91	28.93	28.91	28.93	3147106.0
2007-09-18 08:00:00	NVDA	Stock	0.8095	0.815	0.8095	0.815	309000.0
2007-09-18 09:00:00	NVDA	Stock	0.813	0.8332	0.8118	0.829	68556480.0
2007-09-18 10:00:00	NVDA	Stock	0.829	0.8355	0.8268	0.8348	61186760.0
2007-09-18 11:00:00	NVDA	Stock	0.8348	0.8432	0.829	0.8332	102551240.0
2007-09-18 12:00:00	NVDA	Stock	0.8335	0.835	0.8235	0.8338	53335520.0
2007-09-18 13:00:00	NVDA	Stock	0.8338	0.8348	0.8298	0.8328	53012120.0
2007-09-18 14:00:00	NVDA	Stock	0.8325	0.8675	0.8312	0.8665	179759360.0
2007-09-18 15:00:00	NVDA	Stock	0.8662	0.8875	0.8658	0.875	254746520.0
2007-09-18 16:00:00	NVDA	Stock	0.875	0.875	0.8688	0.8738	20967760.0
2007-09-18 17:00:00	NVDA	Stock	0.8742	0.8782	0.8738	0.8782	84800.0
2007-09-18 18:00:00	NVDA	Stock	0.875	0.8775	0.875	0.8752	115160.0
2007-09-18 19:00:00	NVDA	Stock	0.8775	0.881	0.8775	0.881	43640.0
2007-09-18 07:00:00	AMZN	Stock	4.39	4.4	4.375	4.3875	25700.0
2007-09-18 08:00:00	AMZN	Stock	4.3545	4.38	4.3545	4.3675	242840.0
2007-09-18 09:00:00	AMZN	Stock	4.3675	4.37	4.3355	4.3685	7360060.0
2007-09-18 10:00:00	AMZN	Stock	4.3685	4.3995	4.3615	4.385	15883820.0
2007-09-18 11:00:00	AMZN	Stock	4.385	4.4075	4.3815	4.391	10646260.0
2007-09-18 12:00:00	AMZN	Stock	4.391	4.394	4.3775	4.3795	8115520.0
2007-09-18 13:00:00	AMZN	Stock	4.3795	4.3859	4.3689	4.3695	10302320.0
2007-09-18 14:00:00	AMZN	Stock	4.369	4.58	4.3685	4.4998	52754420.0
2007-09-18 15:00:00	AMZN	Stock	4.5	4.5	4.4325	4.436	60759260.0
2007-09-18 16:00:00	AMZN	Stock	4.4355	4.4425	4.43	4.4425	2527520.0
2007-09-18 17:00:00	AMZN	Stock	4.4405	4.4405	4.427	4.4375	118920.0
2007-09-18 18:00:00	AMZN	Stock	4.4445	4.4575	4.4445	4.45	107840.0
2007-09-18 19:00:00	AMZN	Stock	4.46	4.4625	4.46	4.4625	18360.0
2007-09-18 09:00:00	TLT	Stock	89.8	89.99	89.8	89.93	34000.0
2007-09-18 10:00:00	TLT	Stock	89.93	89.96	89.83	89.91	164600.0
2007-09-18 11:00:00	TLT	Stock	89.9	89.99	89.89	89.96	122700.0
2007-09-18 12:00:00	TLT	Stock	89.95	89.95	89.86	89.91	143300.0
2007-09-18 13:00:00	TLT	Stock	89.91	89.93	89.78	89.78	37100.0
2007-09-18 14:00:00	TLT	Stock	89.78	90.24	89.0	89.56	2035500.0
2007-09-18 15:00:00	TLT	Stock	89.58	89.66	89.49	89.58	406300.0
2007-09-18 16:00:00	TLT	Stock	89.62	89.68	89.62	89.66	30900.0
2007-09-18 08:00:00	CL	Stock	34.025	34.025	34.025	34.025	400.0

> showing 50 of 37,646 rows — these rows as CSV

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