PREVIEW / stock_1hour / 2010-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-29.parquet
  size:    917 KB
  rows:    43,842
  symbols: 3,539

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-29 04:00:00	AAPL	Stock	11.6421	11.6421	11.6421	11.6421	5600.0
2010-12-29 05:00:00	AAPL	Stock	11.6107	11.6107	11.6107	11.6107	2800.0
2010-12-29 07:00:00	AAPL	Stock	11.6425	11.6429	11.6393	11.6393	14000.0
2010-12-29 08:00:00	AAPL	Stock	11.6389	11.6425	11.6296	11.6382	809256.0
2010-12-29 09:00:00	AAPL	Stock	11.6404	11.6589	11.6332	11.6421	26598768.0
2010-12-29 10:00:00	AAPL	Stock	11.6421	11.6536	11.6239	11.6404	28188832.0
2010-12-29 11:00:00	AAPL	Stock	11.6411	11.6439	11.6161	11.6239	23867088.0
2010-12-29 12:00:00	AAPL	Stock	11.6243	11.6429	11.6232	11.6393	11992876.0
2010-12-29 13:00:00	AAPL	Stock	11.6386	11.6429	11.625	11.625	10313744.0
2010-12-29 14:00:00	AAPL	Stock	11.6257	11.6321	11.6175	11.6221	12924800.0
2010-12-29 15:00:00	AAPL	Stock	11.6215	11.6336	11.6107	11.6179	33803168.0
2010-12-29 16:00:00	AAPL	Stock	11.6175	11.6331	11.6118	11.6193	12282452.0
2010-12-29 17:00:00	AAPL	Stock	11.6164	11.6629	11.6164	11.6193	195888.0
2010-12-29 18:00:00	AAPL	Stock	11.6179	11.6193	11.6164	11.6164	60592.0
2010-12-29 19:00:00	AAPL	Stock	11.6179	11.6193	11.6164	11.6193	80220.0
2010-12-29 04:00:00	MSFT	Stock	27.9	27.9	27.9	27.9	400.0
2010-12-29 06:00:00	MSFT	Stock	28.05	28.05	27.91	27.91	800.0
2010-12-29 07:00:00	MSFT	Stock	28.09	28.09	28.09	28.09	400.0
2010-12-29 08:00:00	MSFT	Stock	28.09	28.09	28.04	28.04	5400.0
2010-12-29 09:00:00	MSFT	Stock	28.08	28.09	27.88	28.0	2796091.0
2010-12-29 10:00:00	MSFT	Stock	27.995	28.12	27.99	28.073	2749391.0
2010-12-29 11:00:00	MSFT	Stock	28.072	28.1	28.025	28.03	1599987.0
2010-12-29 12:00:00	MSFT	Stock	28.04	28.08	28.03	28.079	1370357.0
2010-12-29 13:00:00	MSFT	Stock	28.08	28.1	28.06	28.06	1276974.0
2010-12-29 14:00:00	MSFT	Stock	28.07	28.1	28.03	28.095	2652954.0
2010-12-29 15:00:00	MSFT	Stock	28.1	28.1	27.97	27.97	4238747.0
2010-12-29 16:00:00	MSFT	Stock	27.98	28.07	27.93	28.07	1852830.0
2010-12-29 17:00:00	MSFT	Stock	27.967	28.02	27.94	28.02	18685.0
2010-12-29 18:00:00	MSFT	Stock	28.02	28.05	27.97	28.03	5046.0
2010-12-29 19:00:00	MSFT	Stock	28.03	28.03	27.98	28.03	2070.0
2010-12-29 08:00:00	NVDA	Stock	0.3763	0.3763	0.3738	0.3763	42200.0
2010-12-29 09:00:00	NVDA	Stock	0.3735	0.375	0.3708	0.371	22139400.0
2010-12-29 10:00:00	NVDA	Stock	0.371	0.3759	0.37	0.3758	48926560.0
2010-12-29 11:00:00	NVDA	Stock	0.376	0.376	0.3743	0.3748	15163840.0
2010-12-29 12:00:00	NVDA	Stock	0.3748	0.3763	0.3745	0.375	21846880.0
2010-12-29 13:00:00	NVDA	Stock	0.375	0.3755	0.3745	0.375	14019680.0
2010-12-29 14:00:00	NVDA	Stock	0.375	0.3758	0.3744	0.3748	19130280.0
2010-12-29 15:00:00	NVDA	Stock	0.3748	0.375	0.3733	0.3733	29494640.0
2010-12-29 16:00:00	NVDA	Stock	0.3735	0.3742	0.3733	0.3735	6891080.0
2010-12-29 18:00:00	NVDA	Stock	0.3733	0.3733	0.3733	0.3733	11440.0
2010-12-29 08:00:00	AMZN	Stock	9.0905	9.0905	9.0625	9.0625	23200.0
2010-12-29 09:00:00	AMZN	Stock	9.0815	9.091	9.03	9.0325	5624660.0
2010-12-29 10:00:00	AMZN	Stock	9.0345	9.085	9.0205	9.0729	9506040.0
2010-12-29 11:00:00	AMZN	Stock	9.0745	9.085	9.05	9.0785	4674200.0
2010-12-29 12:00:00	AMZN	Stock	9.077	9.136	9.077	9.1345	8009200.0
2010-12-29 13:00:00	AMZN	Stock	9.1345	9.1575	9.1325	9.153	8393440.0
2010-12-29 14:00:00	AMZN	Stock	9.153	9.2175	9.153	9.163	13482360.0
2010-12-29 15:00:00	AMZN	Stock	9.1635	9.192	9.1611	9.1685	10646000.0
2010-12-29 16:00:00	AMZN	Stock	9.175	9.197	9.1268	9.176	416020.0
2010-12-29 18:00:00	AMZN	Stock	9.1685	9.1885	9.1685	9.185	25100.0

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

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