PREVIEW / stock_1hour / 2007-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-29.parquet
  size:    750 KB
  rows:    37,296
  symbols: 3,103

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-08-29 09:00:00	AAPL	Stock	4.6368	4.695	4.6264	4.6729	189361788.0
2007-08-29 10:00:00	AAPL	Stock	4.6732	4.7354	4.6636	4.7279	206684660.0
2007-08-29 11:00:00	AAPL	Stock	4.7282	4.7568	4.5714	4.7402	142627464.0
2007-08-29 12:00:00	AAPL	Stock	4.74	4.7421	4.6411	4.7046	84434168.0
2007-08-29 13:00:00	AAPL	Stock	4.7039	4.7296	4.6982	4.7104	96350912.0
2007-08-29 14:00:00	AAPL	Stock	4.7111	4.7536	4.7096	4.7536	107920904.0
2007-08-29 15:00:00	AAPL	Stock	4.7529	4.7921	4.7504	4.7861	212301880.0
2007-08-29 16:00:00	AAPL	Stock	4.7864	4.7886	4.7861	4.7886	9527812.0
2007-08-29 09:00:00	MSFT	Stock	28.13	28.13	27.92	27.979	3540073.0
2007-08-29 10:00:00	MSFT	Stock	27.975	28.09	27.82	28.05	6108225.0
2007-08-29 11:00:00	MSFT	Stock	28.05	28.27	27.98	28.25	4976895.0
2007-08-29 12:00:00	MSFT	Stock	28.24	28.27	28.18	28.232	2481944.0
2007-08-29 13:00:00	MSFT	Stock	28.235	28.26	28.12	28.19	3118462.0
2007-08-29 14:00:00	MSFT	Stock	28.19	28.435	28.19	28.41	4757228.0
2007-08-29 15:00:00	MSFT	Stock	28.41	28.61	28.41	28.59	8949030.0
2007-08-29 16:00:00	MSFT	Stock	28.59	28.59	28.59	28.59	1988493.0
2007-08-29 08:00:00	NVDA	Stock	0.7833	0.7865	0.7817	0.7838	739500.0
2007-08-29 09:00:00	NVDA	Stock	0.7845	0.7992	0.7825	0.7935	74592240.0
2007-08-29 10:00:00	NVDA	Stock	0.7935	0.8045	0.793	0.803	74942160.0
2007-08-29 11:00:00	NVDA	Stock	0.803	0.807	0.7965	0.8042	60171660.0
2007-08-29 12:00:00	NVDA	Stock	0.8042	0.8047	0.7958	0.7991	47452740.0
2007-08-29 13:00:00	NVDA	Stock	0.7988	0.801	0.7932	0.7948	59762400.0
2007-08-29 14:00:00	NVDA	Stock	0.7948	0.8058	0.7945	0.8025	63066660.0
2007-08-29 15:00:00	NVDA	Stock	0.8027	0.817	0.8018	0.816	121221600.0
2007-08-29 16:00:00	NVDA	Stock	0.8157	0.8165	0.8143	0.8143	2878080.0
2007-08-29 17:00:00	NVDA	Stock	0.8165	0.8165	0.8158	0.8158	12000.0
2007-08-29 19:00:00	NVDA	Stock	0.8157	0.816	0.8137	0.8137	64800.0
2007-08-29 06:00:00	AMZN	Stock	3.875	3.875	3.875	3.875	2000.0
2007-08-29 07:00:00	AMZN	Stock	3.85	3.85	3.85	3.85	2000.0
2007-08-29 08:00:00	AMZN	Stock	3.85	3.8545	3.8415	3.8545	164900.0
2007-08-29 09:00:00	AMZN	Stock	3.8505	3.8765	3.843	3.867	13924020.0
2007-08-29 10:00:00	AMZN	Stock	3.8665	3.908	3.853	3.8985	16772800.0
2007-08-29 11:00:00	AMZN	Stock	3.8985	3.909	3.8825	3.893	12961520.0
2007-08-29 12:00:00	AMZN	Stock	3.8935	3.895	3.8663	3.876	6313420.0
2007-08-29 13:00:00	AMZN	Stock	3.876	3.8828	3.85	3.857	9267820.0
2007-08-29 14:00:00	AMZN	Stock	3.857	3.9005	3.857	3.891	10731840.0
2007-08-29 15:00:00	AMZN	Stock	3.891	3.9525	3.891	3.95	20882860.0
2007-08-29 16:00:00	AMZN	Stock	3.9505	3.9625	3.95	3.951	3432120.0
2007-08-29 17:00:00	AMZN	Stock	3.9525	3.965	3.951	3.965	65600.0
2007-08-29 18:00:00	AMZN	Stock	3.956	3.956	3.9535	3.9535	15760.0
2007-08-29 19:00:00	AMZN	Stock	3.9655	3.975	3.9625	3.975	47360.0
2007-08-29 09:00:00	TLT	Stock	88.49	88.72	88.44	88.71	456500.0
2007-08-29 10:00:00	TLT	Stock	88.72	88.77	88.6	88.65	596700.0
2007-08-29 11:00:00	TLT	Stock	88.66	88.67	88.43	88.44	284400.0
2007-08-29 12:00:00	TLT	Stock	88.43	88.52	88.33	88.42	351300.0
2007-08-29 13:00:00	TLT	Stock	88.42	88.53	88.33	88.41	334700.0
2007-08-29 14:00:00	TLT	Stock	88.41	88.41	88.24	88.3	150300.0
2007-08-29 15:00:00	TLT	Stock	88.3	88.32	88.16	88.22	399600.0
2007-08-29 16:00:00	TLT	Stock	88.22	88.22	88.22	88.22	500.0
2007-08-29 09:00:00	CL	Stock	32.775	32.965	32.755	32.955	189400.0

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

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