PREVIEW / stock_1hour / 2006-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-09.parquet
  size:    600 KB
  rows:    28,711
  symbols: 2,376

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-10-09 07:00:00	AAPL	Stock	2.6411	2.6411	2.6411	2.6411	2800.0
2006-10-09 08:00:00	AAPL	Stock	2.6411	2.6425	2.6375	2.6407	559944.0
2006-10-09 09:00:00	AAPL	Stock	2.6393	2.6457	2.6261	2.6296	62392932.0
2006-10-09 10:00:00	AAPL	Stock	2.6289	2.6436	2.6264	2.6364	66322648.0
2006-10-09 11:00:00	AAPL	Stock	2.6361	2.6618	2.635	2.6482	69831692.0
2006-10-09 12:00:00	AAPL	Stock	2.6489	2.6768	2.6482	2.6696	50765204.0
2006-10-09 13:00:00	AAPL	Stock	2.6693	2.6771	2.6636	2.6657	41690908.0
2006-10-09 14:00:00	AAPL	Stock	2.6661	2.6811	2.6643	2.6786	56532588.0
2006-10-09 15:00:00	AAPL	Stock	2.6786	2.6814	2.6629	2.6629	76145608.0
2006-10-09 16:00:00	AAPL	Stock	2.6629	2.6654	2.6411	2.6643	6114220.0
2006-10-09 17:00:00	AAPL	Stock	2.6643	2.6654	2.6639	2.6643	123844.0
2006-10-09 18:00:00	AAPL	Stock	2.6654	2.6657	2.6654	2.6657	98112.0
2006-10-09 19:00:00	AAPL	Stock	2.6661	2.6661	2.6654	2.6654	11312.0
2006-10-09 06:00:00	MSFT	Stock	27.8	27.8	27.8	27.8	1000.0
2006-10-09 07:00:00	MSFT	Stock	27.79	27.79	27.75	27.75	1500.0
2006-10-09 08:00:00	MSFT	Stock	27.75	27.79	27.7	27.78	9307.0
2006-10-09 09:00:00	MSFT	Stock	27.78	27.93	27.7	27.73	3615741.0
2006-10-09 10:00:00	MSFT	Stock	27.73	27.75	27.62	27.69	4799231.0
2006-10-09 11:00:00	MSFT	Stock	27.69	27.82	27.63	27.76	5765811.0
2006-10-09 12:00:00	MSFT	Stock	27.76	27.78	27.7	27.7	2295389.0
2006-10-09 13:00:00	MSFT	Stock	27.7	27.73	27.62	27.7	4437105.0
2006-10-09 14:00:00	MSFT	Stock	27.7	27.75	27.67	27.72	3094441.0
2006-10-09 15:00:00	MSFT	Stock	27.73	27.9	27.62	27.71	6614342.0
2006-10-09 16:00:00	MSFT	Stock	27.7	27.72	27.65	27.7	1706488.0
2006-10-09 17:00:00	MSFT	Stock	27.69	27.75	27.67	27.75	5400.0
2006-10-09 19:00:00	MSFT	Stock	27.65	27.65	27.65	27.65	500.0
2006-10-09 08:00:00	NVDA	Stock	0.5117	0.5162	0.51	0.5123	492000.0
2006-10-09 09:00:00	NVDA	Stock	0.5142	0.53	0.5128	0.5295	69045780.0
2006-10-09 10:00:00	NVDA	Stock	0.5293	0.5437	0.5277	0.5382	217073280.0
2006-10-09 11:00:00	NVDA	Stock	0.5383	0.5417	0.5333	0.5378	107854620.0
2006-10-09 12:00:00	NVDA	Stock	0.5377	0.5462	0.5377	0.5462	100561680.0
2006-10-09 13:00:00	NVDA	Stock	0.5462	0.5555	0.5445	0.5538	136420020.0
2006-10-09 14:00:00	NVDA	Stock	0.5535	0.554	0.548	0.553	81800340.0
2006-10-09 15:00:00	NVDA	Stock	0.553	0.553	0.5468	0.548	140026620.0
2006-10-09 16:00:00	NVDA	Stock	0.5483	0.5485	0.547	0.547	4527060.0
2006-10-09 17:00:00	NVDA	Stock	0.547	0.5475	0.547	0.547	28800.0
2006-10-09 18:00:00	NVDA	Stock	0.5475	0.5475	0.547	0.5475	61800.0
2006-10-09 19:00:00	NVDA	Stock	0.545	0.5475	0.545	0.5475	72660.0
2006-10-09 08:00:00	AMZN	Stock	1.621	1.621	1.618	1.618	12000.0
2006-10-09 09:00:00	AMZN	Stock	1.625	1.6564	1.6225	1.656	10479860.0
2006-10-09 10:00:00	AMZN	Stock	1.6555	1.6665	1.6485	1.6515	19464340.0
2006-10-09 11:00:00	AMZN	Stock	1.652	1.6625	1.647	1.662	15126220.0
2006-10-09 12:00:00	AMZN	Stock	1.6615	1.671	1.6615	1.6625	8740460.0
2006-10-09 13:00:00	AMZN	Stock	1.6625	1.6715	1.662	1.665	8593460.0
2006-10-09 14:00:00	AMZN	Stock	1.6655	1.674	1.6645	1.671	11063540.0
2006-10-09 15:00:00	AMZN	Stock	1.6705	1.672	1.6615	1.667	24933600.0
2006-10-09 16:00:00	AMZN	Stock	1.6685	1.672	1.6685	1.669	1008860.0
2006-10-09 17:00:00	AMZN	Stock	1.6745	1.6745	1.6745	1.6745	10000.0
2006-10-09 18:00:00	AMZN	Stock	1.675	1.675	1.675	1.675	2000.0
2006-10-09 09:00:00	CL	Stock	31.125	31.185	31.08	31.09	297600.0

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

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