PREVIEW / stock_1hour / 2004-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-08.parquet
  size:    511 KB
  rows:    23,952
  symbols: 1,804

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
2004-07-08 08:00:00	AAPL	Stock	0.5355	0.5355	0.5339	0.5343	67200.0
2004-07-08 09:00:00	AAPL	Stock	0.5355	0.5423	0.5348	0.5402	26690832.0
2004-07-08 10:00:00	AAPL	Stock	0.5404	0.5446	0.54	0.5425	31511312.0
2004-07-08 11:00:00	AAPL	Stock	0.5425	0.5464	0.5423	0.5461	39677288.0
2004-07-08 12:00:00	AAPL	Stock	0.5459	0.5479	0.5416	0.543	18139520.0
2004-07-08 13:00:00	AAPL	Stock	0.5429	0.5446	0.5393	0.54	26136656.0
2004-07-08 14:00:00	AAPL	Stock	0.54	0.5411	0.5375	0.5411	24908408.0
2004-07-08 15:00:00	AAPL	Stock	0.5409	0.5411	0.5364	0.5366	43083040.0
2004-07-08 16:00:00	AAPL	Stock	0.5371	0.5409	0.5364	0.5382	3812144.0
2004-07-08 17:00:00	AAPL	Stock	0.5402	0.5402	0.5402	0.5402	5600.0
2004-07-08 08:00:00	MSFT	Stock	27.65	27.89	27.65	27.85	37200.0
2004-07-08 09:00:00	MSFT	Stock	27.86	28.04	27.771	27.89	7670985.0
2004-07-08 10:00:00	MSFT	Stock	27.89	28.03	27.83	27.96	8387309.0
2004-07-08 11:00:00	MSFT	Stock	27.93	28.15	27.88	28.07	8514300.0
2004-07-08 12:00:00	MSFT	Stock	28.06	28.07	27.85	27.9	4501404.0
2004-07-08 13:00:00	MSFT	Stock	27.9	27.98	27.87	27.89	4832732.0
2004-07-08 14:00:00	MSFT	Stock	27.89	27.94	27.77	27.92	8599544.0
2004-07-08 15:00:00	MSFT	Stock	27.92	27.98	27.56	27.62	13455320.0
2004-07-08 16:00:00	MSFT	Stock	27.63	27.8947	27.62	27.67	1032086.0
2004-07-08 17:00:00	MSFT	Stock	27.68	27.72	27.64	27.7	22500.0
2004-07-08 18:00:00	MSFT	Stock	27.7	27.73	27.7	27.73	4145.0
2004-07-08 09:00:00	NVDA	Stock	0.1507	0.1529	0.1501	0.151	58020000.0
2004-07-08 10:00:00	NVDA	Stock	0.1508	0.1513	0.1483	0.1487	65578920.0
2004-07-08 11:00:00	NVDA	Stock	0.1486	0.1514	0.1482	0.1509	61063680.0
2004-07-08 12:00:00	NVDA	Stock	0.1509	0.151	0.149	0.1492	32507160.0
2004-07-08 13:00:00	NVDA	Stock	0.1492	0.1492	0.1474	0.1475	59019360.0
2004-07-08 14:00:00	NVDA	Stock	0.1476	0.1491	0.1472	0.1476	61067040.0
2004-07-08 15:00:00	NVDA	Stock	0.1474	0.1484	0.1469	0.1471	79979160.0
2004-07-08 16:00:00	NVDA	Stock	0.1471	0.1491	0.147	0.1472	4421160.0
2004-07-08 17:00:00	NVDA	Stock	0.1472	0.1472	0.1472	0.1472	96000.0
2004-07-08 18:00:00	NVDA	Stock	0.1472	0.1472	0.1472	0.1472	96000.0
2004-07-08 08:00:00	AMZN	Stock	2.43	2.4375	2.4	2.419	1571160.0
2004-07-08 09:00:00	AMZN	Stock	2.419	2.468	2.4185	2.468	54076040.0
2004-07-08 10:00:00	AMZN	Stock	2.468	2.474	2.4415	2.4685	31706760.0
2004-07-08 11:00:00	AMZN	Stock	2.4685	2.4985	2.466	2.4705	29690520.0
2004-07-08 12:00:00	AMZN	Stock	2.4705	2.485	2.4685	2.475	16856700.0
2004-07-08 13:00:00	AMZN	Stock	2.475	2.4785	2.4685	2.476	9177200.0
2004-07-08 14:00:00	AMZN	Stock	2.4765	2.4795	2.4595	2.4705	22290320.0
2004-07-08 15:00:00	AMZN	Stock	2.4705	2.4835	2.465	2.475	25332500.0
2004-07-08 16:00:00	AMZN	Stock	2.475	2.4785	2.4656	2.4785	1727280.0
2004-07-08 17:00:00	AMZN	Stock	2.475	2.479	2.4745	2.4745	78540.0
2004-07-08 09:00:00	CL	Stock	29.0	29.145	28.995	29.13	151600.0
2004-07-08 10:00:00	CL	Stock	29.125	29.225	29.09	29.125	527800.0
2004-07-08 11:00:00	CL	Stock	29.125	29.22	29.125	29.22	296000.0
2004-07-08 12:00:00	CL	Stock	29.225	29.225	29.115	29.185	180800.0
2004-07-08 13:00:00	CL	Stock	29.18	29.21	29.14	29.195	247600.0
2004-07-08 14:00:00	CL	Stock	29.195	29.195	29.055	29.14	273200.0
2004-07-08 15:00:00	CL	Stock	29.14	29.185	29.005	29.01	502600.0
2004-07-08 16:00:00	CL	Stock	29.03	29.03	29.03	29.03	55800.0

> showing 49 of 23,952 rows — these rows as CSV

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