PREVIEW / stock_1hour / 2007-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-10.parquet
  size:    723 KB
  rows:    34,497
  symbols: 2,736

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-05-10 09:00:00	AAPL	Stock	3.8082	3.8418	3.7971	3.825	125315456.0
2007-05-10 10:00:00	AAPL	Stock	3.8246	3.8675	3.8171	3.8604	158742472.0
2007-05-10 11:00:00	AAPL	Stock	3.8607	3.8871	3.8429	3.8432	227883684.0
2007-05-10 12:00:00	AAPL	Stock	3.8432	3.8443	3.7829	3.8289	227581788.0
2007-05-10 13:00:00	AAPL	Stock	3.8282	3.8386	3.8118	3.8332	117117280.0
2007-05-10 14:00:00	AAPL	Stock	3.8332	3.8729	3.8321	3.8632	136622444.0
2007-05-10 15:00:00	AAPL	Stock	3.8632	3.8636	3.8268	3.8336	170248428.0
2007-05-10 16:00:00	AAPL	Stock	3.8343	3.8343	3.8336	3.8336	4567164.0
2007-05-10 09:00:00	MSFT	Stock	30.68	30.81	30.64	30.78	4315199.0
2007-05-10 10:00:00	MSFT	Stock	30.78	30.93	30.73	30.86	6713284.0
2007-05-10 11:00:00	MSFT	Stock	30.85	30.89	30.73	30.74	8107767.0
2007-05-10 12:00:00	MSFT	Stock	30.73	30.75	30.64	30.71	5880367.0
2007-05-10 13:00:00	MSFT	Stock	30.715	30.72	30.55	30.65	6032268.0
2007-05-10 14:00:00	MSFT	Stock	30.66	30.72	30.56	30.57	7133458.0
2007-05-10 15:00:00	MSFT	Stock	30.57	30.65	30.53	30.582	9918286.0
2007-05-10 16:00:00	MSFT	Stock	30.58	30.59	30.58	30.58	761542.0
2007-05-10 08:00:00	NVDA	Stock	0.5647	0.5647	0.5587	0.5598	456480.0
2007-05-10 09:00:00	NVDA	Stock	0.5593	0.567	0.5587	0.5648	96885360.0
2007-05-10 10:00:00	NVDA	Stock	0.565	0.5665	0.5608	0.561	94120440.0
2007-05-10 11:00:00	NVDA	Stock	0.561	0.5612	0.5467	0.5468	105300600.0
2007-05-10 12:00:00	NVDA	Stock	0.5465	0.5513	0.5422	0.5458	95645940.0
2007-05-10 13:00:00	NVDA	Stock	0.5458	0.5482	0.5438	0.5462	58719420.0
2007-05-10 14:00:00	NVDA	Stock	0.5462	0.552	0.546	0.5497	66956760.0
2007-05-10 15:00:00	NVDA	Stock	0.5498	0.5512	0.5463	0.547	156011940.0
2007-05-10 16:00:00	NVDA	Stock	0.547	0.5683	0.535	0.5608	56642160.0
2007-05-10 17:00:00	NVDA	Stock	0.5608	0.5813	0.56	0.571	70972620.0
2007-05-10 18:00:00	NVDA	Stock	0.571	0.5758	0.5687	0.571	6825540.0
2007-05-10 19:00:00	NVDA	Stock	0.5723	0.5753	0.5693	0.575	3861360.0
2007-05-10 06:00:00	AMZN	Stock	3.13	3.13	3.13	3.13	2000.0
2007-05-10 07:00:00	AMZN	Stock	3.1275	3.135	3.12	3.123	118440.0
2007-05-10 08:00:00	AMZN	Stock	3.1235	3.125	3.1125	3.125	823740.0
2007-05-10 09:00:00	AMZN	Stock	3.125	3.126	3.1045	3.1205	25144660.0
2007-05-10 10:00:00	AMZN	Stock	3.12	3.1325	3.108	3.1185	25925820.0
2007-05-10 11:00:00	AMZN	Stock	3.1185	3.1225	3.0795	3.08	32426840.0
2007-05-10 12:00:00	AMZN	Stock	3.0805	3.0815	3.0525	3.0665	32531480.0
2007-05-10 13:00:00	AMZN	Stock	3.0665	3.0735	3.048	3.066	25238320.0
2007-05-10 14:00:00	AMZN	Stock	3.0655	3.0815	3.065	3.0685	16543180.0
2007-05-10 15:00:00	AMZN	Stock	3.0685	3.075	3.0425	3.045	38186540.0
2007-05-10 16:00:00	AMZN	Stock	3.0445	3.0505	3.0435	3.05	1782940.0
2007-05-10 17:00:00	AMZN	Stock	3.05	3.055	3.05	3.0535	141700.0
2007-05-10 18:00:00	AMZN	Stock	3.058	3.06	3.0535	3.0535	50400.0
2007-05-10 19:00:00	AMZN	Stock	3.0515	3.0535	3.05	3.0535	41000.0
2007-05-10 09:00:00	TLT	Stock	88.4	88.49	88.4	88.47	38600.0
2007-05-10 10:00:00	TLT	Stock	88.49	88.49	88.31	88.33	60700.0
2007-05-10 11:00:00	TLT	Stock	88.33	88.47	88.32	88.47	58000.0
2007-05-10 12:00:00	TLT	Stock	88.48	88.57	88.46	88.57	32800.0
2007-05-10 13:00:00	TLT	Stock	88.57	88.59	88.39	88.44	209400.0
2007-05-10 14:00:00	TLT	Stock	88.44	88.47	88.42	88.45	64900.0
2007-05-10 15:00:00	TLT	Stock	88.45	88.52	88.45	88.52	53952.0
2007-05-10 16:00:00	TLT	Stock	88.51	88.51	88.5	88.5	1100.0

> showing 50 of 34,497 rows — these rows as CSV

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