PREVIEW / stock_1hour / 2010-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-06.parquet
  size:    928 KB
  rows:    44,443
  symbols: 3,528

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-12-06 05:00:00	AAPL	Stock	11.3154	11.3154	11.3154	11.3154	2800.0
2010-12-06 06:00:00	AAPL	Stock	11.3332	11.3332	11.3332	11.3332	5600.0
2010-12-06 07:00:00	AAPL	Stock	11.3554	11.3707	11.35	11.35	82964.0
2010-12-06 08:00:00	AAPL	Stock	11.3532	11.3696	11.3232	11.3664	2577008.0
2010-12-06 09:00:00	AAPL	Stock	11.3679	11.4643	11.3614	11.4536	108942596.0
2010-12-06 10:00:00	AAPL	Stock	11.4532	11.5118	11.4404	11.4502	113167124.0
2010-12-06 11:00:00	AAPL	Stock	11.4511	11.4675	11.4111	11.4279	51432584.0
2010-12-06 12:00:00	AAPL	Stock	11.4282	11.4386	11.395	11.42	31799152.0
2010-12-06 13:00:00	AAPL	Stock	11.4196	11.4514	11.4114	11.4375	29359652.0
2010-12-06 14:00:00	AAPL	Stock	11.4375	11.46	11.4161	11.4429	35644112.0
2010-12-06 15:00:00	AAPL	Stock	11.4429	11.4679	11.4214	11.4346	60831848.0
2010-12-06 16:00:00	AAPL	Stock	11.4364	11.4551	11.3393	11.4314	6785604.0
2010-12-06 17:00:00	AAPL	Stock	11.4289	11.4371	11.4193	11.4364	706860.0
2010-12-06 18:00:00	AAPL	Stock	11.4368	11.45	11.4339	11.4418	1762320.0
2010-12-06 19:00:00	AAPL	Stock	11.4429	11.4725	11.4429	11.4432	1426992.0
2010-12-06 04:00:00	MSFT	Stock	26.9	26.9	26.79	26.79	530.0
2010-12-06 05:00:00	MSFT	Stock	26.8	26.8	26.76	26.76	700.0
2010-12-06 06:00:00	MSFT	Stock	26.76	26.8	26.76	26.8	3700.0
2010-12-06 07:00:00	MSFT	Stock	26.9	26.92	26.9	26.92	4125.0
2010-12-06 08:00:00	MSFT	Stock	26.96	26.96	26.9	26.92	7104.0
2010-12-06 09:00:00	MSFT	Stock	26.96	26.98	26.76	26.822	6541054.0
2010-12-06 10:00:00	MSFT	Stock	26.83	26.87	26.79	26.79	6839628.0
2010-12-06 11:00:00	MSFT	Stock	26.791	26.85	26.79	26.825	3841772.0
2010-12-06 12:00:00	MSFT	Stock	26.83	26.85	26.8	26.838	3366159.0
2010-12-06 13:00:00	MSFT	Stock	26.83	26.87	26.82	26.829	2393276.0
2010-12-06 14:00:00	MSFT	Stock	26.83	26.88	26.81	26.85	2587896.0
2010-12-06 15:00:00	MSFT	Stock	26.845	26.88	26.82	26.84	7779896.0
2010-12-06 16:00:00	MSFT	Stock	26.84	26.86	26.83	26.84	2065593.0
2010-12-06 17:00:00	MSFT	Stock	26.82	26.85	26.82	26.83	2991.0
2010-12-06 18:00:00	MSFT	Stock	26.84	26.96	26.83	26.85	17273.0
2010-12-06 19:00:00	MSFT	Stock	26.85	26.88	26.85	26.88	7466.0
2010-12-06 08:00:00	NVDA	Stock	0.37	0.37	0.37	0.37	6000.0
2010-12-06 09:00:00	NVDA	Stock	0.37	0.3718	0.3612	0.3638	103966480.0
2010-12-06 10:00:00	NVDA	Stock	0.3636	0.3672	0.3632	0.3638	75321560.0
2010-12-06 11:00:00	NVDA	Stock	0.3636	0.3648	0.3628	0.3635	49795240.0
2010-12-06 12:00:00	NVDA	Stock	0.3632	0.3644	0.3628	0.3629	43651160.0
2010-12-06 13:00:00	NVDA	Stock	0.363	0.3645	0.3625	0.3645	42889360.0
2010-12-06 14:00:00	NVDA	Stock	0.3642	0.3648	0.363	0.363	51762160.0
2010-12-06 15:00:00	NVDA	Stock	0.363	0.3642	0.3622	0.3625	62558760.0
2010-12-06 16:00:00	NVDA	Stock	0.3628	0.3698	0.3622	0.363	7569320.0
2010-12-06 17:00:00	NVDA	Stock	0.3625	0.3628	0.3625	0.3628	252520.0
2010-12-06 18:00:00	NVDA	Stock	0.3628	0.365	0.3625	0.365	146960.0
2010-12-06 19:00:00	NVDA	Stock	0.365	0.3662	0.365	0.366	60000.0
2010-12-06 04:00:00	AMZN	Stock	8.783	8.783	8.783	8.783	2000.0
2010-12-06 07:00:00	AMZN	Stock	8.805	8.805	8.805	8.805	38000.0
2010-12-06 08:00:00	AMZN	Stock	8.7855	8.7895	8.7625	8.7665	133320.0
2010-12-06 09:00:00	AMZN	Stock	8.7665	8.865	8.766	8.8485	13529080.0
2010-12-06 10:00:00	AMZN	Stock	8.8485	8.856	8.73	8.7705	32067140.0
2010-12-06 11:00:00	AMZN	Stock	8.773	8.802	8.761	8.785	9421120.0
2010-12-06 12:00:00	AMZN	Stock	8.7865	8.813	8.7815	8.8	7162600.0

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

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