PREVIEW / stock_1hour / 2009-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-13.parquet
  size:    825 KB
  rows:    40,421
  symbols: 3,339

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
2009-04-13 04:00:00	AAPL	Stock	4.2857	4.2946	4.2857	4.2946	8400.0
2009-04-13 06:00:00	AAPL	Stock	4.2857	4.2857	4.2768	4.2768	5600.0
2009-04-13 07:00:00	AAPL	Stock	4.2679	4.2679	4.25	4.2596	42000.0
2009-04-13 08:00:00	AAPL	Stock	4.2646	4.2857	4.2514	4.2786	655396.0
2009-04-13 09:00:00	AAPL	Stock	4.2821	4.3129	4.25	4.2646	78295784.0
2009-04-13 10:00:00	AAPL	Stock	4.2654	4.3179	4.2629	4.2681	78004080.0
2009-04-13 11:00:00	AAPL	Stock	4.2682	4.3118	4.2596	4.2757	42351456.0
2009-04-13 12:00:00	AAPL	Stock	4.2757	4.3107	4.2736	4.3083	29518552.0
2009-04-13 13:00:00	AAPL	Stock	4.3075	4.3196	4.2971	4.3075	33336240.0
2009-04-13 14:00:00	AAPL	Stock	4.3079	4.3114	4.2879	4.2907	33886440.0
2009-04-13 15:00:00	AAPL	Stock	4.2907	4.3207	4.2857	4.2932	79819824.0
2009-04-13 16:00:00	AAPL	Stock	4.2932	4.3061	4.2861	4.2936	5933396.0
2009-04-13 17:00:00	AAPL	Stock	4.2914	4.3068	4.2871	4.2925	334936.0
2009-04-13 18:00:00	AAPL	Stock	4.2936	4.2964	4.2875	4.2893	270060.0
2009-04-13 19:00:00	AAPL	Stock	4.2886	4.2946	4.2886	4.2911	131600.0
2009-04-13 07:00:00	MSFT	Stock	19.24	19.67	19.24	19.65	3300.0
2009-04-13 08:00:00	MSFT	Stock	19.65	19.86	19.65	19.78	46543.0
2009-04-13 09:00:00	MSFT	Stock	19.78	19.85	19.49	19.5	6851035.0
2009-04-13 10:00:00	MSFT	Stock	19.5	19.85	19.38	19.42	6663463.0
2009-04-13 11:00:00	MSFT	Stock	19.42	19.84	19.37	19.51	5302199.0
2009-04-13 12:00:00	MSFT	Stock	19.5	19.59	19.5	19.58	2856919.0
2009-04-13 13:00:00	MSFT	Stock	19.58	19.67	19.56	19.615	3619645.0
2009-04-13 14:00:00	MSFT	Stock	19.62	19.63	19.51	19.518	3962980.0
2009-04-13 15:00:00	MSFT	Stock	19.51	19.78	19.5	19.59	13071035.0
2009-04-13 16:00:00	MSFT	Stock	19.58	19.7	19.56	19.65	1263991.0
2009-04-13 17:00:00	MSFT	Stock	19.58	19.697	19.51	19.59	242529.0
2009-04-13 18:00:00	MSFT	Stock	19.59	19.59	19.58	19.59	34775.0
2009-04-13 19:00:00	MSFT	Stock	19.6	19.7	19.6	19.67	2900.0
2009-04-13 07:00:00	NVDA	Stock	0.295	0.295	0.295	0.295	8000.0
2009-04-13 08:00:00	NVDA	Stock	0.295	0.2988	0.295	0.298	148000.0
2009-04-13 09:00:00	NVDA	Stock	0.2968	0.2975	0.2895	0.291	100841520.0
2009-04-13 10:00:00	NVDA	Stock	0.291	0.2915	0.2868	0.288	129760360.0
2009-04-13 11:00:00	NVDA	Stock	0.2878	0.293	0.2848	0.2858	106059800.0
2009-04-13 12:00:00	NVDA	Stock	0.2858	0.2888	0.2852	0.2882	68696960.0
2009-04-13 13:00:00	NVDA	Stock	0.288	0.2915	0.2871	0.2913	93333200.0
2009-04-13 14:00:00	NVDA	Stock	0.2915	0.2918	0.2895	0.2905	66020560.0
2009-04-13 15:00:00	NVDA	Stock	0.2906	0.2938	0.2902	0.2912	189534920.0
2009-04-13 16:00:00	NVDA	Stock	0.2912	0.293	0.2898	0.293	12187280.0
2009-04-13 17:00:00	NVDA	Stock	0.2918	0.2922	0.2918	0.2918	31200.0
2009-04-13 18:00:00	NVDA	Stock	0.2895	0.2895	0.2862	0.2862	84000.0
2009-04-13 19:00:00	NVDA	Stock	0.293	0.2932	0.293	0.2932	40800.0
2009-04-13 08:00:00	AMZN	Stock	3.96	3.98	3.96	3.979	158960.0
2009-04-13 09:00:00	AMZN	Stock	3.985	3.9985	3.9555	3.9715	13071900.0
2009-04-13 10:00:00	AMZN	Stock	3.972	3.992	3.92	3.932	20777700.0
2009-04-13 11:00:00	AMZN	Stock	3.932	3.993	3.8925	3.9065	15361220.0
2009-04-13 12:00:00	AMZN	Stock	3.9065	3.9355	3.906	3.9215	11610380.0
2009-04-13 13:00:00	AMZN	Stock	3.923	3.9385	3.899	3.92	12216080.0
2009-04-13 14:00:00	AMZN	Stock	3.922	3.934	3.9095	3.9225	22167600.0
2009-04-13 15:00:00	AMZN	Stock	3.9205	3.982	3.9165	3.947	26083840.0
2009-04-13 16:00:00	AMZN	Stock	3.9472	3.9624	3.9143	3.947	2484460.0

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

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