PREVIEW / stock_1hour / 2007-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-19.parquet
  size:    636 KB
  rows:    30,270
  symbols: 2,500

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-19 04:00:00	AAPL	Stock	3.1775	3.1818	3.1775	3.1818	14000.0
2007-01-19 07:00:00	AAPL	Stock	3.1689	3.175	3.1618	3.1643	1721244.0
2007-01-19 08:00:00	AAPL	Stock	3.1661	3.1714	3.1529	3.1643	9896908.0
2007-01-19 09:00:00	AAPL	Stock	3.1643	3.1954	3.1471	3.1646	235412912.0
2007-01-19 10:00:00	AAPL	Stock	3.1646	3.1943	3.155	3.1707	314212808.0
2007-01-19 11:00:00	AAPL	Stock	3.1707	3.1786	3.1571	3.1632	163779672.0
2007-01-19 12:00:00	AAPL	Stock	3.1636	3.1804	3.1543	3.1771	132387612.0
2007-01-19 13:00:00	AAPL	Stock	3.1771	3.2011	3.1764	3.1946	153959848.0
2007-01-19 14:00:00	AAPL	Stock	3.1946	3.2018	3.1843	3.1871	128642304.0
2007-01-19 15:00:00	AAPL	Stock	3.1868	3.1875	3.155	3.1604	196826364.0
2007-01-19 16:00:00	AAPL	Stock	3.1607	3.1679	3.1575	3.1625	2734228.0
2007-01-19 17:00:00	AAPL	Stock	3.1643	3.1643	3.1589	3.1625	556136.0
2007-01-19 18:00:00	AAPL	Stock	3.1621	3.1625	3.1607	3.1607	145768.0
2007-01-19 19:00:00	AAPL	Stock	3.1611	3.1679	3.1607	3.1629	371672.0
2007-01-19 08:00:00	MSFT	Stock	30.8	30.81	30.75	30.76	112505.0
2007-01-19 09:00:00	MSFT	Stock	30.75	30.98	30.69	30.86	12170799.0
2007-01-19 10:00:00	MSFT	Stock	30.87	30.96	30.79	30.823	11739500.0
2007-01-19 11:00:00	MSFT	Stock	30.82	30.9	30.81	30.88	9680911.0
2007-01-19 12:00:00	MSFT	Stock	30.87	30.95	30.83	30.87	7073953.0
2007-01-19 13:00:00	MSFT	Stock	30.87	30.96	30.87	30.96	6124888.0
2007-01-19 14:00:00	MSFT	Stock	30.95	31.09	30.91	31.04	10411555.0
2007-01-19 15:00:00	MSFT	Stock	31.04	31.11	30.96	31.09	15323575.0
2007-01-19 16:00:00	MSFT	Stock	31.09	31.12	30.998	31.09	316956.0
2007-01-19 17:00:00	MSFT	Stock	31.09	31.1	31.06	31.06	5200.0
2007-01-19 18:00:00	MSFT	Stock	31.07	31.1	31.06	31.06	1400.0
2007-01-19 19:00:00	MSFT	Stock	31.07	31.1	31.07	31.08	9392.0
2007-01-19 08:00:00	NVDA	Stock	0.525	0.525	0.5217	0.5233	225900.0
2007-01-19 09:00:00	NVDA	Stock	0.5233	0.5285	0.5188	0.524	120747000.0
2007-01-19 10:00:00	NVDA	Stock	0.524	0.5417	0.5238	0.5385	196672560.0
2007-01-19 11:00:00	NVDA	Stock	0.5383	0.5423	0.5335	0.5377	112367640.0
2007-01-19 12:00:00	NVDA	Stock	0.5377	0.5378	0.5328	0.535	62518260.0
2007-01-19 13:00:00	NVDA	Stock	0.5352	0.5393	0.5347	0.5373	63622920.0
2007-01-19 14:00:00	NVDA	Stock	0.5373	0.539	0.5342	0.5382	120662160.0
2007-01-19 15:00:00	NVDA	Stock	0.5383	0.5387	0.5292	0.532	203280600.0
2007-01-19 16:00:00	NVDA	Stock	0.5312	0.5382	0.5312	0.5315	1725540.0
2007-01-19 17:00:00	NVDA	Stock	0.5315	0.5315	0.5303	0.5313	139200.0
2007-01-19 09:00:00	AMZN	Stock	1.85	1.861	1.83	1.8575	19897760.0
2007-01-19 10:00:00	AMZN	Stock	1.8575	1.874	1.8525	1.8655	20424900.0
2007-01-19 11:00:00	AMZN	Stock	1.866	1.874	1.8555	1.865	13369000.0
2007-01-19 12:00:00	AMZN	Stock	1.8645	1.8695	1.8515	1.8525	13274620.0
2007-01-19 13:00:00	AMZN	Stock	1.8525	1.8585	1.8505	1.8565	10858680.0
2007-01-19 14:00:00	AMZN	Stock	1.857	1.8655	1.8565	1.862	9062660.0
2007-01-19 15:00:00	AMZN	Stock	1.862	1.8635	1.848	1.8495	28393980.0
2007-01-19 16:00:00	AMZN	Stock	1.85	1.851	1.8475	1.849	1547680.0
2007-01-19 18:00:00	AMZN	Stock	1.851	1.851	1.851	1.851	9000.0
2007-01-19 19:00:00	AMZN	Stock	1.8505	1.855	1.8485	1.855	31900.0
2007-01-19 09:00:00	CL	Stock	32.795	33.325	32.795	33.285	570000.0
2007-01-19 10:00:00	CL	Stock	33.28	33.3	33.175	33.195	321800.0
2007-01-19 11:00:00	CL	Stock	33.2	33.2	33.155	33.185	271400.0
2007-01-19 12:00:00	CL	Stock	33.18	33.2	33.14	33.19	174800.0

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

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