PREVIEW / stock_1hour / 2009-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-31.parquet
  size:    881 KB
  rows:    42,149
  symbols: 3,385

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-08-31 07:00:00	AAPL	Stock	6.0536	6.0536	6.0139	6.025	146132.0
2009-08-31 08:00:00	AAPL	Stock	6.0268	6.0268	6.0054	6.0089	760956.0
2009-08-31 09:00:00	AAPL	Stock	6.0057	6.0304	5.975	5.9914	61141920.0
2009-08-31 10:00:00	AAPL	Stock	5.9911	6.0171	5.9825	6.0093	52728116.0
2009-08-31 11:00:00	AAPL	Stock	6.0093	6.0111	5.9829	5.9943	25863292.0
2009-08-31 12:00:00	AAPL	Stock	5.9943	6.0139	5.9879	5.9914	32472412.0
2009-08-31 13:00:00	AAPL	Stock	5.9921	5.996	5.9464	5.9914	24843980.0
2009-08-31 14:00:00	AAPL	Stock	5.9914	6.0096	5.9857	6.0018	23383304.0
2009-08-31 15:00:00	AAPL	Stock	6.0018	6.0125	5.9871	6.0086	56449652.0
2009-08-31 16:00:00	AAPL	Stock	6.0082	6.0114	5.9988	6.0071	29004864.0
2009-08-31 17:00:00	AAPL	Stock	6.0071	6.0075	6.0039	6.0071	232008.0
2009-08-31 18:00:00	AAPL	Stock	6.0064	6.01	6.0064	6.0089	510244.0
2009-08-31 19:00:00	AAPL	Stock	6.0089	6.0118	6.0075	6.0118	98896.0
2009-08-31 05:00:00	MSFT	Stock	24.46	24.46	24.46	24.46	450.0
2009-08-31 06:00:00	MSFT	Stock	24.44	24.44	24.44	24.44	100.0
2009-08-31 07:00:00	MSFT	Stock	24.5	24.58	24.5	24.5	3700.0
2009-08-31 08:00:00	MSFT	Stock	24.5	24.5	24.41	24.42	12023.0
2009-08-31 09:00:00	MSFT	Stock	24.46	24.59	24.29	24.5	7124142.0
2009-08-31 10:00:00	MSFT	Stock	24.5	24.85	24.5	24.84	7798081.0
2009-08-31 11:00:00	MSFT	Stock	24.84	24.85	24.57	24.625	5528058.0
2009-08-31 12:00:00	MSFT	Stock	24.63	24.67	24.57	24.571	3092781.0
2009-08-31 13:00:00	MSFT	Stock	24.58	24.62	24.55	24.6	3243116.0
2009-08-31 14:00:00	MSFT	Stock	24.6	24.63	24.56	24.57	3493288.0
2009-08-31 15:00:00	MSFT	Stock	24.57	24.69	24.46	24.64	10502847.0
2009-08-31 16:00:00	MSFT	Stock	24.64	24.66	24.55	24.658	6889167.0
2009-08-31 17:00:00	MSFT	Stock	24.65	24.65	24.6	24.6	59274.0
2009-08-31 18:00:00	MSFT	Stock	24.65	24.65	24.6	24.61	2428.0
2009-08-31 19:00:00	MSFT	Stock	24.62	24.63	24.62	24.63	4175.0
2009-08-31 08:00:00	NVDA	Stock	0.368	0.3688	0.3612	0.3618	360000.0
2009-08-31 09:00:00	NVDA	Stock	0.362	0.366	0.3582	0.361	87183160.0
2009-08-31 10:00:00	NVDA	Stock	0.3608	0.3624	0.3589	0.361	86843440.0
2009-08-31 11:00:00	NVDA	Stock	0.3612	0.3612	0.3588	0.361	49818840.0
2009-08-31 12:00:00	NVDA	Stock	0.3608	0.3619	0.3595	0.3605	46429240.0
2009-08-31 13:00:00	NVDA	Stock	0.3605	0.3618	0.3595	0.3615	32982840.0
2009-08-31 14:00:00	NVDA	Stock	0.3618	0.363	0.3608	0.3623	26810720.0
2009-08-31 15:00:00	NVDA	Stock	0.3622	0.3635	0.3608	0.3625	75731480.0
2009-08-31 16:00:00	NVDA	Stock	0.3632	0.3652	0.3608	0.363	6403600.0
2009-08-31 17:00:00	NVDA	Stock	0.3628	0.363	0.3628	0.363	27360.0
2009-08-31 05:00:00	AMZN	Stock	4.12	4.12	4.12	4.12	6000.0
2009-08-31 08:00:00	AMZN	Stock	4.12	4.12	4.1015	4.12	48400.0
2009-08-31 09:00:00	AMZN	Stock	4.104	4.112	4.0175	4.035	18873220.0
2009-08-31 10:00:00	AMZN	Stock	4.035	4.068	4.0235	4.0645	15783260.0
2009-08-31 11:00:00	AMZN	Stock	4.064	4.067	4.05	4.0515	7518620.0
2009-08-31 12:00:00	AMZN	Stock	4.0515	4.0575	4.034	4.045	9065220.0
2009-08-31 13:00:00	AMZN	Stock	4.045	4.0535	4.0365	4.0475	6157320.0
2009-08-31 14:00:00	AMZN	Stock	4.0485	4.0645	4.042	4.063	7811080.0
2009-08-31 15:00:00	AMZN	Stock	4.0625	4.063	4.048	4.0595	20653820.0
2009-08-31 16:00:00	AMZN	Stock	4.06	4.0625	4.049	4.0595	13386600.0
2009-08-31 17:00:00	AMZN	Stock	4.0595	4.068	4.0595	4.068	188000.0
2009-08-31 18:00:00	AMZN	Stock	4.0595	4.0595	4.0595	4.0595	107720.0

> showing 50 of 42,149 rows — these rows as CSV

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