PREVIEW / stock_1hour / 2007-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-17.parquet
  size:    646 KB
  rows:    30,827
  symbols: 2,502

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-01-17 07:00:00	AAPL	Stock	3.4729	3.4846	3.4714	3.4821	809200.0
2007-01-17 08:00:00	AAPL	Stock	3.4811	3.4925	3.4775	3.4818	11548460.0
2007-01-17 09:00:00	AAPL	Stock	3.4818	3.4879	3.4071	3.4179	227033520.0
2007-01-17 10:00:00	AAPL	Stock	3.4182	3.4464	3.4114	3.4307	228211060.0
2007-01-17 11:00:00	AAPL	Stock	3.4304	3.4396	3.4268	3.4375	128744672.0
2007-01-17 12:00:00	AAPL	Stock	3.4371	3.4443	3.4232	3.4239	104970852.0
2007-01-17 13:00:00	AAPL	Stock	3.4239	3.4357	3.3943	3.4246	110488196.0
2007-01-17 14:00:00	AAPL	Stock	3.4239	3.4304	3.4161	3.4218	131892068.0
2007-01-17 15:00:00	AAPL	Stock	3.4214	3.4243	3.3864	3.3946	301072184.0
2007-01-17 16:00:00	AAPL	Stock	3.393	3.5529	3.3736	3.5	151379732.0
2007-01-17 17:00:00	AAPL	Stock	3.5	3.5071	3.3389	3.3714	226279928.0
2007-01-17 18:00:00	AAPL	Stock	3.3714	3.3714	3.3304	3.3568	26176248.0
2007-01-17 19:00:00	AAPL	Stock	3.3568	3.3643	3.3561	3.3632	3414180.0
2007-01-17 07:00:00	MSFT	Stock	31.12	31.12	31.12	31.12	1700.0
2007-01-17 08:00:00	MSFT	Stock	31.12	31.34	31.12	31.19	69839.0
2007-01-17 09:00:00	MSFT	Stock	31.19	31.44	31.12	31.39	9686951.0
2007-01-17 10:00:00	MSFT	Stock	31.39	31.4	31.26	31.31	7739950.0
2007-01-17 11:00:00	MSFT	Stock	31.31	31.36	31.25	31.32	5397775.0
2007-01-17 12:00:00	MSFT	Stock	31.32	31.39	31.27	31.29	3819945.0
2007-01-17 13:00:00	MSFT	Stock	31.3	31.36	31.2	31.25	4962881.0
2007-01-17 14:00:00	MSFT	Stock	31.24	31.32	31.05	31.07	8970372.0
2007-01-17 15:00:00	MSFT	Stock	31.09	31.16	31.01	31.12	11638346.0
2007-01-17 16:00:00	MSFT	Stock	31.12	31.13	31.01	31.05	2771928.0
2007-01-17 17:00:00	MSFT	Stock	31.06	31.08	30.97	30.97	19509.0
2007-01-17 18:00:00	MSFT	Stock	30.97	31.0	30.81	30.97	45156.0
2007-01-17 19:00:00	MSFT	Stock	30.93	31.02	30.92	31.02	4355.0
2007-01-17 07:00:00	NVDA	Stock	0.5833	0.5833	0.5833	0.5833	6000.0
2007-01-17 08:00:00	NVDA	Stock	0.5835	0.5835	0.5818	0.5833	435000.0
2007-01-17 09:00:00	NVDA	Stock	0.5833	0.5852	0.575	0.5777	145578840.0
2007-01-17 10:00:00	NVDA	Stock	0.5778	0.5785	0.5755	0.5777	86894100.0
2007-01-17 11:00:00	NVDA	Stock	0.5777	0.5798	0.5767	0.579	64179960.0
2007-01-17 12:00:00	NVDA	Stock	0.579	0.5835	0.5753	0.5783	123794820.0
2007-01-17 13:00:00	NVDA	Stock	0.5785	0.5808	0.5775	0.5807	34965660.0
2007-01-17 14:00:00	NVDA	Stock	0.5807	0.5808	0.5772	0.579	74226480.0
2007-01-17 15:00:00	NVDA	Stock	0.5788	0.5793	0.5737	0.5762	119143080.0
2007-01-17 16:00:00	NVDA	Stock	0.5758	0.5758	0.5727	0.5733	13252500.0
2007-01-17 17:00:00	NVDA	Stock	0.5733	0.5735	0.5695	0.5697	615000.0
2007-01-17 18:00:00	NVDA	Stock	0.5698	0.57	0.5688	0.5688	282000.0
2007-01-17 19:00:00	NVDA	Stock	0.569	0.569	0.5685	0.5687	319440.0
2007-01-17 08:00:00	AMZN	Stock	1.9175	1.9175	1.9175	1.9175	2000.0
2007-01-17 09:00:00	AMZN	Stock	1.9285	1.95	1.914	1.925	14844220.0
2007-01-17 10:00:00	AMZN	Stock	1.925	1.932	1.9205	1.9265	9341940.0
2007-01-17 11:00:00	AMZN	Stock	1.9265	1.933	1.9195	1.9215	10671680.0
2007-01-17 12:00:00	AMZN	Stock	1.9215	1.9265	1.9191	1.9245	6166820.0
2007-01-17 13:00:00	AMZN	Stock	1.9245	1.9255	1.914	1.916	6215080.0
2007-01-17 14:00:00	AMZN	Stock	1.916	1.9205	1.8985	1.899	14893220.0
2007-01-17 15:00:00	AMZN	Stock	1.899	1.9025	1.889	1.894	30946820.0
2007-01-17 16:00:00	AMZN	Stock	1.893	1.8945	1.8895	1.89	474680.0
2007-01-17 17:00:00	AMZN	Stock	1.8895	1.8895	1.8865	1.8865	74000.0
2007-01-17 18:00:00	AMZN	Stock	1.89	1.89	1.8885	1.8895	520000.0

> showing 50 of 30,827 rows — these rows as CSV

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