PREVIEW / stock_1hour / 2004-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-17.parquet
  size:    508 KB
  rows:    24,949
  symbols: 1,780

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-05-17 08:00:00	AAPL	Stock	0.4802	0.4805	0.4779	0.4786	296520.0
2004-05-17 09:00:00	AAPL	Stock	0.4779	0.4832	0.4732	0.475	50830024.0
2004-05-17 10:00:00	AAPL	Stock	0.475	0.4821	0.4707	0.4759	51016280.0
2004-05-17 11:00:00	AAPL	Stock	0.4754	0.4821	0.4727	0.4791	34790000.0
2004-05-17 12:00:00	AAPL	Stock	0.4795	0.48	0.4759	0.4779	18257960.0
2004-05-17 13:00:00	AAPL	Stock	0.4779	0.4784	0.4743	0.477	24936968.0
2004-05-17 14:00:00	AAPL	Stock	0.477	0.4795	0.475	0.4752	43472184.0
2004-05-17 15:00:00	AAPL	Stock	0.475	0.4789	0.475	0.4764	56605528.0
2004-05-17 16:00:00	AAPL	Stock	0.4771	0.4846	0.475	0.4757	4736872.0
2004-05-17 08:00:00	MSFT	Stock	25.71	25.855	25.57	25.62	118750.0
2004-05-17 09:00:00	MSFT	Stock	25.61	25.89	25.42	25.57	9363582.0
2004-05-17 10:00:00	MSFT	Stock	25.57	25.65	25.48	25.56	8604435.0
2004-05-17 11:00:00	MSFT	Stock	25.55	25.79	25.5	25.72	8708569.0
2004-05-17 12:00:00	MSFT	Stock	25.72	25.76	25.6	25.651	5293283.0
2004-05-17 13:00:00	MSFT	Stock	25.66	25.67	25.5	25.57	4499909.0
2004-05-17 14:00:00	MSFT	Stock	25.57	25.71	25.53	25.62	6960505.0
2004-05-17 15:00:00	MSFT	Stock	25.63	25.7	25.5	25.55	8932795.0
2004-05-17 16:00:00	MSFT	Stock	25.55	25.614	25.53	25.6	1245907.0
2004-05-17 17:00:00	MSFT	Stock	25.58	25.58	25.58	25.58	500.0
2004-05-17 18:00:00	MSFT	Stock	25.59	25.6	25.59	25.6	11000.0
2004-05-17 08:00:00	NVDA	Stock	0.1786	0.1787	0.1773	0.1773	612000.0
2004-05-17 09:00:00	NVDA	Stock	0.1787	0.1787	0.175	0.1758	55334280.0
2004-05-17 10:00:00	NVDA	Stock	0.1757	0.1777	0.1737	0.1773	77825880.0
2004-05-17 11:00:00	NVDA	Stock	0.1773	0.1789	0.1763	0.1783	30121920.0
2004-05-17 12:00:00	NVDA	Stock	0.1784	0.179	0.1767	0.1772	28679880.0
2004-05-17 13:00:00	NVDA	Stock	0.1772	0.1782	0.1762	0.1763	31022040.0
2004-05-17 14:00:00	NVDA	Stock	0.1762	0.1778	0.1762	0.1777	33381480.0
2004-05-17 15:00:00	NVDA	Stock	0.1777	0.1783	0.1758	0.1763	42552840.0
2004-05-17 16:00:00	NVDA	Stock	0.1763	0.1764	0.1757	0.1763	649440.0
2004-05-17 17:00:00	NVDA	Stock	0.1763	0.1763	0.1763	0.1763	144000.0
2004-05-17 08:00:00	AMZN	Stock	2.1562	2.1562	2.123	2.125	1080000.0
2004-05-17 09:00:00	AMZN	Stock	2.1235	2.1295	2.085	2.095	24607860.0
2004-05-17 10:00:00	AMZN	Stock	2.094	2.1095	2.085	2.0985	29093120.0
2004-05-17 11:00:00	AMZN	Stock	2.098	2.1245	2.088	2.1105	16302000.0
2004-05-17 12:00:00	AMZN	Stock	2.1105	2.114	2.094	2.103	7450240.0
2004-05-17 13:00:00	AMZN	Stock	2.1035	2.104	2.09	2.093	7898700.0
2004-05-17 14:00:00	AMZN	Stock	2.093	2.1035	2.0875	2.1	15899200.0
2004-05-17 15:00:00	AMZN	Stock	2.1	2.1095	2.0915	2.104	23253180.0
2004-05-17 16:00:00	AMZN	Stock	2.104	2.11	2.0995	2.104	2278640.0
2004-05-17 17:00:00	AMZN	Stock	2.1047	2.1047	2.104	2.104	38800.0
2004-05-17 18:00:00	AMZN	Stock	2.104	2.104	2.104	2.104	28800.0
2004-05-17 09:00:00	CL	Stock	27.75	27.89	27.74	27.875	357600.0
2004-05-17 10:00:00	CL	Stock	27.875	28.335	27.81	28.14	711000.0
2004-05-17 11:00:00	CL	Stock	28.145	28.295	28.015	28.295	370200.0
2004-05-17 12:00:00	CL	Stock	28.3	28.35	28.225	28.27	339600.0
2004-05-17 13:00:00	CL	Stock	28.27	28.305	28.175	28.28	203200.0
2004-05-17 14:00:00	CL	Stock	28.275	28.4	28.255	28.28	402600.0
2004-05-17 15:00:00	CL	Stock	28.28	28.35	28.05	28.085	654400.0
2004-05-17 16:00:00	CL	Stock	28.06	28.085	28.06	28.085	6400.0

> showing 49 of 24,949 rows — these rows as CSV

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