PREVIEW / stock_1hour / 2004-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-01.parquet
  size:    521 KB
  rows:    24,455
  symbols: 1,798

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-01 08:00:00	AAPL	Stock	0.5732	0.5811	0.5732	0.5793	246400.0
2004-07-01 09:00:00	AAPL	Stock	0.5811	0.5811	0.5696	0.5736	60250904.0
2004-07-01 10:00:00	AAPL	Stock	0.5736	0.58	0.5736	0.5775	49324128.0
2004-07-01 11:00:00	AAPL	Stock	0.5775	0.5775	0.5714	0.5727	53783016.0
2004-07-01 12:00:00	AAPL	Stock	0.573	0.5763	0.572	0.5755	30353176.0
2004-07-01 13:00:00	AAPL	Stock	0.5755	0.5755	0.573	0.5739	22311296.0
2004-07-01 14:00:00	AAPL	Stock	0.5741	0.5773	0.5721	0.5768	36524880.0
2004-07-01 15:00:00	AAPL	Stock	0.5768	0.5798	0.5754	0.5766	75498640.0
2004-07-01 16:00:00	AAPL	Stock	0.5768	0.5779	0.575	0.5766	3828328.0
2004-07-01 17:00:00	AAPL	Stock	0.5768	0.5768	0.5446	0.5446	3859240.0
2004-07-01 18:00:00	AAPL	Stock	0.5448	0.5448	0.5411	0.5446	3057600.0
2004-07-01 08:00:00	MSFT	Stock	28.69	28.78	28.56	28.74	197773.0
2004-07-01 09:00:00	MSFT	Stock	28.7	28.82	28.55	28.7	10214600.0
2004-07-01 10:00:00	MSFT	Stock	28.71	28.8	28.51	28.54	11508869.0
2004-07-01 11:00:00	MSFT	Stock	28.54	28.55	28.4	28.43	13338462.0
2004-07-01 12:00:00	MSFT	Stock	28.43	28.51	28.39	28.47	6709595.0
2004-07-01 13:00:00	MSFT	Stock	28.47	28.48	28.26	28.32	7683728.0
2004-07-01 14:00:00	MSFT	Stock	28.31	28.53	28.3	28.49	9931032.0
2004-07-01 15:00:00	MSFT	Stock	28.49	28.67	28.45	28.62	14706674.0
2004-07-01 16:00:00	MSFT	Stock	28.63	28.64	28.52	28.6	749045.0
2004-07-01 17:00:00	MSFT	Stock	28.63	28.74	28.55	28.6	557923.0
2004-07-01 18:00:00	MSFT	Stock	28.6	28.6	28.55	28.6	4972.0
2004-07-01 08:00:00	NVDA	Stock	0.1715	0.1715	0.1715	0.1715	12000.0
2004-07-01 09:00:00	NVDA	Stock	0.1708	0.1727	0.1667	0.167	70968240.0
2004-07-01 10:00:00	NVDA	Stock	0.1671	0.1671	0.1645	0.1647	102044640.0
2004-07-01 11:00:00	NVDA	Stock	0.1647	0.1652	0.163	0.1643	81766440.0
2004-07-01 12:00:00	NVDA	Stock	0.1643	0.1647	0.1642	0.1645	22219080.0
2004-07-01 13:00:00	NVDA	Stock	0.1645	0.1647	0.163	0.1632	61668000.0
2004-07-01 14:00:00	NVDA	Stock	0.1632	0.1642	0.1632	0.1642	33349200.0
2004-07-01 15:00:00	NVDA	Stock	0.1642	0.1642	0.1625	0.1634	105489120.0
2004-07-01 16:00:00	NVDA	Stock	0.1635	0.1648	0.1625	0.1636	9232800.0
2004-07-01 17:00:00	NVDA	Stock	0.1634	0.1634	0.1617	0.1627	1013160.0
2004-07-01 18:00:00	NVDA	Stock	0.1636	0.1636	0.1636	0.1636	60000.0
2004-07-01 08:00:00	AMZN	Stock	2.7145	2.72	2.6935	2.697	290340.0
2004-07-01 09:00:00	AMZN	Stock	2.6965	2.701	2.6765	2.6825	18262560.0
2004-07-01 10:00:00	AMZN	Stock	2.6825	2.683	2.6405	2.66	28760400.0
2004-07-01 11:00:00	AMZN	Stock	2.6595	2.6645	2.641	2.6545	16254700.0
2004-07-01 12:00:00	AMZN	Stock	2.6555	2.6585	2.64	2.641	9976140.0
2004-07-01 13:00:00	AMZN	Stock	2.6415	2.647	2.6205	2.6205	17124380.0
2004-07-01 14:00:00	AMZN	Stock	2.6205	2.6385	2.6025	2.617	24604820.0
2004-07-01 15:00:00	AMZN	Stock	2.615	2.6335	2.61	2.63	20229780.0
2004-07-01 16:00:00	AMZN	Stock	2.63	2.63	2.62	2.6258	2271460.0
2004-07-01 17:00:00	AMZN	Stock	2.6235	2.6895	2.6175	2.628	242720.0
2004-07-01 09:00:00	CL	Stock	29.3	29.395	29.3	29.35	365200.0
2004-07-01 10:00:00	CL	Stock	29.36	29.485	29.335	29.41	598000.0
2004-07-01 11:00:00	CL	Stock	29.415	29.415	29.32	29.365	737200.0
2004-07-01 12:00:00	CL	Stock	29.35	29.45	29.35	29.445	516800.0
2004-07-01 13:00:00	CL	Stock	29.445	29.47	29.375	29.385	344000.0
2004-07-01 14:00:00	CL	Stock	29.375	29.43	29.34	29.375	552200.0
2004-07-01 15:00:00	CL	Stock	29.37	29.43	29.35	29.355	625600.0

> showing 50 of 24,455 rows — these rows as CSV

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