PREVIEW / stock_1hour / 2008-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-08.parquet
  size:    796 KB
  rows:    39,609
  symbols: 3,256

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
2008-02-08 06:00:00	AAPL	Stock	4.3464	4.3464	4.3382	4.3382	12600.0
2008-02-08 07:00:00	AAPL	Stock	4.3311	4.3429	4.295	4.3089	425404.0
2008-02-08 08:00:00	AAPL	Stock	4.3157	4.3514	4.3129	4.3446	3736208.0
2008-02-08 09:00:00	AAPL	Stock	4.3464	4.4243	4.3464	4.4211	172143692.0
2008-02-08 10:00:00	AAPL	Stock	4.42	4.4679	4.4061	4.4518	258768664.0
2008-02-08 11:00:00	AAPL	Stock	4.4518	4.4843	4.4332	4.4361	169623944.0
2008-02-08 12:00:00	AAPL	Stock	4.4357	4.4536	4.4146	4.4404	128440452.0
2008-02-08 13:00:00	AAPL	Stock	4.44	4.4404	4.3429	4.3836	191786812.0
2008-02-08 14:00:00	AAPL	Stock	4.3839	4.4275	4.3629	4.3925	156309440.0
2008-02-08 15:00:00	AAPL	Stock	4.3929	4.4893	4.3725	4.4889	252975548.0
2008-02-08 16:00:00	AAPL	Stock	4.4893	4.4893	4.4141	4.475	20207096.0
2008-02-08 17:00:00	AAPL	Stock	4.4782	4.4886	4.4754	4.4868	715624.0
2008-02-08 18:00:00	AAPL	Stock	4.4857	4.4975	4.4857	4.4921	500388.0
2008-02-08 19:00:00	AAPL	Stock	4.4921	4.4982	4.4911	4.4911	335888.0
2008-02-08 06:00:00	MSFT	Stock	28.05	28.1	28.0	28.0	10318.0
2008-02-08 07:00:00	MSFT	Stock	28.0	28.29	28.0	28.17	41996.0
2008-02-08 08:00:00	MSFT	Stock	28.25	28.33	28.1	28.17	339879.0
2008-02-08 09:00:00	MSFT	Stock	28.17	28.78	28.15	28.71	16960444.0
2008-02-08 10:00:00	MSFT	Stock	28.72	29.08	28.69	28.958	31374587.0
2008-02-08 11:00:00	MSFT	Stock	28.96	29.0	28.63	28.64	13780759.0
2008-02-08 12:00:00	MSFT	Stock	28.63	28.997	28.48	28.58	9618876.0
2008-02-08 13:00:00	MSFT	Stock	28.58	28.58	28.31	28.38	14575306.0
2008-02-08 14:00:00	MSFT	Stock	28.38	28.54	28.29	28.29	10921028.0
2008-02-08 15:00:00	MSFT	Stock	28.3	28.62	28.24	28.56	25355712.0
2008-02-08 16:00:00	MSFT	Stock	28.57	28.636	28.435	28.6	2837762.0
2008-02-08 17:00:00	MSFT	Stock	28.6	28.68	28.58	28.66	34020.0
2008-02-08 18:00:00	MSFT	Stock	28.66	28.68	28.64	28.64	9751.0
2008-02-08 19:00:00	MSFT	Stock	28.64	28.65	28.57	28.64	11555.0
2008-02-08 08:00:00	NVDA	Stock	0.61	0.6103	0.6055	0.6055	169120.0
2008-02-08 09:00:00	NVDA	Stock	0.6075	0.6282	0.6	0.6162	52355240.0
2008-02-08 10:00:00	NVDA	Stock	0.6162	0.6255	0.6128	0.6233	60121440.0
2008-02-08 11:00:00	NVDA	Stock	0.6233	0.6295	0.6178	0.618	51020160.0
2008-02-08 12:00:00	NVDA	Stock	0.618	0.6218	0.6118	0.6213	41354560.0
2008-02-08 13:00:00	NVDA	Stock	0.6213	0.6215	0.61	0.616	43926360.0
2008-02-08 14:00:00	NVDA	Stock	0.616	0.6215	0.6133	0.6165	39997440.0
2008-02-08 15:00:00	NVDA	Stock	0.6168	0.625	0.6145	0.6248	92335360.0
2008-02-08 16:00:00	NVDA	Stock	0.6248	0.625	0.6172	0.625	12609080.0
2008-02-08 17:00:00	NVDA	Stock	0.6248	0.625	0.6248	0.625	40000.0
2008-02-08 18:00:00	NVDA	Stock	0.6215	0.6215	0.6213	0.6213	24760.0
2008-02-08 19:00:00	NVDA	Stock	0.6213	0.6213	0.6213	0.6213	44000.0
2008-02-08 08:00:00	AMZN	Stock	3.526	3.694	3.525	3.668	3615660.0
2008-02-08 09:00:00	AMZN	Stock	3.6675	3.6995	3.6335	3.6735	59218640.0
2008-02-08 10:00:00	AMZN	Stock	3.674	3.73	3.6505	3.668	45399760.0
2008-02-08 11:00:00	AMZN	Stock	3.6685	3.7	3.6555	3.673	20808440.0
2008-02-08 12:00:00	AMZN	Stock	3.672	3.6735	3.642	3.662	20823260.0
2008-02-08 13:00:00	AMZN	Stock	3.6615	3.6645	3.626	3.6505	25721000.0
2008-02-08 14:00:00	AMZN	Stock	3.6515	3.663	3.6365	3.6465	17511640.0
2008-02-08 15:00:00	AMZN	Stock	3.6455	3.695	3.6425	3.678	35841300.0
2008-02-08 16:00:00	AMZN	Stock	3.6735	3.68	3.5455	3.67	4637660.0
2008-02-08 17:00:00	AMZN	Stock	3.6745	3.68	3.6725	3.6725	46300.0

> showing 50 of 39,609 rows — these rows as CSV

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