PREVIEW / stock_1hour / 2010-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-23.parquet
  size:    919 KB
  rows:    44,644
  symbols: 3,458

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
2010-09-23 04:00:00	AAPL	Stock	10.2411	10.2411	10.2411	10.2411	2800.0
2010-09-23 05:00:00	AAPL	Stock	10.2286	10.2286	10.2286	10.2286	2800.0
2010-09-23 06:00:00	AAPL	Stock	10.2286	10.2286	10.2286	10.2286	2800.0
2010-09-23 07:00:00	AAPL	Stock	10.2321	10.2411	10.2157	10.2289	344260.0
2010-09-23 08:00:00	AAPL	Stock	10.2343	10.2625	10.2232	10.2321	6317612.0
2010-09-23 09:00:00	AAPL	Stock	10.2321	10.3029	10.2143	10.2793	97906060.0
2010-09-23 10:00:00	AAPL	Stock	10.2804	10.4057	10.2782	10.3696	149289476.0
2010-09-23 11:00:00	AAPL	Stock	10.3689	10.4557	10.3636	10.4107	113972404.0
2010-09-23 12:00:00	AAPL	Stock	10.4107	10.4364	10.4039	10.4225	59600072.0
2010-09-23 13:00:00	AAPL	Stock	10.4218	10.4375	10.4164	10.4286	41487628.0
2010-09-23 14:00:00	AAPL	Stock	10.4293	10.4461	10.3304	10.3414	102533732.0
2010-09-23 15:00:00	AAPL	Stock	10.3414	10.3461	10.2571	10.3186	201561136.0
2010-09-23 16:00:00	AAPL	Stock	10.3148	10.4279	10.2222	10.3214	7476924.0
2010-09-23 17:00:00	AAPL	Stock	10.4186	10.4186	10.3179	10.3321	938840.0
2010-09-23 18:00:00	AAPL	Stock	10.3357	10.3375	10.3129	10.3129	459620.0
2010-09-23 19:00:00	AAPL	Stock	10.3132	10.3311	10.3129	10.3225	579488.0
2010-09-23 04:00:00	MSFT	Stock	24.7	24.7	24.7	24.7	200.0
2010-09-23 07:00:00	MSFT	Stock	24.56	24.56	24.56	24.56	200.0
2010-09-23 08:00:00	MSFT	Stock	24.54	24.55	24.45	24.48	93509.0
2010-09-23 09:00:00	MSFT	Stock	24.45	24.55	24.385	24.39	5055011.0
2010-09-23 10:00:00	MSFT	Stock	24.385	24.59	24.38	24.53	7696349.0
2010-09-23 11:00:00	MSFT	Stock	24.538	24.56	24.51	24.522	6154141.0
2010-09-23 12:00:00	MSFT	Stock	24.53	24.55	24.45	24.46	3347758.0
2010-09-23 13:00:00	MSFT	Stock	24.46	24.48	24.4	24.45	4854921.0
2010-09-23 14:00:00	MSFT	Stock	24.45	24.49	24.4	24.42	5201269.0
2010-09-23 15:00:00	MSFT	Stock	24.415	24.45	24.36	24.43	11979245.0
2010-09-23 16:00:00	MSFT	Stock	24.425	24.54	24.38	24.45	1347932.0
2010-09-23 17:00:00	MSFT	Stock	24.41	24.45	24.41	24.44	6524.0
2010-09-23 18:00:00	MSFT	Stock	24.43	24.44	24.4	24.43	31855.0
2010-09-23 19:00:00	MSFT	Stock	24.43	24.45	24.4	24.45	8264.0
2010-09-23 06:00:00	NVDA	Stock	0.2835	0.2875	0.2835	0.2875	400000.0
2010-09-23 07:00:00	NVDA	Stock	0.2875	0.2918	0.2875	0.29	744000.0
2010-09-23 08:00:00	NVDA	Stock	0.2895	0.293	0.2892	0.2915	2388120.0
2010-09-23 09:00:00	NVDA	Stock	0.2922	0.2972	0.2855	0.2938	233573920.0
2010-09-23 10:00:00	NVDA	Stock	0.2938	0.2995	0.2935	0.2975	277844080.0
2010-09-23 11:00:00	NVDA	Stock	0.2978	0.2995	0.297	0.298	139383840.0
2010-09-23 12:00:00	NVDA	Stock	0.2981	0.2985	0.2968	0.2975	105143480.0
2010-09-23 13:00:00	NVDA	Stock	0.2975	0.2978	0.2958	0.2965	75369200.0
2010-09-23 14:00:00	NVDA	Stock	0.2965	0.2972	0.2912	0.2915	161701600.0
2010-09-23 15:00:00	NVDA	Stock	0.2915	0.2922	0.29	0.2905	203568600.0
2010-09-23 16:00:00	NVDA	Stock	0.2905	0.295	0.2892	0.29	13594480.0
2010-09-23 17:00:00	NVDA	Stock	0.29	0.2908	0.2895	0.2905	218400.0
2010-09-23 18:00:00	NVDA	Stock	0.29	0.2908	0.2898	0.2908	274400.0
2010-09-23 19:00:00	NVDA	Stock	0.2895	0.2908	0.2895	0.2908	112600.0
2010-09-23 07:00:00	AMZN	Stock	7.545	7.5475	7.545	7.545	22320.0
2010-09-23 08:00:00	AMZN	Stock	7.545	7.575	7.521	7.533	234580.0
2010-09-23 09:00:00	AMZN	Stock	7.5275	7.6405	7.5275	7.595	14022340.0
2010-09-23 10:00:00	AMZN	Stock	7.599	7.749	7.576	7.717	27869520.0
2010-09-23 11:00:00	AMZN	Stock	7.716	7.796	7.7035	7.7837	20708280.0
2010-09-23 12:00:00	AMZN	Stock	7.7846	7.786	7.753	7.762	9902440.0

> showing 50 of 44,644 rows — these rows as CSV

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