PREVIEW / stock_1hour / 2005-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-22.parquet
  size:    579 KB
  rows:    27,303
  symbols: 2,028

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
2005-07-22 08:00:00	AAPL	Stock	1.5454	1.5536	1.5425	1.5536	219800.0
2005-07-22 09:00:00	AAPL	Stock	1.5536	1.565	1.5496	1.5639	45621128.0
2005-07-22 10:00:00	AAPL	Stock	1.5636	1.5714	1.5571	1.5621	70527996.0
2005-07-22 11:00:00	AAPL	Stock	1.5621	1.5657	1.5592	1.5646	32445672.0
2005-07-22 12:00:00	AAPL	Stock	1.5643	1.5679	1.5553	1.5589	29902124.0
2005-07-22 13:00:00	AAPL	Stock	1.5596	1.5639	1.5589	1.5618	14460824.0
2005-07-22 14:00:00	AAPL	Stock	1.5618	1.5711	1.56	1.5679	42274092.0
2005-07-22 15:00:00	AAPL	Stock	1.5675	1.5714	1.5674	1.57	55702192.0
2005-07-22 16:00:00	AAPL	Stock	1.5714	1.5746	1.5696	1.5714	3484516.0
2005-07-22 17:00:00	AAPL	Stock	1.57	1.5732	1.5686	1.5704	597240.0
2005-07-22 18:00:00	AAPL	Stock	1.5714	1.5714	1.5714	1.5714	3500.0
2005-07-22 07:00:00	MSFT	Stock	25.99	25.99	25.87	25.87	7441.0
2005-07-22 08:00:00	MSFT	Stock	25.85	26.15	25.82	26.12	851334.0
2005-07-22 09:00:00	MSFT	Stock	26.13	26.34	25.92	26.02	17940581.0
2005-07-22 10:00:00	MSFT	Stock	26.02	26.02	25.78	25.79	20210538.0
2005-07-22 11:00:00	MSFT	Stock	25.8	25.81	25.73	25.8	11355242.0
2005-07-22 12:00:00	MSFT	Stock	25.8	26.0	25.7	25.72	8748912.0
2005-07-22 13:00:00	MSFT	Stock	25.721	26.12	25.72	25.78	7167450.0
2005-07-22 14:00:00	MSFT	Stock	25.78	25.8	25.64	25.78	11557180.0
2005-07-22 15:00:00	MSFT	Stock	25.79	25.865	25.63	25.64	12434373.0
2005-07-22 16:00:00	MSFT	Stock	25.63	26.06	25.62	25.64	1528362.0
2005-07-22 17:00:00	MSFT	Stock	25.68	25.7	25.64	25.67	2316912.0
2005-07-22 18:00:00	MSFT	Stock	25.67	25.67	25.65	25.67	12275.0
2005-07-22 08:00:00	NVDA	Stock	0.2237	0.2237	0.2237	0.2237	24000.0
2005-07-22 09:00:00	NVDA	Stock	0.2217	0.2252	0.2183	0.2185	79019640.0
2005-07-22 10:00:00	NVDA	Stock	0.2185	0.219	0.2152	0.2166	135748320.0
2005-07-22 11:00:00	NVDA	Stock	0.2166	0.2184	0.2158	0.2162	80874240.0
2005-07-22 12:00:00	NVDA	Stock	0.2162	0.2167	0.2141	0.2146	78938760.0
2005-07-22 13:00:00	NVDA	Stock	0.2147	0.216	0.2137	0.2142	83328120.0
2005-07-22 14:00:00	NVDA	Stock	0.2142	0.2162	0.2137	0.2153	94554360.0
2005-07-22 15:00:00	NVDA	Stock	0.2154	0.2157	0.2142	0.2152	123072480.0
2005-07-22 16:00:00	NVDA	Stock	0.2152	0.2152	0.2148	0.2152	7744560.0
2005-07-22 17:00:00	NVDA	Stock	0.2151	0.2152	0.2151	0.2152	2352000.0
2005-07-22 18:00:00	NVDA	Stock	0.2146	0.2146	0.2146	0.2146	12000.0
2005-07-22 08:00:00	AMZN	Stock	1.8875	1.895	1.881	1.881	26000.0
2005-07-22 09:00:00	AMZN	Stock	1.89	1.9115	1.881	1.885	14763520.0
2005-07-22 10:00:00	AMZN	Stock	1.8845	1.888	1.862	1.8735	33917580.0
2005-07-22 11:00:00	AMZN	Stock	1.8735	1.8835	1.8725	1.883	15472200.0
2005-07-22 12:00:00	AMZN	Stock	1.883	1.8896	1.8785	1.888	9908700.0
2005-07-22 13:00:00	AMZN	Stock	1.888	1.8975	1.8775	1.897	9766240.0
2005-07-22 14:00:00	AMZN	Stock	1.897	1.8985	1.885	1.8965	15072880.0
2005-07-22 15:00:00	AMZN	Stock	1.896	1.899	1.894	1.8975	16097480.0
2005-07-22 16:00:00	AMZN	Stock	1.8975	1.8985	1.8965	1.8975	969680.0
2005-07-22 09:00:00	CL	Stock	25.935	25.935	25.65	25.75	371200.0
2005-07-22 10:00:00	CL	Stock	25.75	25.82	25.685	25.8	550800.0
2005-07-22 11:00:00	CL	Stock	25.8	25.805	25.715	25.785	566000.0
2005-07-22 12:00:00	CL	Stock	25.79	25.87	25.765	25.795	290200.0
2005-07-22 13:00:00	CL	Stock	25.795	25.88	25.795	25.865	326200.0
2005-07-22 14:00:00	CL	Stock	25.875	25.985	25.84	25.975	537200.0
2005-07-22 15:00:00	CL	Stock	25.975	26.01	25.94	25.985	770400.0

> showing 50 of 27,303 rows — these rows as CSV

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