PREVIEW / stock_1hour / 2006-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-26.parquet
  size:    600 KB
  rows:    28,541
  symbols: 2,177

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-26 06:00:00	AAPL	Stock	2.6786	2.6786	2.6786	2.6786	2800.0
2006-01-26 07:00:00	AAPL	Stock	2.6714	2.6768	2.6714	2.6736	44800.0
2006-01-26 08:00:00	AAPL	Stock	2.6786	2.6861	2.6582	2.6629	4454352.0
2006-01-26 09:00:00	AAPL	Stock	2.6629	2.6939	2.6364	2.6504	158186224.0
2006-01-26 10:00:00	AAPL	Stock	2.65	2.6582	2.5689	2.6057	345811928.0
2006-01-26 11:00:00	AAPL	Stock	2.6057	2.625	2.5818	2.6143	159761336.0
2006-01-26 12:00:00	AAPL	Stock	2.6143	2.6214	2.5979	2.6007	92399496.0
2006-01-26 13:00:00	AAPL	Stock	2.6007	2.6071	2.5732	2.5904	88376176.0
2006-01-26 14:00:00	AAPL	Stock	2.5904	2.6161	2.5789	2.61	125392848.0
2006-01-26 15:00:00	AAPL	Stock	2.6093	2.6336	2.5786	2.5821	172756500.0
2006-01-26 16:00:00	AAPL	Stock	2.5836	2.6107	2.5607	2.6086	16306808.0
2006-01-26 17:00:00	AAPL	Stock	2.6104	2.6139	2.595	2.6107	3794308.0
2006-01-26 18:00:00	AAPL	Stock	2.6107	2.625	2.6107	2.6211	1037092.0
2006-01-26 08:00:00	MSFT	Stock	26.5	26.55	26.48	26.5	14941.0
2006-01-26 09:00:00	MSFT	Stock	26.52	26.67	26.5	26.63	5762367.0
2006-01-26 10:00:00	MSFT	Stock	26.63	26.66	26.39	26.6	11213334.0
2006-01-26 11:00:00	MSFT	Stock	26.6	26.72	26.56	26.57	8262699.0
2006-01-26 12:00:00	MSFT	Stock	26.57	26.586	26.42	26.42	8412016.0
2006-01-26 13:00:00	MSFT	Stock	26.43	26.6	26.31	26.44	8183612.0
2006-01-26 14:00:00	MSFT	Stock	26.44	26.55	26.42	26.53	9196043.0
2006-01-26 15:00:00	MSFT	Stock	26.53	26.6	26.43	26.52	11263514.0
2006-01-26 16:00:00	MSFT	Stock	26.5	27.15	26.06	27.09	4695870.0
2006-01-26 17:00:00	MSFT	Stock	27.1	27.17	26.91	26.95	452806.0
2006-01-26 18:00:00	MSFT	Stock	26.95	27.01	26.94	27.01	22520.0
2006-01-26 08:00:00	NVDA	Stock	0.3696	0.3696	0.3696	0.3696	468000.0
2006-01-26 09:00:00	NVDA	Stock	0.3708	0.3728	0.3687	0.3706	42473640.0
2006-01-26 10:00:00	NVDA	Stock	0.3707	0.3767	0.3706	0.3728	79759560.0
2006-01-26 11:00:00	NVDA	Stock	0.3728	0.3765	0.3719	0.3763	68314680.0
2006-01-26 12:00:00	NVDA	Stock	0.3763	0.3782	0.3744	0.3753	59505000.0
2006-01-26 13:00:00	NVDA	Stock	0.3753	0.3765	0.3741	0.3752	37324920.0
2006-01-26 14:00:00	NVDA	Stock	0.3751	0.3786	0.3742	0.3781	52163640.0
2006-01-26 15:00:00	NVDA	Stock	0.3781	0.3786	0.3759	0.3781	82257720.0
2006-01-26 16:00:00	NVDA	Stock	0.3786	0.3799	0.3775	0.3778	4352760.0
2006-01-26 17:00:00	NVDA	Stock	0.3793	0.3833	0.3793	0.3804	636000.0
2006-01-26 18:00:00	NVDA	Stock	0.3833	0.3833	0.3792	0.3792	156000.0
2006-01-26 08:00:00	AMZN	Stock	2.1975	2.2045	2.1975	2.2045	50000.0
2006-01-26 09:00:00	AMZN	Stock	2.202	2.22	2.1905	2.215	9092820.0
2006-01-26 10:00:00	AMZN	Stock	2.215	2.215	2.1895	2.207	19136080.0
2006-01-26 11:00:00	AMZN	Stock	2.2065	2.218	2.1935	2.2155	13304800.0
2006-01-26 12:00:00	AMZN	Stock	2.2155	2.224	2.2105	2.213	9805480.0
2006-01-26 13:00:00	AMZN	Stock	2.2135	2.2235	2.2115	2.223	12893540.0
2006-01-26 14:00:00	AMZN	Stock	2.223	2.2295	2.21	2.221	10982000.0
2006-01-26 15:00:00	AMZN	Stock	2.221	2.239	2.2195	2.234	20536000.0
2006-01-26 16:00:00	AMZN	Stock	2.232	2.2345	2.229	2.234	241760.0
2006-01-26 17:00:00	AMZN	Stock	2.234	2.234	2.231	2.234	28600.0
2006-01-26 18:00:00	AMZN	Stock	2.234	2.24	2.234	2.24	28040.0
2006-01-26 09:00:00	CL	Stock	27.89	27.9	27.595	27.595	643600.0
2006-01-26 10:00:00	CL	Stock	27.575	27.655	27.53	27.565	881000.0
2006-01-26 11:00:00	CL	Stock	27.57	27.58	27.43	27.51	747000.0
2006-01-26 12:00:00	CL	Stock	27.51	27.523	27.195	27.285	1073400.0

> showing 50 of 28,541 rows — these rows as CSV

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