PREVIEW / stock_1hour / 2006-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-18.parquet
  size:    605 KB
  rows:    28,867
  symbols: 2,361

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-09-18 07:00:00	AAPL	Stock	2.6475	2.6475	2.6446	2.6446	5600.0
2006-09-18 08:00:00	AAPL	Stock	2.6432	2.6464	2.625	2.6321	1769908.0
2006-09-18 09:00:00	AAPL	Stock	2.6321	2.6464	2.6264	2.6361	88845092.0
2006-09-18 10:00:00	AAPL	Stock	2.6361	2.6386	2.6179	2.6268	124721352.0
2006-09-18 11:00:00	AAPL	Stock	2.6268	2.6543	2.6218	2.6507	96290404.0
2006-09-18 12:00:00	AAPL	Stock	2.65	2.6614	2.6393	2.6607	81861276.0
2006-09-18 13:00:00	AAPL	Stock	2.6607	2.6736	2.6446	2.6479	103446504.0
2006-09-18 14:00:00	AAPL	Stock	2.6475	2.6507	2.6257	2.6389	103389244.0
2006-09-18 15:00:00	AAPL	Stock	2.6389	2.6493	2.6329	2.6386	93956996.0
2006-09-18 16:00:00	AAPL	Stock	2.6375	2.6407	2.6332	2.6375	1547336.0
2006-09-18 17:00:00	AAPL	Stock	2.6361	2.6382	2.6361	2.6382	74564.0
2006-09-18 18:00:00	AAPL	Stock	2.6389	2.6404	2.6389	2.6404	51016.0
2006-09-18 05:00:00	MSFT	Stock	26.8	26.8	26.8	26.8	500.0
2006-09-18 07:00:00	MSFT	Stock	26.77	26.77	26.77	26.77	1000.0
2006-09-18 08:00:00	MSFT	Stock	26.77	26.8	26.74	26.78	75705.0
2006-09-18 09:00:00	MSFT	Stock	26.76	26.89	26.67	26.86	6334837.0
2006-09-18 10:00:00	MSFT	Stock	26.85	27.04	26.83	26.96	13444708.0
2006-09-18 11:00:00	MSFT	Stock	26.96	26.98	26.83	26.93	7171342.0
2006-09-18 12:00:00	MSFT	Stock	26.94	26.94	26.87	26.912	3773059.0
2006-09-18 13:00:00	MSFT	Stock	26.91	26.92	26.76	26.79	3893305.0
2006-09-18 14:00:00	MSFT	Stock	26.79	26.86	26.73	26.79	4762504.0
2006-09-18 15:00:00	MSFT	Stock	26.79	26.83	26.712	26.8	8407990.0
2006-09-18 16:00:00	MSFT	Stock	26.79	26.84	26.76	26.8	199668.0
2006-09-18 17:00:00	MSFT	Stock	26.82	26.82	26.78	26.78	2587.0
2006-09-18 08:00:00	NVDA	Stock	0.4955	0.4958	0.4947	0.4948	673200.0
2006-09-18 09:00:00	NVDA	Stock	0.4948	0.5	0.4925	0.4987	66706080.0
2006-09-18 10:00:00	NVDA	Stock	0.4987	0.507	0.4973	0.5028	157772040.0
2006-09-18 11:00:00	NVDA	Stock	0.5028	0.5075	0.5008	0.506	81775260.0
2006-09-18 12:00:00	NVDA	Stock	0.5058	0.5085	0.5048	0.5082	66092160.0
2006-09-18 13:00:00	NVDA	Stock	0.5083	0.5113	0.5065	0.509	133566780.0
2006-09-18 14:00:00	NVDA	Stock	0.509	0.5105	0.5075	0.5092	121921260.0
2006-09-18 15:00:00	NVDA	Stock	0.5092	0.5122	0.5088	0.5113	123575700.0
2006-09-18 16:00:00	NVDA	Stock	0.5113	0.5125	0.5092	0.5113	12751740.0
2006-09-18 17:00:00	NVDA	Stock	0.5115	0.5123	0.5115	0.5115	242280.0
2006-09-18 18:00:00	NVDA	Stock	0.5115	0.5115	0.5115	0.5115	15420.0
2006-09-18 09:00:00	AMZN	Stock	1.6215	1.6245	1.6025	1.613	16205840.0
2006-09-18 10:00:00	AMZN	Stock	1.613	1.6195	1.6055	1.609	12450420.0
2006-09-18 11:00:00	AMZN	Stock	1.609	1.6335	1.6055	1.625	17337560.0
2006-09-18 12:00:00	AMZN	Stock	1.625	1.628	1.6185	1.6245	9588060.0
2006-09-18 13:00:00	AMZN	Stock	1.6245	1.628	1.603	1.6045	11233320.0
2006-09-18 14:00:00	AMZN	Stock	1.6045	1.6075	1.594	1.6015	13102060.0
2006-09-18 15:00:00	AMZN	Stock	1.6015	1.605	1.5955	1.603	18865320.0
2006-09-18 16:00:00	AMZN	Stock	1.604	1.6055	1.604	1.605	40120.0
2006-09-18 17:00:00	AMZN	Stock	1.61	1.6125	1.606	1.6125	8000.0
2006-09-18 09:00:00	CL	Stock	31.175	31.175	30.951	31.025	251400.0
2006-09-18 10:00:00	CL	Stock	31.025	31.095	30.91	30.9765	342400.0
2006-09-18 11:00:00	CL	Stock	30.99	31.07	30.95	31.025	275600.0
2006-09-18 12:00:00	CL	Stock	31.015	31.065	30.97	31.025	234600.0
2006-09-18 13:00:00	CL	Stock	31.005	31.03	30.915	30.936	240400.0
2006-09-18 14:00:00	CL	Stock	30.94	30.98	30.885	30.915	274200.0

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

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