PREVIEW / stock_1hour / 2004-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-17.parquet
  size:    486 KB
  rows:    23,260
  symbols: 1,827

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-17 08:00:00	AAPL	Stock	0.5505	0.5513	0.5495	0.5498	2404920.0
2004-08-17 09:00:00	AAPL	Stock	0.5488	0.5511	0.542	0.5488	58867592.0
2004-08-17 10:00:00	AAPL	Stock	0.5486	0.5527	0.5452	0.5471	55654088.0
2004-08-17 11:00:00	AAPL	Stock	0.547	0.5539	0.5455	0.5511	47468848.0
2004-08-17 12:00:00	AAPL	Stock	0.5511	0.5559	0.5511	0.5546	24737776.0
2004-08-17 13:00:00	AAPL	Stock	0.5548	0.5559	0.5529	0.5534	31633056.0
2004-08-17 14:00:00	AAPL	Stock	0.5536	0.5538	0.55	0.5523	34207488.0
2004-08-17 15:00:00	AAPL	Stock	0.5523	0.5523	0.5484	0.5507	41819400.0
2004-08-17 16:00:00	AAPL	Stock	0.5509	0.5516	0.5496	0.5513	4300296.0
2004-08-17 17:00:00	AAPL	Stock	0.5511	0.5511	0.5511	0.5511	56000.0
2004-08-17 18:00:00	AAPL	Stock	0.5495	0.5495	0.5493	0.5493	11200.0
2004-08-17 08:00:00	MSFT	Stock	27.19	27.23	27.09	27.2	54357.0
2004-08-17 09:00:00	MSFT	Stock	27.21	27.38	27.09	27.3	7511972.0
2004-08-17 10:00:00	MSFT	Stock	27.3	27.3	27.109	27.13	7324055.0
2004-08-17 11:00:00	MSFT	Stock	27.13	27.15	27.03	27.09	6150474.0
2004-08-17 12:00:00	MSFT	Stock	27.09	27.12	27.04	27.1	3962151.0
2004-08-17 13:00:00	MSFT	Stock	27.1	27.12	27.02	27.07	4634612.0
2004-08-17 14:00:00	MSFT	Stock	27.06	27.1	26.99	27.06	5738004.0
2004-08-17 15:00:00	MSFT	Stock	27.06	27.09	26.98	27.04	7961412.0
2004-08-17 16:00:00	MSFT	Stock	27.04	27.1	27.0178	27.05	11700714.0
2004-08-17 17:00:00	MSFT	Stock	27.05	27.08	27.03	27.08	13300.0
2004-08-17 18:00:00	MSFT	Stock	27.08	27.08	27.08	27.08	800.0
2004-08-17 08:00:00	NVDA	Stock	0.0875	0.0883	0.0869	0.0879	777600.0
2004-08-17 09:00:00	NVDA	Stock	0.0879	0.0898	0.0873	0.0896	125313240.0
2004-08-17 10:00:00	NVDA	Stock	0.0896	0.0913	0.0889	0.0907	172459800.0
2004-08-17 11:00:00	NVDA	Stock	0.0908	0.0912	0.0904	0.0911	94732080.0
2004-08-17 12:00:00	NVDA	Stock	0.0911	0.0919	0.0907	0.0911	72965520.0
2004-08-17 13:00:00	NVDA	Stock	0.0911	0.0919	0.0907	0.0915	70749240.0
2004-08-17 14:00:00	NVDA	Stock	0.0914	0.0915	0.0908	0.0912	55559760.0
2004-08-17 15:00:00	NVDA	Stock	0.0912	0.0917	0.0909	0.0914	127004760.0
2004-08-17 16:00:00	NVDA	Stock	0.0914	0.0937	0.0912	0.0922	6203280.0
2004-08-17 17:00:00	NVDA	Stock	0.0924	0.0929	0.0924	0.0929	180000.0
2004-08-17 18:00:00	NVDA	Stock	0.0922	0.0922	0.0922	0.0922	240000.0
2004-08-17 08:00:00	AMZN	Stock	1.925	1.9275	1.9025	1.9275	248000.0
2004-08-17 09:00:00	AMZN	Stock	1.9275	1.95	1.921	1.949	31726720.0
2004-08-17 10:00:00	AMZN	Stock	1.948	1.972	1.9395	1.9605	44856000.0
2004-08-17 11:00:00	AMZN	Stock	1.9601	1.963	1.9225	1.9255	43729320.0
2004-08-17 12:00:00	AMZN	Stock	1.925	1.9435	1.921	1.939	16272460.0
2004-08-17 13:00:00	AMZN	Stock	1.939	1.943	1.9325	1.94	9857640.0
2004-08-17 14:00:00	AMZN	Stock	1.94	1.942	1.914	1.914	18325220.0
2004-08-17 15:00:00	AMZN	Stock	1.9155	1.9195	1.895	1.9085	41406400.0
2004-08-17 16:00:00	AMZN	Stock	1.909	1.919	1.9055	1.919	7665060.0
2004-08-17 17:00:00	AMZN	Stock	1.9145	1.9185	1.9115	1.9185	114060.0
2004-08-17 18:00:00	AMZN	Stock	1.915	1.915	1.915	1.915	8000.0
2004-08-17 09:00:00	CL	Stock	26.075	26.125	25.825	25.89	249400.0
2004-08-17 10:00:00	CL	Stock	25.89	25.9	25.75	25.83	449400.0
2004-08-17 11:00:00	CL	Stock	25.83	25.865	25.765	25.815	376400.0
2004-08-17 12:00:00	CL	Stock	25.815	25.86	25.785	25.845	165800.0
2004-08-17 13:00:00	CL	Stock	25.845	25.85	25.775	25.845	166000.0
2004-08-17 14:00:00	CL	Stock	25.84	25.845	25.79	25.83	344600.0

> showing 50 of 23,260 rows — these rows as CSV

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