PREVIEW / stock_1hour / 2006-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-17.parquet
  size:    591 KB
  rows:    27,980
  symbols: 2,184

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
2006-01-17 04:00:00	AAPL	Stock	3.0571	3.0571	3.0518	3.0518	58800.0
2006-01-17 05:00:00	AAPL	Stock	3.0446	3.0482	3.0446	3.0482	8400.0
2006-01-17 06:00:00	AAPL	Stock	3.0411	3.0446	3.0411	3.0446	28000.0
2006-01-17 07:00:00	AAPL	Stock	3.0357	3.0482	3.0357	3.0482	245840.0
2006-01-17 08:00:00	AAPL	Stock	3.0454	3.0604	3.0393	3.0489	5420016.0
2006-01-17 09:00:00	AAPL	Stock	3.0482	3.085	3.0461	3.0607	131200020.0
2006-01-17 10:00:00	AAPL	Stock	3.0604	3.0714	3.025	3.0282	161747712.0
2006-01-17 11:00:00	AAPL	Stock	3.0289	3.0393	3.0018	3.0079	133345128.0
2006-01-17 12:00:00	AAPL	Stock	3.0079	3.0211	2.9954	3.0164	98713888.0
2006-01-17 13:00:00	AAPL	Stock	3.0168	3.0196	3.0	3.0146	71083852.0
2006-01-17 14:00:00	AAPL	Stock	3.0146	3.0582	3.0054	3.035	79081828.0
2006-01-17 15:00:00	AAPL	Stock	3.035	3.0625	3.0125	3.0268	120740368.0
2006-01-17 16:00:00	AAPL	Stock	3.0243	3.0314	2.9571	2.9875	9506728.0
2006-01-17 17:00:00	AAPL	Stock	2.9875	3.0254	2.9711	2.9729	15956920.0
2006-01-17 18:00:00	AAPL	Stock	2.9729	2.9768	2.9661	2.9714	1156064.0
2006-01-17 04:00:00	MSFT	Stock	27.2	27.2	27.01	27.01	1284.0
2006-01-17 08:00:00	MSFT	Stock	27.0	27.07	26.95	26.96	28759.0
2006-01-17 09:00:00	MSFT	Stock	26.98	27.04	26.9	26.98	8548168.0
2006-01-17 10:00:00	MSFT	Stock	26.98	27.09	26.96	27.06	8883898.0
2006-01-17 11:00:00	MSFT	Stock	27.06	27.15	27.03	27.08	6237678.0
2006-01-17 12:00:00	MSFT	Stock	27.08	27.19	26.95	27.1	4700965.0
2006-01-17 13:00:00	MSFT	Stock	27.09	27.11	27.02	27.08	6698319.0
2006-01-17 14:00:00	MSFT	Stock	27.08	27.14	27.02	27.1	6814306.0
2006-01-17 15:00:00	MSFT	Stock	27.1	27.12	26.96	27.03	10628682.0
2006-01-17 16:00:00	MSFT	Stock	26.99	27.08	26.51	26.53	1449244.0
2006-01-17 17:00:00	MSFT	Stock	26.54	26.7	26.54	26.6	84896.0
2006-01-17 18:00:00	MSFT	Stock	26.59	26.64	26.59	26.61	7900.0
2006-01-17 08:00:00	NVDA	Stock	0.3501	0.3501	0.3501	0.3501	85560.0
2006-01-17 09:00:00	NVDA	Stock	0.35	0.3537	0.3447	0.3517	79652400.0
2006-01-17 10:00:00	NVDA	Stock	0.3515	0.3521	0.3489	0.3504	59482080.0
2006-01-17 11:00:00	NVDA	Stock	0.3504	0.3525	0.3501	0.3504	30498480.0
2006-01-17 12:00:00	NVDA	Stock	0.3504	0.3513	0.3492	0.3505	27552720.0
2006-01-17 13:00:00	NVDA	Stock	0.3506	0.3507	0.3485	0.3499	30390720.0
2006-01-17 14:00:00	NVDA	Stock	0.3504	0.3525	0.3504	0.3524	26878920.0
2006-01-17 15:00:00	NVDA	Stock	0.3524	0.3542	0.3522	0.3541	44550240.0
2006-01-17 16:00:00	NVDA	Stock	0.3542	0.3542	0.3476	0.3496	1416000.0
2006-01-17 17:00:00	NVDA	Stock	0.3496	0.354	0.3462	0.3467	17245200.0
2006-01-17 18:00:00	NVDA	Stock	0.3475	0.3475	0.3475	0.3475	189000.0
2006-01-17 08:00:00	AMZN	Stock	2.18	2.22	2.18	2.197	28300.0
2006-01-17 09:00:00	AMZN	Stock	2.1995	2.212	2.1935	2.2	14667220.0
2006-01-17 10:00:00	AMZN	Stock	2.1995	2.216	2.1935	2.201	20240360.0
2006-01-17 11:00:00	AMZN	Stock	2.201	2.2045	2.196	2.1975	8854160.0
2006-01-17 12:00:00	AMZN	Stock	2.1975	2.2005	2.188	2.19	7851960.0
2006-01-17 13:00:00	AMZN	Stock	2.19	2.196	2.183	2.1935	8432260.0
2006-01-17 14:00:00	AMZN	Stock	2.1935	2.201	2.1865	2.199	13176180.0
2006-01-17 15:00:00	AMZN	Stock	2.199	2.2025	2.189	2.2	31034180.0
2006-01-17 16:00:00	AMZN	Stock	2.2	2.2005	2.15	2.155	4400160.0
2006-01-17 17:00:00	AMZN	Stock	2.155	2.1655	2.1525	2.155	1243640.0
2006-01-17 18:00:00	AMZN	Stock	2.1525	2.155	2.1525	2.155	84000.0
2006-01-17 09:00:00	CL	Stock	27.36	27.43	27.31	27.38	296600.0

> showing 50 of 27,980 rows — these rows as CSV

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