PREVIEW / stock_1hour / 2007-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-28.parquet
  size:    745 KB
  rows:    36,396
  symbols: 3,007

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-06-28 09:00:00	AAPL	Stock	4.37	4.3746	4.3079	4.3136	119683732.0
2007-06-28 10:00:00	AAPL	Stock	4.315	4.315	4.2857	4.3061	157969392.0
2007-06-28 11:00:00	AAPL	Stock	4.3061	4.3107	4.29	4.3011	81705680.0
2007-06-28 12:00:00	AAPL	Stock	4.3011	4.3214	4.2989	4.3151	71000720.0
2007-06-28 13:00:00	AAPL	Stock	4.3154	4.3304	4.3043	4.3275	49691544.0
2007-06-28 14:00:00	AAPL	Stock	4.3279	4.3568	4.3064	4.3279	162320116.0
2007-06-28 15:00:00	AAPL	Stock	4.3279	4.3296	4.305	4.3057	135716532.0
2007-06-28 16:00:00	AAPL	Stock	4.3057	4.3057	4.3057	4.3057	22624532.0
2007-06-28 09:00:00	MSFT	Stock	29.86	29.9	29.76	29.85	3593252.0
2007-06-28 10:00:00	MSFT	Stock	29.85	29.91	29.78	29.79	5523279.0
2007-06-28 11:00:00	MSFT	Stock	29.8	29.82	29.68	29.761	5438553.0
2007-06-28 12:00:00	MSFT	Stock	29.76	29.82	29.72	29.82	4184817.0
2007-06-28 13:00:00	MSFT	Stock	29.82	29.83	29.75	29.81	2069279.0
2007-06-28 14:00:00	MSFT	Stock	29.81	29.97	29.76	29.97	9132438.0
2007-06-28 15:00:00	MSFT	Stock	29.96	29.97	29.83	29.83	8237635.0
2007-06-28 16:00:00	MSFT	Stock	29.83	29.83	29.83	29.83	1026962.0
2007-06-28 08:00:00	NVDA	Stock	0.6992	0.7025	0.695	0.6952	764400.0
2007-06-28 09:00:00	NVDA	Stock	0.695	0.7053	0.6883	0.7035	72721620.0
2007-06-28 10:00:00	NVDA	Stock	0.7035	0.7068	0.699	0.7012	100719120.0
2007-06-28 11:00:00	NVDA	Stock	0.7012	0.705	0.7002	0.7043	52270500.0
2007-06-28 12:00:00	NVDA	Stock	0.7042	0.7073	0.7035	0.7048	52697280.0
2007-06-28 13:00:00	NVDA	Stock	0.7047	0.7058	0.6992	0.7023	84906000.0
2007-06-28 14:00:00	NVDA	Stock	0.7023	0.7073	0.6968	0.7022	106712400.0
2007-06-28 15:00:00	NVDA	Stock	0.7022	0.7047	0.6983	0.6993	97023120.0
2007-06-28 16:00:00	NVDA	Stock	0.6993	0.7038	0.6983	0.7014	8787420.0
2007-06-28 17:00:00	NVDA	Stock	0.7033	0.7033	0.7005	0.7005	31140.0
2007-06-28 18:00:00	NVDA	Stock	0.7008	0.7012	0.7008	0.7012	406860.0
2007-06-28 07:00:00	AMZN	Stock	3.4	3.4075	3.4	3.4075	66100.0
2007-06-28 08:00:00	AMZN	Stock	3.405	3.43	3.405	3.425	659520.0
2007-06-28 09:00:00	AMZN	Stock	3.425	3.452	3.4075	3.4505	23578980.0
2007-06-28 10:00:00	AMZN	Stock	3.4505	3.5115	3.45	3.4855	58696960.0
2007-06-28 11:00:00	AMZN	Stock	3.4864	3.4945	3.4815	3.494	14928960.0
2007-06-28 12:00:00	AMZN	Stock	3.494	3.4955	3.4775	3.4785	8992600.0
2007-06-28 13:00:00	AMZN	Stock	3.479	3.4835	3.464	3.473	17690620.0
2007-06-28 14:00:00	AMZN	Stock	3.4725	3.49	3.4465	3.465	28642160.0
2007-06-28 15:00:00	AMZN	Stock	3.4655	3.48	3.4395	3.447	33389680.0
2007-06-28 16:00:00	AMZN	Stock	3.447	3.46	3.4425	3.46	2663020.0
2007-06-28 17:00:00	AMZN	Stock	3.46	3.4635	3.457	3.46	68800.0
2007-06-28 18:00:00	AMZN	Stock	3.46	3.46	3.46	3.46	2000.0
2007-06-28 19:00:00	AMZN	Stock	3.4635	3.4635	3.4635	3.4635	2000.0
2007-06-28 09:00:00	TLT	Stock	84.32	84.5	84.31	84.45	153500.0
2007-06-28 10:00:00	TLT	Stock	84.45	84.58	84.4	84.52	162100.0
2007-06-28 11:00:00	TLT	Stock	84.51	84.51	84.37	84.42	111400.0
2007-06-28 12:00:00	TLT	Stock	84.43	84.51	84.43	84.49	294800.0
2007-06-28 13:00:00	TLT	Stock	84.49	84.55	84.41	84.43	264400.0
2007-06-28 14:00:00	TLT	Stock	84.44	84.53	84.18	84.2	1210941.0
2007-06-28 15:00:00	TLT	Stock	84.22	84.4	84.21	84.38	1359752.0
2007-06-28 16:00:00	TLT	Stock	84.38	84.38	84.3	84.3	44300.0
2007-06-28 09:00:00	CL	Stock	32.17	32.655	32.08	32.505	657400.0
2007-06-28 10:00:00	CL	Stock	32.505	32.545	32.445	32.5	837800.0

> showing 50 of 36,396 rows — these rows as CSV

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