PREVIEW / stock_1hour / 2007-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-17.parquet
  size:    764 KB
  rows:    37,653
  symbols: 3,071

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-17 09:00:00	AAPL	Stock	4.9393	4.9593	4.9186	4.9229	97766032.0
2007-07-17 10:00:00	AAPL	Stock	4.9225	4.9689	4.9107	4.9664	163174116.0
2007-07-17 11:00:00	AAPL	Stock	4.9661	4.9821	4.9557	4.9614	111586748.0
2007-07-17 12:00:00	AAPL	Stock	4.9614	4.9643	4.9464	4.9589	65170644.0
2007-07-17 13:00:00	AAPL	Stock	4.9593	4.9857	4.9554	4.9689	61759600.0
2007-07-17 14:00:00	AAPL	Stock	4.9686	4.9818	4.9679	4.9714	74299316.0
2007-07-17 15:00:00	AAPL	Stock	4.9714	4.9725	4.9543	4.9593	100339792.0
2007-07-17 16:00:00	AAPL	Stock	4.9604	4.9611	4.9604	4.9611	9930872.0
2007-07-17 09:00:00	MSFT	Stock	30.02	30.4	30.01	30.385	6671144.0
2007-07-17 10:00:00	MSFT	Stock	30.38	30.53	30.32	30.48	15212319.0
2007-07-17 11:00:00	MSFT	Stock	30.475	30.49	30.35	30.46	6859887.0
2007-07-17 12:00:00	MSFT	Stock	30.45	30.55	30.44	30.51	6922166.0
2007-07-17 13:00:00	MSFT	Stock	30.5	30.7	30.445	30.67	7888618.0
2007-07-17 14:00:00	MSFT	Stock	30.67	30.84	30.65	30.781	9668130.0
2007-07-17 15:00:00	MSFT	Stock	30.788	30.88	30.65	30.75	19449022.0
2007-07-17 16:00:00	MSFT	Stock	30.75	30.78	30.75	30.78	2246625.0
2007-07-17 08:00:00	NVDA	Stock	0.7783	0.787	0.7783	0.7833	188400.0
2007-07-17 09:00:00	NVDA	Stock	0.7815	0.7955	0.7795	0.794	55192380.0
2007-07-17 10:00:00	NVDA	Stock	0.794	0.7972	0.7905	0.7923	105007200.0
2007-07-17 11:00:00	NVDA	Stock	0.7923	0.7942	0.7847	0.7855	77932020.0
2007-07-17 12:00:00	NVDA	Stock	0.7853	0.787	0.7817	0.7828	78910980.0
2007-07-17 13:00:00	NVDA	Stock	0.7828	0.7887	0.7793	0.7853	66264240.0
2007-07-17 14:00:00	NVDA	Stock	0.7853	0.7873	0.7802	0.7807	90281880.0
2007-07-17 15:00:00	NVDA	Stock	0.7807	0.7812	0.7743	0.7755	129420000.0
2007-07-17 16:00:00	NVDA	Stock	0.7755	0.7755	0.76	0.76	32627220.0
2007-07-17 17:00:00	NVDA	Stock	0.76	0.7665	0.7587	0.7587	1291980.0
2007-07-17 18:00:00	NVDA	Stock	0.7587	0.7593	0.755	0.755	598260.0
2007-07-17 19:00:00	NVDA	Stock	0.7567	0.7578	0.755	0.7578	40800.0
2007-07-17 06:00:00	AMZN	Stock	3.6845	3.6845	3.6845	3.6845	4000.0
2007-07-17 07:00:00	AMZN	Stock	3.7045	3.7115	3.7	3.7115	83600.0
2007-07-17 08:00:00	AMZN	Stock	3.7125	3.7125	3.686	3.709	239100.0
2007-07-17 09:00:00	AMZN	Stock	3.707	3.726	3.692	3.72	19646260.0
2007-07-17 10:00:00	AMZN	Stock	3.7205	3.7225	3.68	3.6915	22477780.0
2007-07-17 11:00:00	AMZN	Stock	3.692	3.708	3.69	3.7045	14247680.0
2007-07-17 12:00:00	AMZN	Stock	3.7045	3.7075	3.6875	3.691	11676920.0
2007-07-17 13:00:00	AMZN	Stock	3.69	3.692	3.6795	3.6855	17576300.0
2007-07-17 14:00:00	AMZN	Stock	3.6855	3.706	3.6845	3.7	11720180.0
2007-07-17 15:00:00	AMZN	Stock	3.6995	3.704	3.683	3.6895	20755060.0
2007-07-17 16:00:00	AMZN	Stock	3.6895	3.6922	3.6665	3.684	1877620.0
2007-07-17 17:00:00	AMZN	Stock	3.68	3.68	3.67	3.67	44000.0
2007-07-17 18:00:00	AMZN	Stock	3.6675	3.6795	3.665	3.665	142200.0
2007-07-17 19:00:00	AMZN	Stock	3.659	3.659	3.659	3.659	12000.0
2007-07-17 09:00:00	TLT	Stock	84.86	84.92	84.82	84.89	19600.0
2007-07-17 10:00:00	TLT	Stock	84.9	84.92	84.5	84.51	113200.0
2007-07-17 11:00:00	TLT	Stock	84.51	84.68	84.5	84.67	134100.0
2007-07-17 12:00:00	TLT	Stock	84.66	84.9	84.66	84.9	120000.0
2007-07-17 13:00:00	TLT	Stock	84.91	85.09	84.88	84.94	118500.0
2007-07-17 14:00:00	TLT	Stock	84.94	84.94	84.66	84.69	31900.0
2007-07-17 15:00:00	TLT	Stock	84.69	84.91	84.69	84.87	179025.0
2007-07-17 16:00:00	TLT	Stock	84.87	84.89	84.87	84.89	6800.0

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

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