PREVIEW / stock_1hour / 2006-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-04.parquet
  size:    604 KB
  rows:    28,780
  symbols: 2,229

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
2006-04-04 07:00:00	AAPL	Stock	2.2539	2.2539	2.2321	2.2321	50400.0
2006-04-04 08:00:00	AAPL	Stock	2.2304	2.2375	2.2236	2.2282	1983240.0
2006-04-04 09:00:00	AAPL	Stock	2.2282	2.2379	2.1932	2.2061	180513424.0
2006-04-04 10:00:00	AAPL	Stock	2.2061	2.2221	2.1861	2.1882	189018900.0
2006-04-04 11:00:00	AAPL	Stock	2.1882	2.2071	2.1807	2.1907	139742988.0
2006-04-04 12:00:00	AAPL	Stock	2.1907	2.2068	2.1889	2.1893	68621308.0
2006-04-04 13:00:00	AAPL	Stock	2.1893	2.2173	2.1871	2.1957	65849616.0
2006-04-04 14:00:00	AAPL	Stock	2.1961	2.2064	2.1846	2.1868	119880516.0
2006-04-04 15:00:00	AAPL	Stock	2.1868	2.1972	2.1804	2.1846	130276720.0
2006-04-04 16:00:00	AAPL	Stock	2.1846	2.1893	2.1821	2.185	1717184.0
2006-04-04 17:00:00	AAPL	Stock	2.185	2.1864	2.1839	2.1861	665616.0
2006-04-04 18:00:00	AAPL	Stock	2.1864	2.1871	2.185	2.185	317688.0
2006-04-04 08:00:00	MSFT	Stock	27.57	27.65	27.57	27.63	39744.0
2006-04-04 09:00:00	MSFT	Stock	27.62	27.7	27.47	27.58	5566494.0
2006-04-04 10:00:00	MSFT	Stock	27.59	27.69	27.56	27.62	5716931.0
2006-04-04 11:00:00	MSFT	Stock	27.62	27.73	27.58	27.69	4422256.0
2006-04-04 12:00:00	MSFT	Stock	27.7	27.8	27.69	27.77	4938489.0
2006-04-04 13:00:00	MSFT	Stock	27.77	27.8	27.66	27.75	4627969.0
2006-04-04 14:00:00	MSFT	Stock	27.76	27.77	27.61	27.67	6608445.0
2006-04-04 15:00:00	MSFT	Stock	27.67	27.78	27.6	27.63	8407359.0
2006-04-04 16:00:00	MSFT	Stock	27.63	27.651	27.61	27.65	987570.0
2006-04-04 17:00:00	MSFT	Stock	27.61	27.65	27.61	27.64	29763.0
2006-04-04 08:00:00	NVDA	Stock	0.4796	0.4815	0.4795	0.4812	235320.0
2006-04-04 09:00:00	NVDA	Stock	0.4807	0.4901	0.4807	0.4894	145851840.0
2006-04-04 10:00:00	NVDA	Stock	0.4894	0.4987	0.4893	0.4911	179548080.0
2006-04-04 11:00:00	NVDA	Stock	0.4911	0.4981	0.4907	0.4979	134157000.0
2006-04-04 12:00:00	NVDA	Stock	0.498	0.5004	0.4973	0.4986	101626200.0
2006-04-04 13:00:00	NVDA	Stock	0.4987	0.5	0.4958	0.4995	90466200.0
2006-04-04 14:00:00	NVDA	Stock	0.4996	0.5052	0.4995	0.5015	258928920.0
2006-04-04 15:00:00	NVDA	Stock	0.5014	0.5058	0.5007	0.5047	223014720.0
2006-04-04 16:00:00	NVDA	Stock	0.5043	0.5056	0.5032	0.5056	34421040.0
2006-04-04 17:00:00	NVDA	Stock	0.505	0.5052	0.5036	0.5036	3015720.0
2006-04-04 08:00:00	AMZN	Stock	1.805	1.805	1.805	1.805	4000.0
2006-04-04 09:00:00	AMZN	Stock	1.8095	1.824	1.801	1.822	7615080.0
2006-04-04 10:00:00	AMZN	Stock	1.822	1.832	1.8175	1.826	8161900.0
2006-04-04 11:00:00	AMZN	Stock	1.826	1.847	1.8255	1.8385	10948280.0
2006-04-04 12:00:00	AMZN	Stock	1.839	1.855	1.8315	1.835	10643880.0
2006-04-04 13:00:00	AMZN	Stock	1.8345	1.8426	1.82	1.8225	8910000.0
2006-04-04 14:00:00	AMZN	Stock	1.822	1.8325	1.818	1.827	9307460.0
2006-04-04 15:00:00	AMZN	Stock	1.827	1.8441	1.821	1.8385	15192080.0
2006-04-04 16:00:00	AMZN	Stock	1.837	1.8715	1.829	1.8415	215120.0
2006-04-04 17:00:00	AMZN	Stock	1.8363	1.8415	1.8363	1.8385	150400.0
2006-04-04 09:00:00	CL	Stock	29.05	29.05	28.795	28.86	207800.0
2006-04-04 10:00:00	CL	Stock	28.855	29.055	28.845	28.99	496800.0
2006-04-04 11:00:00	CL	Stock	28.985	29.025	28.94	29.0	366000.0
2006-04-04 12:00:00	CL	Stock	29.0	29.065	28.955	29.005	351600.0
2006-04-04 13:00:00	CL	Stock	29.005	29.03	28.95	28.9975	382400.0
2006-04-04 14:00:00	CL	Stock	29.01	29.045	28.91	28.945	536200.0
2006-04-04 15:00:00	CL	Stock	28.945	28.955	28.845	28.92	1025000.0
2006-04-04 16:00:00	CL	Stock	28.935	28.935	28.935	28.935	200.0

> showing 50 of 28,780 rows — these rows as CSV

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