PREVIEW / stock_1hour / 2007-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-06.parquet
  size:    810 KB
  rows:    39,842
  symbols: 3,190

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-11-06 04:00:00	AAPL	Stock	6.6493	6.6493	6.6493	6.6493	5600.0
2007-11-06 05:00:00	AAPL	Stock	6.6493	6.6682	6.6493	6.6682	13776.0
2007-11-06 06:00:00	AAPL	Stock	6.6964	6.715	6.6964	6.715	95200.0
2007-11-06 07:00:00	AAPL	Stock	6.7179	6.7321	6.7121	6.7196	467768.0
2007-11-06 08:00:00	AAPL	Stock	6.7196	6.7196	6.6875	6.6889	3565212.0
2007-11-06 09:00:00	AAPL	Stock	6.6864	6.7075	6.6689	6.6943	80971968.0
2007-11-06 10:00:00	AAPL	Stock	6.6944	6.7139	6.6168	6.6429	148369508.0
2007-11-06 11:00:00	AAPL	Stock	6.6443	6.6857	6.6329	6.6714	122897208.0
2007-11-06 12:00:00	AAPL	Stock	6.6718	6.6932	6.6554	6.6796	73661560.0
2007-11-06 13:00:00	AAPL	Stock	6.6789	6.7286	6.6789	6.7118	93510424.0
2007-11-06 14:00:00	AAPL	Stock	6.7118	6.7857	6.6964	6.7468	119935844.0
2007-11-06 15:00:00	AAPL	Stock	6.7496	6.8571	6.7454	6.8539	290223388.0
2007-11-06 16:00:00	AAPL	Stock	6.8536	6.8632	6.6961	6.8621	19983908.0
2007-11-06 17:00:00	AAPL	Stock	6.8621	6.8632	6.6825	6.8611	1086540.0
2007-11-06 18:00:00	AAPL	Stock	6.8593	6.8643	6.6618	6.8571	336336.0
2007-11-06 19:00:00	AAPL	Stock	6.8571	6.8664	6.8543	6.8625	382256.0
2007-11-06 07:00:00	MSFT	Stock	36.73	36.75	36.4	36.5	68800.0
2007-11-06 08:00:00	MSFT	Stock	36.5	36.7	36.4	36.69	119086.0
2007-11-06 09:00:00	MSFT	Stock	36.69	36.77	36.43	36.49	8404349.0
2007-11-06 10:00:00	MSFT	Stock	36.49	36.52	36.07	36.14	20945309.0
2007-11-06 11:00:00	MSFT	Stock	36.14	37.22	35.87	35.99	21102419.0
2007-11-06 12:00:00	MSFT	Stock	35.98	36.08	35.91	36.05	7599847.0
2007-11-06 13:00:00	MSFT	Stock	36.048	36.37	36.04	36.28	10682906.0
2007-11-06 14:00:00	MSFT	Stock	36.28	36.35	36.16	36.31	8470313.0
2007-11-06 15:00:00	MSFT	Stock	36.31	36.47	36.012	36.41	19744883.0
2007-11-06 16:00:00	MSFT	Stock	36.41	36.6	36.185	36.43	5739828.0
2007-11-06 17:00:00	MSFT	Stock	36.42	36.43	36.33	36.35	136744.0
2007-11-06 18:00:00	MSFT	Stock	36.37	36.41	36.01	36.39	28908.0
2007-11-06 19:00:00	MSFT	Stock	36.33	36.44	36.29	36.31	13244.0
2007-11-06 06:00:00	NVDA	Stock	0.9213	0.9213	0.9213	0.9213	20000.0
2007-11-06 08:00:00	NVDA	Stock	0.9188	0.925	0.9188	0.925	66480.0
2007-11-06 09:00:00	NVDA	Stock	0.925	0.9412	0.923	0.9382	51694960.0
2007-11-06 10:00:00	NVDA	Stock	0.938	0.9535	0.9345	0.9528	122762080.0
2007-11-06 11:00:00	NVDA	Stock	0.9528	0.955	0.948	0.9492	84834480.0
2007-11-06 12:00:00	NVDA	Stock	0.9492	0.9512	0.9398	0.9425	75346200.0
2007-11-06 13:00:00	NVDA	Stock	0.9425	0.944	0.9375	0.9378	55250920.0
2007-11-06 14:00:00	NVDA	Stock	0.938	0.9425	0.9352	0.938	48884240.0
2007-11-06 15:00:00	NVDA	Stock	0.9382	0.9512	0.9358	0.9475	100289600.0
2007-11-06 16:00:00	NVDA	Stock	0.9485	0.95	0.9393	0.95	7273720.0
2007-11-06 17:00:00	NVDA	Stock	0.95	0.95	0.95	0.95	119480.0
2007-11-06 18:00:00	NVDA	Stock	0.9525	0.9525	0.9525	0.9525	19720.0
2007-11-06 19:00:00	NVDA	Stock	0.9523	0.9523	0.9523	0.9523	4000.0
2007-11-06 08:00:00	AMZN	Stock	4.2275	4.2675	4.2185	4.25	523060.0
2007-11-06 09:00:00	AMZN	Stock	4.25	4.2775	4.23	4.241	14004000.0
2007-11-06 10:00:00	AMZN	Stock	4.2385	4.2655	4.2185	4.2655	25212760.0
2007-11-06 11:00:00	AMZN	Stock	4.2665	4.275	4.249	4.2628	14600680.0
2007-11-06 12:00:00	AMZN	Stock	4.2615	4.318	4.2495	4.3015	26451260.0
2007-11-06 13:00:00	AMZN	Stock	4.302	4.3575	4.3015	4.3235	25672300.0
2007-11-06 14:00:00	AMZN	Stock	4.323	4.3445	4.3035	4.331	19145300.0
2007-11-06 15:00:00	AMZN	Stock	4.331	4.375	4.331	4.367	27106820.0

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

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