PREVIEW / stock_1hour / 2008-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-26.parquet
  size:    822 KB
  rows:    40,876
  symbols: 3,334

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
2008-09-26 05:00:00	AAPL	Stock	4.5643	4.5643	4.5429	4.5429	8400.0
2008-09-26 06:00:00	AAPL	Stock	4.5536	4.5554	4.4714	4.5	126308.0
2008-09-26 07:00:00	AAPL	Stock	4.5	4.5	4.4761	4.4943	1001084.0
2008-09-26 08:00:00	AAPL	Stock	4.4825	4.5437	4.4229	4.4275	10135944.0
2008-09-26 09:00:00	AAPL	Stock	4.4321	4.5536	4.3929	4.5064	193463004.0
2008-09-26 10:00:00	AAPL	Stock	4.5061	4.5404	4.4539	4.4836	193455304.0
2008-09-26 11:00:00	AAPL	Stock	4.4843	4.5357	4.4786	4.5216	120666504.0
2008-09-26 12:00:00	AAPL	Stock	4.5218	4.5686	4.4939	4.5543	99639204.0
2008-09-26 13:00:00	AAPL	Stock	4.5549	4.5989	4.5164	4.5232	131826352.0
2008-09-26 14:00:00	AAPL	Stock	4.5225	4.53	4.4446	4.4618	122219160.0
2008-09-26 15:00:00	AAPL	Stock	4.4621	4.6357	4.4389	4.5775	228137728.0
2008-09-26 16:00:00	AAPL	Stock	4.5795	4.6	4.5147	4.5911	15616692.0
2008-09-26 17:00:00	AAPL	Stock	4.5911	4.6	4.58	4.595	645876.0
2008-09-26 18:00:00	AAPL	Stock	4.5954	4.6054	4.5946	4.5975	362096.0
2008-09-26 19:00:00	AAPL	Stock	4.6036	4.6086	4.6	4.6007	427056.0
2008-09-26 04:00:00	MSFT	Stock	26.2	26.2	26.2	26.2	100.0
2008-09-26 06:00:00	MSFT	Stock	26.1	26.1	26.08	26.08	1300.0
2008-09-26 07:00:00	MSFT	Stock	26.08	26.1	25.96	26.1	24800.0
2008-09-26 08:00:00	MSFT	Stock	26.0	26.2	25.88	25.89	239756.0
2008-09-26 09:00:00	MSFT	Stock	25.87	26.87	25.85	26.84	11418410.0
2008-09-26 10:00:00	MSFT	Stock	26.84	27.23	26.84	27.18	15206516.0
2008-09-26 11:00:00	MSFT	Stock	27.182	27.24	26.98	27.0	14705526.0
2008-09-26 12:00:00	MSFT	Stock	27.0	27.1	26.95	27.06	10324018.0
2008-09-26 13:00:00	MSFT	Stock	27.06	27.24	27.03	27.112	10066256.0
2008-09-26 14:00:00	MSFT	Stock	27.115	27.21	27.04	27.08	9952512.0
2008-09-26 15:00:00	MSFT	Stock	27.095	27.56	27.02	27.4	23962656.0
2008-09-26 16:00:00	MSFT	Stock	27.45	27.61	26.928	27.42	3476859.0
2008-09-26 17:00:00	MSFT	Stock	27.42	27.5	27.4	27.45	100982.0
2008-09-26 18:00:00	MSFT	Stock	27.42	27.45	27.41	27.41	12106.0
2008-09-26 19:00:00	MSFT	Stock	27.5	27.5	27.4	27.4	3330.0
2008-09-26 08:00:00	NVDA	Stock	0.2838	0.2838	0.273	0.273	256760.0
2008-09-26 09:00:00	NVDA	Stock	0.2732	0.2815	0.2732	0.278	91576320.0
2008-09-26 10:00:00	NVDA	Stock	0.278	0.2832	0.2748	0.2798	89678440.0
2008-09-26 11:00:00	NVDA	Stock	0.2798	0.2902	0.279	0.289	138643280.0
2008-09-26 12:00:00	NVDA	Stock	0.289	0.2898	0.2858	0.288	49426600.0
2008-09-26 13:00:00	NVDA	Stock	0.2882	0.2912	0.2875	0.289	43835960.0
2008-09-26 14:00:00	NVDA	Stock	0.2891	0.2942	0.2885	0.29	95557000.0
2008-09-26 15:00:00	NVDA	Stock	0.2898	0.2938	0.2872	0.293	122939400.0
2008-09-26 16:00:00	NVDA	Stock	0.2922	0.2942	0.2859	0.293	7044560.0
2008-09-26 17:00:00	NVDA	Stock	0.293	0.293	0.2912	0.2912	370760.0
2008-09-26 19:00:00	NVDA	Stock	0.2925	0.2925	0.2925	0.2925	4000.0
2008-09-26 08:00:00	AMZN	Stock	3.525	3.525	3.45	3.45	89700.0
2008-09-26 09:00:00	AMZN	Stock	3.455	3.5075	3.438	3.485	20540180.0
2008-09-26 10:00:00	AMZN	Stock	3.4855	3.496	3.404	3.488	27576500.0
2008-09-26 11:00:00	AMZN	Stock	3.4875	3.4975	3.451	3.468	11490500.0
2008-09-26 12:00:00	AMZN	Stock	3.468	3.5145	3.4585	3.4989	9611040.0
2008-09-26 13:00:00	AMZN	Stock	3.5	3.5525	3.4965	3.5135	10705600.0
2008-09-26 14:00:00	AMZN	Stock	3.513	3.5225	3.48	3.4835	12645640.0
2008-09-26 15:00:00	AMZN	Stock	3.4825	3.545	3.45	3.537	37864960.0
2008-09-26 16:00:00	AMZN	Stock	3.54	3.544	3.4846	3.544	694240.0

> showing 50 of 40,876 rows — these rows as CSV

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