PREVIEW / stock_1hour / 2007-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-16.parquet
  size:    772 KB
  rows:    37,690
  symbols: 3,070

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-07-16 09:00:00	AAPL	Stock	4.9425	4.9993	4.9289	4.9493	209116264.0
2007-07-16 10:00:00	AAPL	Stock	4.9514	4.9882	4.9368	4.9729	215264168.0
2007-07-16 11:00:00	AAPL	Stock	4.9734	4.9882	4.9643	4.9754	88933544.0
2007-07-16 12:00:00	AAPL	Stock	4.9757	4.9789	4.9561	4.9654	62369300.0
2007-07-16 13:00:00	AAPL	Stock	4.9654	4.9725	4.9164	4.9254	122407684.0
2007-07-16 14:00:00	AAPL	Stock	4.9257	4.9554	4.9107	4.9371	103510792.0
2007-07-16 15:00:00	AAPL	Stock	4.9368	4.9479	4.9218	4.9314	103738096.0
2007-07-16 16:00:00	AAPL	Stock	4.9314	4.9321	4.9311	4.9321	9521932.0
2007-07-16 09:00:00	MSFT	Stock	29.76	29.97	29.72	29.96	3948102.0
2007-07-16 10:00:00	MSFT	Stock	29.95	30.15	29.9	30.15	6866617.0
2007-07-16 11:00:00	MSFT	Stock	30.15	30.19	30.09	30.18	4491609.0
2007-07-16 12:00:00	MSFT	Stock	30.18	30.24	30.1	30.11	6064454.0
2007-07-16 13:00:00	MSFT	Stock	30.11	30.15	30.02	30.03	4740091.0
2007-07-16 14:00:00	MSFT	Stock	30.03	30.11	30.0	30.06	4489633.0
2007-07-16 15:00:00	MSFT	Stock	30.05	30.15	30.02	30.03	8551429.0
2007-07-16 16:00:00	MSFT	Stock	30.03	30.03	30.03	30.03	1447654.0
2007-07-16 08:00:00	NVDA	Stock	0.7708	0.7717	0.7708	0.7717	24000.0
2007-07-16 09:00:00	NVDA	Stock	0.7697	0.771	0.765	0.7678	40176840.0
2007-07-16 10:00:00	NVDA	Stock	0.7677	0.7738	0.7663	0.7735	54558960.0
2007-07-16 11:00:00	NVDA	Stock	0.7733	0.7798	0.7731	0.778	67333920.0
2007-07-16 12:00:00	NVDA	Stock	0.7782	0.7815	0.7777	0.7812	43235220.0
2007-07-16 13:00:00	NVDA	Stock	0.7812	0.7815	0.7715	0.772	117763380.0
2007-07-16 14:00:00	NVDA	Stock	0.7722	0.7772	0.7713	0.7755	44755740.0
2007-07-16 15:00:00	NVDA	Stock	0.7753	0.7795	0.7738	0.7783	87682200.0
2007-07-16 16:00:00	NVDA	Stock	0.7783	0.7783	0.7754	0.7768	60264900.0
2007-07-16 17:00:00	NVDA	Stock	0.7745	0.7783	0.7745	0.7783	97380.0
2007-07-16 19:00:00	NVDA	Stock	0.7808	0.7808	0.7808	0.7808	6000.0
2007-07-16 07:00:00	AMZN	Stock	3.7405	3.7625	3.7325	3.7625	215020.0
2007-07-16 08:00:00	AMZN	Stock	3.76	3.76	3.735	3.7475	563060.0
2007-07-16 09:00:00	AMZN	Stock	3.7425	3.755	3.71	3.7225	22907600.0
2007-07-16 10:00:00	AMZN	Stock	3.722	3.7325	3.714	3.716	24737500.0
2007-07-16 11:00:00	AMZN	Stock	3.7155	3.7165	3.694	3.707	25602500.0
2007-07-16 12:00:00	AMZN	Stock	3.7065	3.7075	3.6925	3.695	14643500.0
2007-07-16 13:00:00	AMZN	Stock	3.6948	3.6985	3.6525	3.657	22430640.0
2007-07-16 14:00:00	AMZN	Stock	3.657	3.6875	3.65	3.6825	18578560.0
2007-07-16 15:00:00	AMZN	Stock	3.683	3.694	3.6755	3.6845	28060040.0
2007-07-16 16:00:00	AMZN	Stock	3.6845	3.6925	3.6845	3.69	758740.0
2007-07-16 17:00:00	AMZN	Stock	3.6925	3.6926	3.69	3.6926	38460.0
2007-07-16 18:00:00	AMZN	Stock	3.695	3.695	3.695	3.695	2000.0
2007-07-16 19:00:00	AMZN	Stock	3.6915	3.695	3.69	3.695	19500.0
2007-07-16 09:00:00	TLT	Stock	84.52	84.67	84.52	84.6	46100.0
2007-07-16 10:00:00	TLT	Stock	84.6	84.66	84.52	84.62	48600.0
2007-07-16 11:00:00	TLT	Stock	84.63	84.82	84.59	84.8	92500.0
2007-07-16 12:00:00	TLT	Stock	84.8	84.95	84.79	84.85	148300.0
2007-07-16 13:00:00	TLT	Stock	84.85	85.06	84.84	84.95	187800.0
2007-07-16 14:00:00	TLT	Stock	84.95	85.08	84.88	85.05	153200.0
2007-07-16 15:00:00	TLT	Stock	85.05	85.06	84.95	85.03	165000.0
2007-07-16 16:00:00	TLT	Stock	85.03	85.11	85.03	85.07	70800.0
2007-07-16 09:00:00	CL	Stock	34.225	34.225	34.015	34.06	353400.0
2007-07-16 10:00:00	CL	Stock	34.05	34.235	34.045	34.16	665566.0

> showing 50 of 37,690 rows — these rows as CSV

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