PREVIEW / stock_1hour / 2010-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-29.parquet
  size:    904 KB
  rows:    43,180
  symbols: 3,471

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-03-29 04:00:00	AAPL	Stock	8.3179	8.3304	8.2964	8.3304	48104.0
2010-03-29 05:00:00	AAPL	Stock	8.3343	8.375	8.3343	8.3536	345912.0
2010-03-29 06:00:00	AAPL	Stock	8.3571	8.3571	8.3525	8.3571	31500.0
2010-03-29 07:00:00	AAPL	Stock	8.3571	8.375	8.3325	8.3386	965496.0
2010-03-29 08:00:00	AAPL	Stock	8.3589	8.3696	8.3214	8.3357	2856280.0
2010-03-29 09:00:00	AAPL	Stock	8.3361	8.3525	8.3129	8.3343	75135032.0
2010-03-29 10:00:00	AAPL	Stock	8.3343	8.345	8.2954	8.3282	89251036.0
2010-03-29 11:00:00	AAPL	Stock	8.3279	8.3393	8.3136	8.3279	34290116.0
2010-03-29 12:00:00	AAPL	Stock	8.3279	8.3289	8.3039	8.3118	28262696.0
2010-03-29 13:00:00	AAPL	Stock	8.31	8.3248	8.2857	8.2996	47388404.0
2010-03-29 14:00:00	AAPL	Stock	8.2994	8.2996	8.2721	8.2914	47432420.0
2010-03-29 15:00:00	AAPL	Stock	8.2925	8.305	8.2825	8.3018	55790280.0
2010-03-29 16:00:00	AAPL	Stock	8.2996	8.3287	8.2464	8.2964	9127692.0
2010-03-29 17:00:00	AAPL	Stock	8.2964	8.5286	8.2961	8.5107	12995752.0
2010-03-29 18:00:00	AAPL	Stock	8.5107	8.5254	8.2996	8.4743	5351332.0
2010-03-29 19:00:00	AAPL	Stock	8.4736	8.4857	8.4732	8.4821	2424548.0
2010-03-29 20:00:00	AAPL	Stock	8.3293	8.3293	8.3293	8.3293	75600.0
2010-03-29 04:00:00	MSFT	Stock	29.81	29.81	29.81	29.81	100.0
2010-03-29 07:00:00	MSFT	Stock	29.81	29.81	29.81	29.81	500.0
2010-03-29 08:00:00	MSFT	Stock	29.77	29.8	29.72	29.78	20990.0
2010-03-29 09:00:00	MSFT	Stock	29.77	29.82	29.6	29.616	4157302.0
2010-03-29 10:00:00	MSFT	Stock	29.62	29.72	29.6	29.695	5926472.0
2010-03-29 11:00:00	MSFT	Stock	29.692	29.72	29.66	29.7	3476170.0
2010-03-29 12:00:00	MSFT	Stock	29.7	29.72	29.64	29.65	2924866.0
2010-03-29 13:00:00	MSFT	Stock	29.658	29.7	29.625	29.649	3008641.0
2010-03-29 14:00:00	MSFT	Stock	29.64	29.69	29.63	29.68	3382976.0
2010-03-29 15:00:00	MSFT	Stock	29.675	29.682	29.55	29.6	7209987.0
2010-03-29 16:00:00	MSFT	Stock	29.59	29.661	29.56	29.59	2316859.0
2010-03-29 17:00:00	MSFT	Stock	29.57	29.61	29.55	29.61	5682.0
2010-03-29 18:00:00	MSFT	Stock	29.57	29.6	29.55	29.6	3475.0
2010-03-29 19:00:00	MSFT	Stock	29.6	29.61	29.6	29.61	3246.0
2010-03-29 08:00:00	NVDA	Stock	0.4395	0.4395	0.4395	0.4395	4000.0
2010-03-29 09:00:00	NVDA	Stock	0.436	0.44	0.4302	0.4325	61521000.0
2010-03-29 10:00:00	NVDA	Stock	0.4322	0.435	0.4322	0.4345	77652680.0
2010-03-29 11:00:00	NVDA	Stock	0.4345	0.438	0.4338	0.4373	44579080.0
2010-03-29 12:00:00	NVDA	Stock	0.4375	0.438	0.436	0.4375	42303080.0
2010-03-29 13:00:00	NVDA	Stock	0.4378	0.4388	0.4365	0.4372	45328960.0
2010-03-29 14:00:00	NVDA	Stock	0.437	0.4385	0.4355	0.4385	46882640.0
2010-03-29 15:00:00	NVDA	Stock	0.4385	0.4392	0.4378	0.439	58197200.0
2010-03-29 16:00:00	NVDA	Stock	0.439	0.4395	0.4362	0.439	16238240.0
2010-03-29 17:00:00	NVDA	Stock	0.4388	0.4388	0.4388	0.4388	20880.0
2010-03-29 18:00:00	NVDA	Stock	0.44	0.44	0.44	0.44	9480.0
2010-03-29 20:00:00	NVDA	Stock	0.437	0.437	0.437	0.437	80000.0
2010-03-29 04:00:00	AMZN	Stock	6.753	6.753	6.753	6.753	8000.0
2010-03-29 07:00:00	AMZN	Stock	6.775	6.775	6.775	6.775	4000.0
2010-03-29 08:00:00	AMZN	Stock	6.778	6.8	6.778	6.7975	41360.0
2010-03-29 09:00:00	AMZN	Stock	6.7945	6.8315	6.76	6.788	16850260.0
2010-03-29 10:00:00	AMZN	Stock	6.7885	6.8075	6.722	6.749	22476380.0
2010-03-29 11:00:00	AMZN	Stock	6.7485	6.7866	6.7385	6.7715	11067380.0
2010-03-29 12:00:00	AMZN	Stock	6.772	6.8035	6.725	6.7325	10435820.0

> showing 50 of 43,180 rows — these rows as CSV

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