PREVIEW / stock_1hour / 2007-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-09.parquet
  size:    802 KB
  rows:    39,146
  symbols: 3,088

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-09 09:00:00	AAPL	Stock	4.6825	4.7282	4.6643	4.7171	115856944.0
2007-08-09 10:00:00	AAPL	Stock	4.7175	4.75	4.6911	4.7068	132243832.0
2007-08-09 11:00:00	AAPL	Stock	4.7068	4.7125	4.6557	4.6664	108597916.0
2007-08-09 12:00:00	AAPL	Stock	4.6664	4.6821	4.6432	4.6514	92457568.0
2007-08-09 13:00:00	AAPL	Stock	4.6507	4.6825	4.635	4.6579	94732148.0
2007-08-09 14:00:00	AAPL	Stock	4.6582	4.6596	4.5243	4.5529	203828632.0
2007-08-09 15:00:00	AAPL	Stock	4.5529	4.5682	4.4675	4.5296	306915924.0
2007-08-09 16:00:00	AAPL	Stock	4.5293	4.5422	4.5139	4.5139	16314816.0
2007-08-09 09:00:00	MSFT	Stock	29.64	30.1	29.64	29.923	6267883.0
2007-08-09 10:00:00	MSFT	Stock	29.92	30.07	29.84	29.93	9548200.0
2007-08-09 11:00:00	MSFT	Stock	29.929	30.01	29.62	29.665	6904279.0
2007-08-09 12:00:00	MSFT	Stock	29.665	29.68	29.27	29.32	9340042.0
2007-08-09 13:00:00	MSFT	Stock	29.31	29.47	29.29	29.42	6952142.0
2007-08-09 14:00:00	MSFT	Stock	29.42	29.48	29.23	29.23	7676863.0
2007-08-09 15:00:00	MSFT	Stock	29.23	29.29	28.93	28.95	19889618.0
2007-08-09 16:00:00	MSFT	Stock	29.0	29.0	28.92	28.92	2298214.0
2007-08-09 17:00:00	MSFT	Stock	29.3	29.3	29.3	29.3	15000.0
2007-08-09 07:00:00	NVDA	Stock	0.7528	0.7575	0.7528	0.7573	268200.0
2007-08-09 08:00:00	NVDA	Stock	0.7573	0.7692	0.7567	0.7583	5564340.0
2007-08-09 09:00:00	NVDA	Stock	0.76	0.783	0.7475	0.777	131305740.0
2007-08-09 10:00:00	NVDA	Stock	0.7773	0.7882	0.7723	0.7827	165661200.0
2007-08-09 11:00:00	NVDA	Stock	0.7825	0.79	0.7667	0.779	130369560.0
2007-08-09 12:00:00	NVDA	Stock	0.779	0.785	0.7708	0.7713	84201360.0
2007-08-09 13:00:00	NVDA	Stock	0.7713	0.7873	0.7622	0.7677	108137040.0
2007-08-09 14:00:00	NVDA	Stock	0.7677	0.7868	0.76	0.7608	101873340.0
2007-08-09 15:00:00	NVDA	Stock	0.7608	0.79	0.7583	0.7733	259170720.0
2007-08-09 16:00:00	NVDA	Stock	0.7688	0.8142	0.75	0.796	115515900.0
2007-08-09 17:00:00	NVDA	Stock	0.7958	0.8008	0.7392	0.75	110993280.0
2007-08-09 18:00:00	NVDA	Stock	0.7488	0.7595	0.7475	0.7595	12541080.0
2007-08-09 19:00:00	NVDA	Stock	0.7585	0.7592	0.75	0.7517	3676320.0
2007-08-09 06:00:00	AMZN	Stock	3.91	3.91	3.9	3.9	4000.0
2007-08-09 07:00:00	AMZN	Stock	3.8505	3.8505	3.8505	3.8505	2000.0
2007-08-09 08:00:00	AMZN	Stock	3.851	3.88	3.8055	3.808	453900.0
2007-08-09 09:00:00	AMZN	Stock	3.8085	3.846	3.7635	3.8325	21731720.0
2007-08-09 10:00:00	AMZN	Stock	3.8325	3.863	3.79	3.808	22667000.0
2007-08-09 11:00:00	AMZN	Stock	3.8053	3.82	3.7735	3.7755	18821820.0
2007-08-09 12:00:00	AMZN	Stock	3.775	3.7765	3.763	3.7705	19276660.0
2007-08-09 13:00:00	AMZN	Stock	3.77	3.814	3.7375	3.765	19048580.0
2007-08-09 14:00:00	AMZN	Stock	3.764	3.8105	3.7135	3.72	20837500.0
2007-08-09 15:00:00	AMZN	Stock	3.7185	3.7735	3.71	3.712	34977540.0
2007-08-09 16:00:00	AMZN	Stock	3.712	3.715	3.705	3.7055	3162740.0
2007-08-09 17:00:00	AMZN	Stock	3.7055	3.715	3.7	3.715	810160.0
2007-08-09 18:00:00	AMZN	Stock	3.715	3.715	3.715	3.715	22000.0
2007-08-09 19:00:00	AMZN	Stock	3.71	3.71	3.705	3.705	20680.0
2007-08-09 09:00:00	TLT	Stock	86.75	86.86	86.56	86.63	149700.0
2007-08-09 10:00:00	TLT	Stock	86.63	86.63	86.33	86.45	593500.0
2007-08-09 11:00:00	TLT	Stock	86.48	86.49	86.27	86.35	127400.0
2007-08-09 12:00:00	TLT	Stock	86.33	86.39	86.21	86.26	135600.0
2007-08-09 13:00:00	TLT	Stock	86.27	86.27	85.72	85.91	677900.0
2007-08-09 14:00:00	TLT	Stock	85.92	86.17	85.92	86.07	111700.0

> showing 50 of 39,146 rows — these rows as CSV

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