PREVIEW / stock_1hour / 2004-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-02.parquet
  size:    495 KB
  rows:    23,902
  symbols: 1,826

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-08-02 08:00:00	AAPL	Stock	0.5536	0.5716	0.5536	0.5607	2033920.0
2004-08-02 09:00:00	AAPL	Stock	0.5614	0.575	0.5559	0.5713	69651456.0
2004-08-02 10:00:00	AAPL	Stock	0.5713	0.5714	0.5636	0.5641	54569144.0
2004-08-02 11:00:00	AAPL	Stock	0.5641	0.5655	0.5636	0.5643	33074776.0
2004-08-02 12:00:00	AAPL	Stock	0.5641	0.5648	0.5634	0.5636	18475688.0
2004-08-02 13:00:00	AAPL	Stock	0.5638	0.5668	0.5636	0.5654	39908288.0
2004-08-02 14:00:00	AAPL	Stock	0.5652	0.5663	0.5625	0.5625	54044536.0
2004-08-02 15:00:00	AAPL	Stock	0.5625	0.5668	0.5616	0.5639	70814240.0
2004-08-02 16:00:00	AAPL	Stock	0.5629	0.5643	0.5625	0.5634	4328800.0
2004-08-02 17:00:00	AAPL	Stock	0.5639	0.5639	0.5639	0.5639	1724800.0
2004-08-02 08:00:00	MSFT	Stock	28.3	28.5	28.25	28.26	97616.0
2004-08-02 09:00:00	MSFT	Stock	28.3	28.44	28.24	28.26	5377435.0
2004-08-02 10:00:00	MSFT	Stock	28.26	28.39	28.16	28.25	9223457.0
2004-08-02 11:00:00	MSFT	Stock	28.26	28.4	28.24	28.39	5390366.0
2004-08-02 12:00:00	MSFT	Stock	28.4	28.4	28.31	28.32	4242991.0
2004-08-02 13:00:00	MSFT	Stock	28.319	28.44	28.319	28.368	4701414.0
2004-08-02 14:00:00	MSFT	Stock	28.36	28.43	28.32	28.33	7805309.0
2004-08-02 15:00:00	MSFT	Stock	28.33	28.55	28.32	28.52	11473153.0
2004-08-02 16:00:00	MSFT	Stock	28.52	28.61	28.44	28.52	743549.0
2004-08-02 17:00:00	MSFT	Stock	28.52	28.56	28.52	28.55	44350.0
2004-08-02 18:00:00	MSFT	Stock	28.56	28.57	28.55	28.55	6274.0
2004-08-02 08:00:00	NVDA	Stock	0.1259	0.1286	0.1254	0.1286	1620000.0
2004-08-02 09:00:00	NVDA	Stock	0.1273	0.129	0.1261	0.129	42277320.0
2004-08-02 10:00:00	NVDA	Stock	0.129	0.1301	0.1277	0.1293	111868080.0
2004-08-02 11:00:00	NVDA	Stock	0.1292	0.1293	0.1273	0.1286	63490560.0
2004-08-02 12:00:00	NVDA	Stock	0.1286	0.1288	0.1278	0.1285	24980760.0
2004-08-02 13:00:00	NVDA	Stock	0.1286	0.13	0.1284	0.1294	33450360.0
2004-08-02 14:00:00	NVDA	Stock	0.1295	0.1297	0.1288	0.1289	29066400.0
2004-08-02 15:00:00	NVDA	Stock	0.129	0.1307	0.1288	0.1295	79672800.0
2004-08-02 16:00:00	NVDA	Stock	0.1295	0.1304	0.1293	0.1297	4782120.0
2004-08-02 17:00:00	NVDA	Stock	0.1295	0.1302	0.1295	0.1302	548760.0
2004-08-02 08:00:00	AMZN	Stock	1.925	1.9465	1.9175	1.9175	302860.0
2004-08-02 09:00:00	AMZN	Stock	1.9175	1.928	1.8905	1.918	19034040.0
2004-08-02 10:00:00	AMZN	Stock	1.9185	1.938	1.907	1.9125	21768400.0
2004-08-02 11:00:00	AMZN	Stock	1.9125	1.9135	1.9035	1.9075	10374540.0
2004-08-02 12:00:00	AMZN	Stock	1.9075	1.9095	1.8995	1.9005	11624980.0
2004-08-02 13:00:00	AMZN	Stock	1.9	1.9155	1.8955	1.9085	13165840.0
2004-08-02 14:00:00	AMZN	Stock	1.9075	1.9095	1.895	1.896	13232440.0
2004-08-02 15:00:00	AMZN	Stock	1.896	1.9155	1.8925	1.9155	23858680.0
2004-08-02 16:00:00	AMZN	Stock	1.9155	1.9155	1.9075	1.9145	1145860.0
2004-08-02 17:00:00	AMZN	Stock	1.915	1.915	1.907	1.907	476920.0
2004-08-02 18:00:00	AMZN	Stock	1.907	1.907	1.907	1.907	24000.0
2004-08-02 09:00:00	CL	Stock	26.605	26.78	26.58	26.7	366000.0
2004-08-02 10:00:00	CL	Stock	26.7	26.74	26.615	26.725	676600.0
2004-08-02 11:00:00	CL	Stock	26.725	26.775	26.7	26.735	387400.0
2004-08-02 12:00:00	CL	Stock	26.74	26.74	26.64	26.655	154600.0
2004-08-02 13:00:00	CL	Stock	26.655	26.73	26.65	26.685	190200.0
2004-08-02 14:00:00	CL	Stock	26.685	26.7	26.6	26.605	298400.0
2004-08-02 15:00:00	CL	Stock	26.61	26.685	26.605	26.665	525200.0

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

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