PREVIEW / stock_1hour / 2006-12-26

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-26.parquet
  size:    627 KB
  rows:    30,416
  symbols: 2,461

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-12-26 08:00:00	AAPL	Stock	2.9479	2.9479	2.9304	2.9339	825216.0
2006-12-26 09:00:00	AAPL	Stock	2.9339	2.9489	2.9182	2.9243	73107580.0
2006-12-26 10:00:00	AAPL	Stock	2.9246	2.9329	2.8993	2.9068	93377172.0
2006-12-26 11:00:00	AAPL	Stock	2.9071	2.9171	2.8907	2.8996	79305744.0
2006-12-26 12:00:00	AAPL	Stock	2.8993	2.9257	2.8889	2.9061	73824800.0
2006-12-26 13:00:00	AAPL	Stock	2.9061	2.9264	2.9043	2.9211	50651384.0
2006-12-26 14:00:00	AAPL	Stock	2.9207	2.9229	2.9032	2.9089	46489772.0
2006-12-26 15:00:00	AAPL	Stock	2.9086	2.9179	2.9061	2.9118	66999716.0
2006-12-26 16:00:00	AAPL	Stock	2.9111	2.9193	2.9107	2.9193	1192520.0
2006-12-26 17:00:00	AAPL	Stock	2.915	2.915	2.9089	2.91	631512.0
2006-12-26 18:00:00	AAPL	Stock	2.9104	2.9125	2.9054	2.9075	198996.0
2006-12-26 19:00:00	AAPL	Stock	2.9071	2.9086	2.9054	2.9061	228088.0
2006-12-26 08:00:00	MSFT	Stock	29.51	29.58	29.51	29.58	1900.0
2006-12-26 09:00:00	MSFT	Stock	29.57	29.59	29.4	29.49	3503045.0
2006-12-26 10:00:00	MSFT	Stock	29.5	29.64	29.47	29.64	3793918.0
2006-12-26 11:00:00	MSFT	Stock	29.64	29.78	29.64	29.777	3421139.0
2006-12-26 12:00:00	MSFT	Stock	29.77	30.0	29.66	29.74	2045469.0
2006-12-26 13:00:00	MSFT	Stock	29.75	29.89	29.74	29.88	4523185.0
2006-12-26 14:00:00	MSFT	Stock	29.88	29.95	29.735	29.9	3933995.0
2006-12-26 15:00:00	MSFT	Stock	29.9	30.0	29.89	29.99	10997097.0
2006-12-26 16:00:00	MSFT	Stock	30.0	30.06	29.95	29.96	93705.0
2006-12-26 17:00:00	MSFT	Stock	29.96	29.96	29.95	29.95	5400.0
2006-12-26 18:00:00	MSFT	Stock	29.94	29.95	29.94	29.95	300.0
2006-12-26 19:00:00	MSFT	Stock	29.94	29.96	29.94	29.94	3865.0
2006-12-26 08:00:00	NVDA	Stock	0.6172	0.6172	0.6172	0.6172	24000.0
2006-12-26 09:00:00	NVDA	Stock	0.6172	0.626	0.6172	0.6212	27501660.0
2006-12-26 10:00:00	NVDA	Stock	0.6212	0.6258	0.62	0.6202	45829320.0
2006-12-26 11:00:00	NVDA	Stock	0.6202	0.6233	0.6172	0.6178	35154960.0
2006-12-26 12:00:00	NVDA	Stock	0.6178	0.618	0.6145	0.6158	20449860.0
2006-12-26 13:00:00	NVDA	Stock	0.6158	0.6178	0.6152	0.6172	27797100.0
2006-12-26 14:00:00	NVDA	Stock	0.6172	0.618	0.6162	0.6167	15235260.0
2006-12-26 15:00:00	NVDA	Stock	0.6167	0.6183	0.6163	0.617	41735040.0
2006-12-26 16:00:00	NVDA	Stock	0.617	0.6177	0.616	0.6177	223440.0
2006-12-26 17:00:00	NVDA	Stock	0.6177	0.6177	0.6177	0.6177	18000.0
2006-12-26 18:00:00	NVDA	Stock	0.6178	0.6178	0.6178	0.6178	42000.0
2006-12-26 09:00:00	AMZN	Stock	2.02	2.02	1.982	1.984	14984300.0
2006-12-26 10:00:00	AMZN	Stock	1.984	2.0065	1.971	1.976	16713200.0
2006-12-26 11:00:00	AMZN	Stock	1.976	2.0065	1.973	1.979	12934700.0
2006-12-26 12:00:00	AMZN	Stock	1.979	1.9865	1.9775	1.9845	6212240.0
2006-12-26 13:00:00	AMZN	Stock	1.9845	1.9885	1.982	1.9842	8749660.0
2006-12-26 14:00:00	AMZN	Stock	1.984	1.9865	1.9835	1.9845	9540260.0
2006-12-26 15:00:00	AMZN	Stock	1.9845	1.9935	1.9835	1.9908	18925880.0
2006-12-26 16:00:00	AMZN	Stock	1.9915	1.994	1.9885	1.994	56820.0
2006-12-26 17:00:00	AMZN	Stock	1.99	1.99	1.99	1.99	8000.0
2006-12-26 19:00:00	AMZN	Stock	1.9925	1.9925	1.9925	1.9925	2000.0
2006-12-26 09:00:00	CL	Stock	32.325	32.385	32.27	32.29	131200.0
2006-12-26 10:00:00	CL	Stock	32.285	32.47	32.285	32.47	309600.0
2006-12-26 11:00:00	CL	Stock	32.47	32.53	32.385	32.515	344400.0
2006-12-26 12:00:00	CL	Stock	32.515	32.515	32.425	32.45	194600.0
2006-12-26 13:00:00	CL	Stock	32.45	32.515	32.45	32.505	153800.0

> showing 50 of 30,416 rows — these rows as CSV

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