PREVIEW / stock_1hour / 2009-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-21.parquet
  size:    899 KB
  rows:    42,835
  symbols: 3,457

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-12-21 05:00:00	AAPL	Stock	6.9857	6.9857	6.9857	6.9857	5600.0
2009-12-21 07:00:00	AAPL	Stock	6.9911	7.0243	6.9911	7.0186	400092.0
2009-12-21 08:00:00	AAPL	Stock	7.0129	7.0186	6.9779	7.0	3495716.0
2009-12-21 09:00:00	AAPL	Stock	7.0	7.0604	6.9882	7.0582	66473820.0
2009-12-21 10:00:00	AAPL	Stock	7.0596	7.1339	7.0579	7.1032	110660928.0
2009-12-21 11:00:00	AAPL	Stock	7.1021	7.1304	7.0943	7.0996	44408392.0
2009-12-21 12:00:00	AAPL	Stock	7.0993	7.1211	7.0714	7.0857	41299720.0
2009-12-21 13:00:00	AAPL	Stock	7.0864	7.0921	7.0671	7.0871	32975320.0
2009-12-21 14:00:00	AAPL	Stock	7.0864	7.1064	7.0779	7.1017	30591008.0
2009-12-21 15:00:00	AAPL	Stock	7.1024	7.1024	7.0657	7.0796	60207392.0
2009-12-21 16:00:00	AAPL	Stock	7.0782	7.0826	6.9796	7.0796	5590060.0
2009-12-21 17:00:00	AAPL	Stock	7.0793	7.0857	7.0789	7.083	510804.0
2009-12-21 18:00:00	AAPL	Stock	7.0834	7.0854	6.9817	7.0854	3062808.0
2009-12-21 19:00:00	AAPL	Stock	7.0854	7.087	7.0654	7.0836	383432.0
2009-12-21 07:00:00	MSFT	Stock	30.4	30.4	30.4	30.4	200.0
2009-12-21 08:00:00	MSFT	Stock	30.5	30.5	30.36	30.37	38350.0
2009-12-21 09:00:00	MSFT	Stock	30.37	30.52	30.36	30.46	6246641.0
2009-12-21 10:00:00	MSFT	Stock	30.47	30.56	30.44	30.47	6733775.0
2009-12-21 11:00:00	MSFT	Stock	30.48	30.74	30.47	30.74	6917893.0
2009-12-21 12:00:00	MSFT	Stock	30.74	30.84	30.64	30.71	5528198.0
2009-12-21 13:00:00	MSFT	Stock	30.715	30.72	30.5	30.57	2938794.0
2009-12-21 14:00:00	MSFT	Stock	30.58	30.63	30.53	30.601	2994892.0
2009-12-21 15:00:00	MSFT	Stock	30.605	30.61	30.48	30.56	5353187.0
2009-12-21 16:00:00	MSFT	Stock	30.56	30.58	30.36	30.577	2005625.0
2009-12-21 17:00:00	MSFT	Stock	30.47	30.51	30.47	30.51	24400.0
2009-12-21 18:00:00	MSFT	Stock	30.252	30.52	30.252	30.47	223340.0
2009-12-21 19:00:00	MSFT	Stock	30.52	30.52	30.48	30.51	3700.0
2009-12-21 07:00:00	NVDA	Stock	0.426	0.426	0.426	0.426	40000.0
2009-12-21 08:00:00	NVDA	Stock	0.425	0.426	0.4238	0.4238	318400.0
2009-12-21 09:00:00	NVDA	Stock	0.425	0.4275	0.4218	0.427	47774400.0
2009-12-21 10:00:00	NVDA	Stock	0.427	0.435	0.427	0.4343	92640240.0
2009-12-21 11:00:00	NVDA	Stock	0.4342	0.4352	0.4335	0.4348	50041960.0
2009-12-21 12:00:00	NVDA	Stock	0.435	0.4372	0.4342	0.4358	45332400.0
2009-12-21 13:00:00	NVDA	Stock	0.4358	0.436	0.434	0.4354	41232760.0
2009-12-21 14:00:00	NVDA	Stock	0.4355	0.4362	0.4345	0.4352	45179160.0
2009-12-21 15:00:00	NVDA	Stock	0.4352	0.4358	0.4332	0.4358	84168000.0
2009-12-21 16:00:00	NVDA	Stock	0.4355	0.4362	0.4205	0.435	19608280.0
2009-12-21 18:00:00	NVDA	Stock	0.4355	0.4355	0.4355	0.4355	12000.0
2009-12-21 19:00:00	NVDA	Stock	0.4355	0.4355	0.4355	0.4355	24000.0
2009-12-21 04:00:00	AMZN	Stock	6.3	6.46	6.3	6.46	38000.0
2009-12-21 05:00:00	AMZN	Stock	6.475	6.475	6.475	6.475	3000.0
2009-12-21 06:00:00	AMZN	Stock	6.475	6.4905	6.475	6.4875	21200.0
2009-12-21 07:00:00	AMZN	Stock	6.5	6.5	6.476	6.49	279860.0
2009-12-21 08:00:00	AMZN	Stock	6.499	6.5	6.4855	6.495	702140.0
2009-12-21 09:00:00	AMZN	Stock	6.495	6.595	6.418	6.5713	38128440.0
2009-12-21 10:00:00	AMZN	Stock	6.5718	6.6575	6.5625	6.635	49959960.0
2009-12-21 11:00:00	AMZN	Stock	6.6345	6.65	6.616	6.621	13089800.0
2009-12-21 12:00:00	AMZN	Stock	6.622	6.644	6.6105	6.615	10946680.0
2009-12-21 13:00:00	AMZN	Stock	6.615	6.642	6.6	6.6355	12816460.0
2009-12-21 14:00:00	AMZN	Stock	6.6355	6.66	6.627	6.6525	13899160.0

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

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