PREVIEW / stock_1hour / 2007-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-25.parquet
  size:    786 KB
  rows:    38,939
  symbols: 3,123

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-09-25 06:00:00	AAPL	Stock	5.2625	5.2625	5.25	5.2504	92400.0
2007-09-25 07:00:00	AAPL	Stock	5.2504	5.2504	5.2286	5.2479	523068.0
2007-09-25 08:00:00	AAPL	Stock	5.2464	5.2668	5.2379	5.2557	4844392.0
2007-09-25 09:00:00	AAPL	Stock	5.2557	5.3007	5.2371	5.2946	129682952.0
2007-09-25 10:00:00	AAPL	Stock	5.2946	5.365	5.2811	5.3372	234781372.0
2007-09-25 11:00:00	AAPL	Stock	5.3375	5.3536	5.3229	5.335	96057556.0
2007-09-25 12:00:00	AAPL	Stock	5.3354	5.3439	5.3161	5.3379	72699620.0
2007-09-25 13:00:00	AAPL	Stock	5.3375	5.3975	5.2964	5.3925	156794568.0
2007-09-25 14:00:00	AAPL	Stock	5.3921	5.4286	5.3696	5.4264	222828788.0
2007-09-25 15:00:00	AAPL	Stock	5.4268	5.4721	5.4032	5.4721	246604456.0
2007-09-25 16:00:00	AAPL	Stock	5.4704	5.4904	5.3271	5.4857	22403556.0
2007-09-25 17:00:00	AAPL	Stock	5.4857	5.4893	5.4707	5.4807	2272116.0
2007-09-25 18:00:00	AAPL	Stock	5.4804	5.4879	5.4707	5.4875	2479400.0
2007-09-25 19:00:00	AAPL	Stock	5.4864	5.4911	5.4825	5.4857	497000.0
2007-09-25 07:00:00	MSFT	Stock	29.13	29.13	29.08	29.08	544.0
2007-09-25 08:00:00	MSFT	Stock	29.11	29.24	29.11	29.17	144426.0
2007-09-25 09:00:00	MSFT	Stock	29.16	29.48	29.08	29.4	8528844.0
2007-09-25 10:00:00	MSFT	Stock	29.4	29.52	29.33	29.44	13843720.0
2007-09-25 11:00:00	MSFT	Stock	29.43	29.5	29.33	29.398	11007813.0
2007-09-25 12:00:00	MSFT	Stock	29.398	29.42	29.34	29.39	5290083.0
2007-09-25 13:00:00	MSFT	Stock	29.39	29.45	29.36	29.43	4274896.0
2007-09-25 14:00:00	MSFT	Stock	29.43	29.55	29.41	29.52	7467446.0
2007-09-25 15:00:00	MSFT	Stock	29.52	29.56	29.4	29.55	19189161.0
2007-09-25 16:00:00	MSFT	Stock	29.55	29.56	29.427	29.52	5717763.0
2007-09-25 17:00:00	MSFT	Stock	29.5	29.56	28.941	29.53	40184.0
2007-09-25 18:00:00	MSFT	Stock	29.55	29.59	29.55	29.57	104612.0
2007-09-25 19:00:00	MSFT	Stock	29.58	29.59	29.58	29.59	11450.0
2007-09-25 08:00:00	NVDA	Stock	0.8688	0.88	0.8632	0.88	111720.0
2007-09-25 09:00:00	NVDA	Stock	0.88	0.8975	0.875	0.8968	49164120.0
2007-09-25 10:00:00	NVDA	Stock	0.8968	0.8968	0.8873	0.8888	51981280.0
2007-09-25 11:00:00	NVDA	Stock	0.889	0.8935	0.885	0.8885	44174320.0
2007-09-25 12:00:00	NVDA	Stock	0.8888	0.8912	0.886	0.8908	32951960.0
2007-09-25 13:00:00	NVDA	Stock	0.8905	0.896	0.89	0.8942	38691240.0
2007-09-25 14:00:00	NVDA	Stock	0.894	0.8968	0.89	0.8963	46236320.0
2007-09-25 15:00:00	NVDA	Stock	0.8965	0.8992	0.8905	0.896	84103960.0
2007-09-25 16:00:00	NVDA	Stock	0.8963	0.898	0.8921	0.8929	7223600.0
2007-09-25 17:00:00	NVDA	Stock	0.8963	0.8988	0.8963	0.8988	310400.0
2007-09-25 18:00:00	NVDA	Stock	0.8988	0.8988	0.8988	0.8988	52000.0
2007-09-25 19:00:00	NVDA	Stock	0.8963	0.8963	0.8928	0.8928	29600.0
2007-09-25 05:00:00	AMZN	Stock	4.625	4.65	4.625	4.65	6000.0
2007-09-25 06:00:00	AMZN	Stock	4.6375	4.6375	4.6375	4.6375	2000.0
2007-09-25 07:00:00	AMZN	Stock	4.62	4.62	4.62	4.62	30000.0
2007-09-25 08:00:00	AMZN	Stock	4.594	4.6295	4.5745	4.575	833220.0
2007-09-25 09:00:00	AMZN	Stock	4.5775	4.6005	4.5475	4.5715	18444940.0
2007-09-25 10:00:00	AMZN	Stock	4.57	4.5995	4.5555	4.5805	17452240.0
2007-09-25 11:00:00	AMZN	Stock	4.5805	4.615	4.5805	4.612	10732740.0
2007-09-25 12:00:00	AMZN	Stock	4.612	4.641	4.6065	4.636	9702020.0
2007-09-25 13:00:00	AMZN	Stock	4.635	4.6475	4.6225	4.638	11322800.0
2007-09-25 14:00:00	AMZN	Stock	4.638	4.6705	4.6095	4.659	18858080.0
2007-09-25 15:00:00	AMZN	Stock	4.657	4.675	4.6515	4.67	22813700.0

> showing 50 of 38,939 rows — these rows as CSV

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