PREVIEW / stock_1hour / 2007-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-11.parquet
  size:    840 KB
  rows:    41,884
  symbols: 3,146

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-10-11 06:00:00	AAPL	Stock	6.0007	6.0021	6.0007	6.0021	25200.0
2007-10-11 07:00:00	AAPL	Stock	6.0282	6.0721	6.0282	6.0357	1456476.0
2007-10-11 08:00:00	AAPL	Stock	6.0357	6.0621	6.0257	6.0514	9657900.0
2007-10-11 09:00:00	AAPL	Stock	6.05	6.0671	6.0232	6.0668	145236420.0
2007-10-11 10:00:00	AAPL	Stock	6.067	6.0907	6.0539	6.0675	196775684.0
2007-10-11 11:00:00	AAPL	Stock	6.0675	6.0814	6.0582	6.0707	95007192.0
2007-10-11 12:00:00	AAPL	Stock	6.0704	6.1386	6.0643	6.0789	76814724.0
2007-10-11 13:00:00	AAPL	Stock	6.0796	6.0804	5.9725	5.9725	136146584.0
2007-10-11 14:00:00	AAPL	Stock	5.9732	5.9786	5.4718	5.7914	588376264.0
2007-10-11 15:00:00	AAPL	Stock	5.7914	5.8389	5.6464	5.7939	357489328.0
2007-10-11 16:00:00	AAPL	Stock	5.7946	6.0532	5.7679	5.7929	24666432.0
2007-10-11 17:00:00	AAPL	Stock	5.7929	6.0772	5.6786	5.7629	9309552.0
2007-10-11 18:00:00	AAPL	Stock	5.7571	5.8343	5.7482	5.7589	2539544.0
2007-10-11 19:00:00	AAPL	Stock	5.7589	5.7654	5.7386	5.7393	970312.0
2007-10-11 06:00:00	MSFT	Stock	30.33	30.33	30.33	30.33	1100.0
2007-10-11 07:00:00	MSFT	Stock	30.36	30.36	30.36	30.36	3970.0
2007-10-11 08:00:00	MSFT	Stock	30.28	30.41	30.28	30.4	16491.0
2007-10-11 09:00:00	MSFT	Stock	30.39	30.43	30.28	30.36	4486583.0
2007-10-11 10:00:00	MSFT	Stock	30.35	30.63	30.35	30.6	9601064.0
2007-10-11 11:00:00	MSFT	Stock	30.59	30.599	30.48	30.57	3737620.0
2007-10-11 12:00:00	MSFT	Stock	30.56	30.58	30.48	30.5	2377595.0
2007-10-11 13:00:00	MSFT	Stock	30.5	30.51	30.34	30.38	2949188.0
2007-10-11 14:00:00	MSFT	Stock	30.38	30.48	30.12	30.19	11702140.0
2007-10-11 15:00:00	MSFT	Stock	30.19	30.22	29.79	29.89	13235007.0
2007-10-11 16:00:00	MSFT	Stock	29.91	30.28	29.88	29.89	1863161.0
2007-10-11 17:00:00	MSFT	Stock	29.89	29.93	29.8	29.81	742938.0
2007-10-11 18:00:00	MSFT	Stock	29.839	29.92	29.81	29.9	73732.0
2007-10-11 19:00:00	MSFT	Stock	29.88	29.88	29.87	29.87	750.0
2007-10-11 07:00:00	NVDA	Stock	0.9162	0.9162	0.9125	0.9125	80000.0
2007-10-11 08:00:00	NVDA	Stock	0.9218	0.9218	0.9033	0.9095	635400.0
2007-10-11 09:00:00	NVDA	Stock	0.9108	0.9258	0.897	0.908	85032160.0
2007-10-11 10:00:00	NVDA	Stock	0.9085	0.909	0.8985	0.9027	75461880.0
2007-10-11 11:00:00	NVDA	Stock	0.9025	0.9068	0.8988	0.9058	48818440.0
2007-10-11 12:00:00	NVDA	Stock	0.9058	0.9108	0.9045	0.9098	31995560.0
2007-10-11 13:00:00	NVDA	Stock	0.9094	0.9123	0.902	0.9043	57992920.0
2007-10-11 14:00:00	NVDA	Stock	0.904	0.904	0.887	0.8953	98286360.0
2007-10-11 15:00:00	NVDA	Stock	0.895	0.9062	0.8718	0.8802	115839560.0
2007-10-11 16:00:00	NVDA	Stock	0.8815	0.8984	0.879	0.8818	4394480.0
2007-10-11 17:00:00	NVDA	Stock	0.887	0.887	0.875	0.8782	1559440.0
2007-10-11 18:00:00	NVDA	Stock	0.8776	0.8842	0.8752	0.8778	1232080.0
2007-10-11 19:00:00	NVDA	Stock	0.8778	0.8778	0.8778	0.8778	15000.0
2007-10-11 06:00:00	AMZN	Stock	4.7625	4.7625	4.7625	4.7625	2000.0
2007-10-11 07:00:00	AMZN	Stock	4.763	4.763	4.763	4.763	20000.0
2007-10-11 08:00:00	AMZN	Stock	4.767	4.783	4.766	4.77	379500.0
2007-10-11 09:00:00	AMZN	Stock	4.77	4.779	4.742	4.778	16460540.0
2007-10-11 10:00:00	AMZN	Stock	4.7775	4.787	4.7475	4.758	21749040.0
2007-10-11 11:00:00	AMZN	Stock	4.758	4.779	4.7558	4.7639	11305560.0
2007-10-11 12:00:00	AMZN	Stock	4.763	4.7735	4.75	4.7545	9724900.0
2007-10-11 13:00:00	AMZN	Stock	4.755	4.755	4.6695	4.6765	15917020.0
2007-10-11 14:00:00	AMZN	Stock	4.677	4.677	4.5175	4.5482	46727920.0

> showing 50 of 41,884 rows — these rows as CSV

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