PREVIEW / stock_1hour / 2006-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-05.parquet
  size:    609 KB
  rows:    28,674
  symbols: 2,260

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-05-05 08:00:00	AAPL	Stock	2.5496	2.5643	2.5439	2.5621	1821792.0
2006-05-05 09:00:00	AAPL	Stock	2.56	2.5804	2.5411	2.5668	131621420.0
2006-05-05 10:00:00	AAPL	Stock	2.5671	2.5693	2.5432	2.5618	123224724.0
2006-05-05 11:00:00	AAPL	Stock	2.5614	2.5625	2.5518	2.5536	54682796.0
2006-05-05 12:00:00	AAPL	Stock	2.5539	2.5711	2.5529	2.56	62713420.0
2006-05-05 13:00:00	AAPL	Stock	2.56	2.5679	2.5546	2.5625	44676072.0
2006-05-05 14:00:00	AAPL	Stock	2.5625	2.5746	2.5604	2.5607	65542764.0
2006-05-05 15:00:00	AAPL	Stock	2.5608	2.5679	2.5582	2.5661	64678572.0
2006-05-05 16:00:00	AAPL	Stock	2.5657	2.5679	2.5639	2.5657	3352188.0
2006-05-05 17:00:00	AAPL	Stock	2.5668	2.5682	2.5657	2.5657	1082312.0
2006-05-05 18:00:00	AAPL	Stock	2.5679	2.5696	2.5679	2.5682	53844.0
2006-05-05 07:00:00	MSFT	Stock	23.52	23.52	23.52	23.52	1000.0
2006-05-05 08:00:00	MSFT	Stock	23.52	23.63	23.44	23.6	257170.0
2006-05-05 09:00:00	MSFT	Stock	23.6	23.78	23.52	23.77	15201508.0
2006-05-05 10:00:00	MSFT	Stock	23.76	23.88	23.7	23.76	26976902.0
2006-05-05 11:00:00	MSFT	Stock	23.75	23.89	23.7	23.81	19642776.0
2006-05-05 12:00:00	MSFT	Stock	23.815	23.85	23.75	23.77	11150879.0
2006-05-05 13:00:00	MSFT	Stock	23.77	23.84	23.74	23.79	10996554.0
2006-05-05 14:00:00	MSFT	Stock	23.78	23.84	23.76	23.78	10450048.0
2006-05-05 15:00:00	MSFT	Stock	23.78	23.95	23.74	23.93	26519297.0
2006-05-05 16:00:00	MSFT	Stock	23.94	23.95	23.8	23.87	5138815.0
2006-05-05 17:00:00	MSFT	Stock	23.86	23.93	23.85	23.86	12130.0
2006-05-05 18:00:00	MSFT	Stock	23.86	23.87	23.85	23.85	3636.0
2006-05-05 08:00:00	NVDA	Stock	0.5158	0.5168	0.5122	0.5168	25200.0
2006-05-05 09:00:00	NVDA	Stock	0.5208	0.5232	0.5098	0.5188	50284320.0
2006-05-05 10:00:00	NVDA	Stock	0.519	0.5208	0.514	0.5192	49008420.0
2006-05-05 11:00:00	NVDA	Stock	0.5192	0.5205	0.514	0.5143	40985040.0
2006-05-05 12:00:00	NVDA	Stock	0.5142	0.516	0.5133	0.516	29687580.0
2006-05-05 13:00:00	NVDA	Stock	0.5158	0.5183	0.515	0.518	29348520.0
2006-05-05 14:00:00	NVDA	Stock	0.5178	0.5197	0.5172	0.5188	33295020.0
2006-05-05 15:00:00	NVDA	Stock	0.5187	0.5217	0.518	0.5212	66264480.0
2006-05-05 16:00:00	NVDA	Stock	0.5213	0.5217	0.52	0.521	14884020.0
2006-05-05 17:00:00	NVDA	Stock	0.521	0.5212	0.5197	0.5212	78000.0
2006-05-05 08:00:00	AMZN	Stock	1.734	1.7345	1.729	1.729	10000.0
2006-05-05 09:00:00	AMZN	Stock	1.734	1.7355	1.715	1.72	9697780.0
2006-05-05 10:00:00	AMZN	Stock	1.7205	1.721	1.7075	1.712	11562320.0
2006-05-05 11:00:00	AMZN	Stock	1.712	1.7255	1.708	1.725	13195360.0
2006-05-05 12:00:00	AMZN	Stock	1.725	1.7305	1.7235	1.7235	20507280.0
2006-05-05 13:00:00	AMZN	Stock	1.7235	1.7325	1.717	1.731	15064540.0
2006-05-05 14:00:00	AMZN	Stock	1.7315	1.7425	1.7255	1.739	12531480.0
2006-05-05 15:00:00	AMZN	Stock	1.739	1.752	1.7365	1.752	26195560.0
2006-05-05 16:00:00	AMZN	Stock	1.7515	1.752	1.7495	1.752	1338560.0
2006-05-05 18:00:00	AMZN	Stock	1.75	1.75	1.75	1.75	18000.0
2006-05-05 09:00:00	CL	Stock	29.895	29.95	29.7	29.81	571000.0
2006-05-05 10:00:00	CL	Stock	29.815	29.985	29.78	29.985	504000.0
2006-05-05 11:00:00	CL	Stock	29.985	30.0	29.925	29.95	419000.0
2006-05-05 12:00:00	CL	Stock	29.965	29.995	29.885	29.985	365200.0
2006-05-05 13:00:00	CL	Stock	29.97	30.18	29.95	30.165	827600.0
2006-05-05 14:00:00	CL	Stock	30.16	30.31	30.06	30.295	470600.0
2006-05-05 15:00:00	CL	Stock	30.295	30.295	30.15	30.18	814600.0

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

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