PREVIEW / stock_1hour / 2007-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-31.parquet
  size:    821 KB
  rows:    40,469
  symbols: 3,180

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
2007-10-31 07:00:00	AAPL	Stock	6.7071	6.7286	6.7071	6.7286	126000.0
2007-10-31 08:00:00	AAPL	Stock	6.7196	6.7268	6.6964	6.7057	4042108.0
2007-10-31 09:00:00	AAPL	Stock	6.7057	6.7489	6.6925	6.7329	78180788.0
2007-10-31 10:00:00	AAPL	Stock	6.7329	6.7486	6.725	6.732	69168260.0
2007-10-31 11:00:00	AAPL	Stock	6.7311	6.7446	6.7254	6.7432	46708452.0
2007-10-31 12:00:00	AAPL	Stock	6.7432	6.7804	6.7357	6.7375	55332648.0
2007-10-31 13:00:00	AAPL	Stock	6.7375	6.7382	6.7182	6.7261	62907292.0
2007-10-31 14:00:00	AAPL	Stock	6.7268	6.79	6.6054	6.7764	280105812.0
2007-10-31 15:00:00	AAPL	Stock	6.7789	6.7857	6.7286	6.7811	194587176.0
2007-10-31 16:00:00	AAPL	Stock	6.7814	6.7889	6.6786	6.78	26610668.0
2007-10-31 17:00:00	AAPL	Stock	6.7825	6.7889	6.7821	6.7875	15421560.0
2007-10-31 18:00:00	AAPL	Stock	6.7341	6.7893	6.7341	6.7821	941108.0
2007-10-31 19:00:00	AAPL	Stock	6.7804	6.7893	6.7804	6.7857	494088.0
2007-10-31 07:00:00	MSFT	Stock	35.6	35.61	35.6	35.61	3732.0
2007-10-31 08:00:00	MSFT	Stock	35.66	35.68	35.56	35.63	39685.0
2007-10-31 09:00:00	MSFT	Stock	35.63	35.96	35.47	35.95	15153730.0
2007-10-31 10:00:00	MSFT	Stock	35.95	36.25	35.7	36.18	27098222.0
2007-10-31 11:00:00	MSFT	Stock	36.18	36.67	36.05	36.57	28072832.0
2007-10-31 12:00:00	MSFT	Stock	36.57	36.64	36.39	36.45	23308206.0
2007-10-31 13:00:00	MSFT	Stock	36.442	36.65	35.7	36.621	17075541.0
2007-10-31 14:00:00	MSFT	Stock	36.62	37.0	36.4	36.97	33586707.0
2007-10-31 15:00:00	MSFT	Stock	36.96	37.0	36.62	36.802	32486191.0
2007-10-31 16:00:00	MSFT	Stock	36.79	36.862	35.57	36.72	8707154.0
2007-10-31 17:00:00	MSFT	Stock	36.72	36.81	36.72	36.79	721911.0
2007-10-31 18:00:00	MSFT	Stock	36.79	36.92	36.17	36.9	49477.0
2007-10-31 19:00:00	MSFT	Stock	36.9	36.92	36.9	36.91	11690.0
2007-10-31 08:00:00	NVDA	Stock	0.8792	0.8925	0.8792	0.89	858800.0
2007-10-31 09:00:00	NVDA	Stock	0.8895	0.892	0.8628	0.8705	46872120.0
2007-10-31 10:00:00	NVDA	Stock	0.8705	0.879	0.8648	0.8676	48330120.0
2007-10-31 11:00:00	NVDA	Stock	0.8675	0.868	0.8625	0.866	38295080.0
2007-10-31 12:00:00	NVDA	Stock	0.866	0.8692	0.859	0.8605	41864240.0
2007-10-31 13:00:00	NVDA	Stock	0.8605	0.8688	0.86	0.8658	34704640.0
2007-10-31 14:00:00	NVDA	Stock	0.8655	0.8825	0.8485	0.8798	89740800.0
2007-10-31 15:00:00	NVDA	Stock	0.8795	0.885	0.8775	0.8845	122223640.0
2007-10-31 16:00:00	NVDA	Stock	0.8845	0.886	0.8646	0.8845	18549720.0
2007-10-31 17:00:00	NVDA	Stock	0.8808	0.8855	0.8792	0.8855	32000.0
2007-10-31 18:00:00	NVDA	Stock	0.886	0.8888	0.8845	0.8888	217200.0
2007-10-31 19:00:00	NVDA	Stock	0.8875	0.8912	0.8875	0.8912	99720.0
2007-10-31 08:00:00	AMZN	Stock	4.42	4.4355	4.4135	4.4235	116500.0
2007-10-31 09:00:00	AMZN	Stock	4.425	4.4325	4.3605	4.38	21533500.0
2007-10-31 10:00:00	AMZN	Stock	4.3795	4.4254	4.3725	4.4025	13622020.0
2007-10-31 11:00:00	AMZN	Stock	4.4015	4.411	4.3895	4.399	8412980.0
2007-10-31 12:00:00	AMZN	Stock	4.3995	4.4345	4.3975	4.423	13243440.0
2007-10-31 13:00:00	AMZN	Stock	4.421	4.4295	4.39	4.404	7845700.0
2007-10-31 14:00:00	AMZN	Stock	4.404	4.48	4.35	4.4625	37571320.0
2007-10-31 15:00:00	AMZN	Stock	4.4585	4.465	4.4	4.458	31296300.0
2007-10-31 16:00:00	AMZN	Stock	4.4575	4.458	4.4077	4.4575	7584400.0
2007-10-31 17:00:00	AMZN	Stock	4.452	4.4525	4.452	4.452	18000.0
2007-10-31 18:00:00	AMZN	Stock	4.452	4.455	4.438	4.45	42340.0
2007-10-31 19:00:00	AMZN	Stock	4.438	4.47	4.4375	4.4375	44040.0

> showing 50 of 40,469 rows — these rows as CSV

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