PREVIEW / stock_1hour / 2007-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-07.parquet
  size:    815 KB
  rows:    40,618
  symbols: 3,235

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-12-07 04:00:00	AAPL	Stock	6.7643	6.7643	6.7643	6.7643	11200.0
2007-12-07 07:00:00	AAPL	Stock	6.7786	6.7786	6.7607	6.7625	106148.0
2007-12-07 08:00:00	AAPL	Stock	6.7675	6.8382	6.7607	6.7971	10700816.0
2007-12-07 09:00:00	AAPL	Stock	6.7968	6.8125	6.7157	6.7536	160625584.0
2007-12-07 10:00:00	AAPL	Stock	6.7539	6.8139	6.7329	6.8125	157749004.0
2007-12-07 11:00:00	AAPL	Stock	6.8132	6.8368	6.7871	6.8318	122150140.0
2007-12-07 12:00:00	AAPL	Stock	6.8318	6.8529	6.8186	6.8271	79497964.0
2007-12-07 13:00:00	AAPL	Stock	6.8261	6.8414	6.8054	6.8346	72732744.0
2007-12-07 14:00:00	AAPL	Stock	6.8343	6.9336	6.8321	6.8971	174258868.0
2007-12-07 15:00:00	AAPL	Stock	6.8964	6.9639	6.8957	6.9379	266444192.0
2007-12-07 16:00:00	AAPL	Stock	6.9375	6.945	6.8462	6.9364	19676132.0
2007-12-07 17:00:00	AAPL	Stock	6.9364	6.9425	6.9321	6.9375	1665720.0
2007-12-07 18:00:00	AAPL	Stock	6.9393	6.94	6.9361	6.9371	278964.0
2007-12-07 19:00:00	AAPL	Stock	6.9379	6.9389	6.9329	6.9329	183008.0
2007-12-07 07:00:00	MSFT	Stock	34.5	34.57	34.5	34.57	6561.0
2007-12-07 08:00:00	MSFT	Stock	34.55	34.73	34.49	34.7	71512.0
2007-12-07 09:00:00	MSFT	Stock	34.73	34.73	34.3	34.44	4006243.0
2007-12-07 10:00:00	MSFT	Stock	34.43	34.47	34.22	34.34	5428687.0
2007-12-07 11:00:00	MSFT	Stock	34.34	34.6	34.33	34.52	4504544.0
2007-12-07 12:00:00	MSFT	Stock	34.52	34.61	34.4	34.42	4389896.0
2007-12-07 13:00:00	MSFT	Stock	34.422	34.48	34.36	34.41	2469635.0
2007-12-07 14:00:00	MSFT	Stock	34.42	34.62	34.4	34.515	4831229.0
2007-12-07 15:00:00	MSFT	Stock	34.52	34.65	34.46	34.52	7396361.0
2007-12-07 16:00:00	MSFT	Stock	34.52	34.563	34.45	34.53	7353564.0
2007-12-07 17:00:00	MSFT	Stock	34.51	34.57	34.45	34.57	312915.0
2007-12-07 08:00:00	NVDA	Stock	0.8538	0.8578	0.8538	0.8578	183200.0
2007-12-07 09:00:00	NVDA	Stock	0.8602	0.8625	0.848	0.849	37083160.0
2007-12-07 10:00:00	NVDA	Stock	0.8488	0.8535	0.8412	0.8495	42981880.0
2007-12-07 11:00:00	NVDA	Stock	0.85	0.851	0.844	0.8445	41893120.0
2007-12-07 12:00:00	NVDA	Stock	0.8448	0.847	0.8425	0.8432	32452360.0
2007-12-07 13:00:00	NVDA	Stock	0.8432	0.8452	0.8382	0.8452	30555640.0
2007-12-07 14:00:00	NVDA	Stock	0.845	0.85	0.8432	0.8482	42505720.0
2007-12-07 15:00:00	NVDA	Stock	0.8482	0.8528	0.843	0.847	76206000.0
2007-12-07 16:00:00	NVDA	Stock	0.847	0.8493	0.8458	0.847	15513760.0
2007-12-07 17:00:00	NVDA	Stock	0.847	0.847	0.8468	0.8468	831160.0
2007-12-07 04:00:00	AMZN	Stock	4.725	4.78	4.725	4.78	4800.0
2007-12-07 08:00:00	AMZN	Stock	4.73	4.73	4.7105	4.72	199500.0
2007-12-07 09:00:00	AMZN	Stock	4.7225	4.746	4.6455	4.657	14705340.0
2007-12-07 10:00:00	AMZN	Stock	4.6562	4.693	4.6505	4.6785	11424920.0
2007-12-07 11:00:00	AMZN	Stock	4.6775	4.695	4.671	4.6795	7139340.0
2007-12-07 12:00:00	AMZN	Stock	4.68	4.7195	4.6765	4.6975	6467020.0
2007-12-07 13:00:00	AMZN	Stock	4.698	4.7095	4.676	4.705	7024040.0
2007-12-07 14:00:00	AMZN	Stock	4.7065	4.717	4.6815	4.7045	7829160.0
2007-12-07 15:00:00	AMZN	Stock	4.704	4.715	4.687	4.714	17912020.0
2007-12-07 16:00:00	AMZN	Stock	4.7095	4.7193	4.6903	4.7155	3709260.0
2007-12-07 17:00:00	AMZN	Stock	4.7155	4.7155	4.71	4.715	249420.0
2007-12-07 18:00:00	AMZN	Stock	4.7135	4.7155	4.7135	4.7155	10120.0
2007-12-07 19:00:00	AMZN	Stock	4.7135	4.7135	4.7135	4.7135	7500.0
2007-12-07 08:00:00	TLT	Stock	92.5	92.5	92.29	92.36	10700.0
2007-12-07 09:00:00	TLT	Stock	92.37	92.4	92.02	92.11	196700.0

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

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