PREVIEW / stock_1hour / 2007-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-27.parquet
  size:    789 KB
  rows:    39,269
  symbols: 3,105

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-09-27 05:00:00	AAPL	Stock	5.4561	5.4561	5.4561	5.4561	14000.0
2007-09-27 06:00:00	AAPL	Stock	5.4725	5.4725	5.4725	5.4725	2800.0
2007-09-27 07:00:00	AAPL	Stock	5.4789	5.4893	5.4675	5.4889	309708.0
2007-09-27 08:00:00	AAPL	Stock	5.4868	5.4954	5.4696	5.4946	5438412.0
2007-09-27 09:00:00	AAPL	Stock	5.4936	5.4993	5.44	5.4643	115343620.0
2007-09-27 10:00:00	AAPL	Stock	5.4639	5.5171	5.4429	5.5114	149228072.0
2007-09-27 11:00:00	AAPL	Stock	5.5121	5.5175	5.4843	5.4979	108676232.0
2007-09-27 12:00:00	AAPL	Stock	5.4979	5.5079	5.4868	5.4943	43752016.0
2007-09-27 13:00:00	AAPL	Stock	5.4943	5.4975	5.4714	5.4864	62785800.0
2007-09-27 14:00:00	AAPL	Stock	5.4861	5.5046	5.4854	5.4886	56001204.0
2007-09-27 15:00:00	AAPL	Stock	5.4882	5.5186	5.4796	5.5161	103293344.0
2007-09-27 16:00:00	AAPL	Stock	5.5175	5.5268	5.4561	5.5071	11029452.0
2007-09-27 17:00:00	AAPL	Stock	5.5096	5.5121	5.5029	5.5075	388052.0
2007-09-27 18:00:00	AAPL	Stock	5.5075	5.5179	5.4893	5.4893	1142176.0
2007-09-27 19:00:00	AAPL	Stock	5.4925	5.4954	5.4764	5.4925	1079176.0
2007-09-27 07:00:00	MSFT	Stock	29.51	29.55	29.5	29.55	3600.0
2007-09-27 08:00:00	MSFT	Stock	29.58	29.68	29.56	29.67	56582.0
2007-09-27 09:00:00	MSFT	Stock	29.66	29.7	29.51	29.52	4413371.0
2007-09-27 10:00:00	MSFT	Stock	29.53	29.72	29.49	29.68	7588017.0
2007-09-27 11:00:00	MSFT	Stock	29.69	29.72	29.55	29.56	4690551.0
2007-09-27 12:00:00	MSFT	Stock	29.56	29.61	29.54	29.55	4068136.0
2007-09-27 13:00:00	MSFT	Stock	29.55	29.59	29.5	29.51	4529948.0
2007-09-27 14:00:00	MSFT	Stock	29.52	29.58	29.46	29.46	4812358.0
2007-09-27 15:00:00	MSFT	Stock	29.47	29.56	29.44	29.5	9483352.0
2007-09-27 16:00:00	MSFT	Stock	29.49	29.575	29.488	29.49	1396543.0
2007-09-27 17:00:00	MSFT	Stock	29.49	29.59	29.49	29.5	10690.0
2007-09-27 18:00:00	MSFT	Stock	29.49	29.52	29.49	29.5	2458165.0
2007-09-27 19:00:00	MSFT	Stock	29.53	29.53	29.53	29.53	936.0
2007-09-27 08:00:00	NVDA	Stock	0.9168	0.9342	0.9168	0.932	1412640.0
2007-09-27 09:00:00	NVDA	Stock	0.932	0.9335	0.9115	0.9115	61136440.0
2007-09-27 10:00:00	NVDA	Stock	0.9115	0.9225	0.9098	0.9208	56996520.0
2007-09-27 11:00:00	NVDA	Stock	0.9205	0.922	0.9165	0.9205	37288760.0
2007-09-27 12:00:00	NVDA	Stock	0.9205	0.9232	0.919	0.9213	25602320.0
2007-09-27 13:00:00	NVDA	Stock	0.9213	0.9215	0.9133	0.916	49397880.0
2007-09-27 14:00:00	NVDA	Stock	0.916	0.921	0.9125	0.918	38105000.0
2007-09-27 15:00:00	NVDA	Stock	0.9182	0.9218	0.9175	0.92	88559640.0
2007-09-27 16:00:00	NVDA	Stock	0.9195	0.9215	0.9152	0.9195	12721720.0
2007-09-27 17:00:00	NVDA	Stock	0.9202	0.9202	0.9175	0.9175	4141400.0
2007-09-27 18:00:00	NVDA	Stock	0.9195	0.9195	0.9195	0.9195	2836000.0
2007-09-27 19:00:00	NVDA	Stock	0.9152	0.9195	0.9152	0.9195	83000.0
2007-09-27 08:00:00	AMZN	Stock	4.6715	4.699	4.6715	4.695	709640.0
2007-09-27 09:00:00	AMZN	Stock	4.695	4.7055	4.668	4.6805	7706080.0
2007-09-27 10:00:00	AMZN	Stock	4.68	4.7	4.6705	4.695	10566060.0
2007-09-27 11:00:00	AMZN	Stock	4.695	4.695	4.6553	4.665	7296080.0
2007-09-27 12:00:00	AMZN	Stock	4.6654	4.6845	4.665	4.6755	3535460.0
2007-09-27 13:00:00	AMZN	Stock	4.6765	4.6875	4.6755	4.6835	3663480.0
2007-09-27 14:00:00	AMZN	Stock	4.6835	4.693	4.664	4.6745	7358160.0
2007-09-27 15:00:00	AMZN	Stock	4.6745	4.677	4.6565	4.669	12900640.0
2007-09-27 16:00:00	AMZN	Stock	4.669	4.6804	4.662	4.669	2169500.0
2007-09-27 17:00:00	AMZN	Stock	4.6657	4.6675	4.6657	4.6675	416120.0

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

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