PREVIEW / stock_1hour / 2002-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-18.parquet
  size:    387 KB
  rows:    18,485
  symbols: 1,437

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
2002-07-18 08:00:00	AAPL	Stock	0.2813	0.2841	0.275	0.2786	324800.0
2002-07-18 09:00:00	AAPL	Stock	0.2795	0.2795	0.2721	0.2757	57607200.0
2002-07-18 10:00:00	AAPL	Stock	0.2755	0.2759	0.268	0.2681	111574400.0
2002-07-18 11:00:00	AAPL	Stock	0.268	0.2716	0.2675	0.2702	72156000.0
2002-07-18 12:00:00	AAPL	Stock	0.2702	0.2713	0.2689	0.2696	37273600.0
2002-07-18 13:00:00	AAPL	Stock	0.2695	0.2707	0.268	0.268	37822400.0
2002-07-18 14:00:00	AAPL	Stock	0.2684	0.2686	0.2648	0.2655	62608000.0
2002-07-18 15:00:00	AAPL	Stock	0.2654	0.2688	0.2634	0.2675	107055200.0
2002-07-18 16:00:00	AAPL	Stock	0.2677	0.2684	0.267	0.2677	12241600.0
2002-07-18 17:00:00	AAPL	Stock	0.2677	0.2677	0.2677	0.2677	162400.0
2002-07-18 08:00:00	MSFT	Stock	25.985	26.165	25.875	26.075	61400.0
2002-07-18 09:00:00	MSFT	Stock	26.075	26.15	25.68	25.785	9754400.0
2002-07-18 10:00:00	MSFT	Stock	25.78	25.945	25.615	25.825	12970200.0
2002-07-18 11:00:00	MSFT	Stock	25.825	26.11	25.805	26.0865	8748600.0
2002-07-18 12:00:00	MSFT	Stock	26.06	26.37	25.98	26.018	5592200.0
2002-07-18 13:00:00	MSFT	Stock	26.015	26.21	25.875	25.99	6167200.0
2002-07-18 14:00:00	MSFT	Stock	25.99	26.015	25.48	25.56	10360200.0
2002-07-18 15:00:00	MSFT	Stock	25.59	25.665	25.33	25.555	17665800.0
2002-07-18 16:00:00	MSFT	Stock	25.56	26.0	24.9	25.425	7177000.0
2002-07-18 17:00:00	MSFT	Stock	25.4	26.0798	25.25	25.365	1218600.0
2002-07-18 18:00:00	MSFT	Stock	25.37	25.44	25.27	25.3	207600.0
2002-07-18 08:00:00	NVDA	Stock	0.1592	0.1628	0.1583	0.1617	2316000.0
2002-07-18 09:00:00	NVDA	Stock	0.1596	0.1621	0.1581	0.1599	174516000.0
2002-07-18 10:00:00	NVDA	Stock	0.1603	0.1656	0.1593	0.1646	219012000.0
2002-07-18 11:00:00	NVDA	Stock	0.1646	0.1683	0.1634	0.1677	146544000.0
2002-07-18 12:00:00	NVDA	Stock	0.1677	0.1692	0.1635	0.1637	64812000.0
2002-07-18 13:00:00	NVDA	Stock	0.1637	0.1657	0.1613	0.1635	76428000.0
2002-07-18 14:00:00	NVDA	Stock	0.1635	0.1635	0.1599	0.1608	92040000.0
2002-07-18 15:00:00	NVDA	Stock	0.1607	0.1615	0.1578	0.1582	281568000.0
2002-07-18 16:00:00	NVDA	Stock	0.1583	0.1587	0.1545	0.1557	18408000.0
2002-07-18 17:00:00	NVDA	Stock	0.156	0.1592	0.1559	0.1565	3864000.0
2002-07-18 18:00:00	NVDA	Stock	0.1565	0.1567	0.1562	0.1562	684000.0
2002-07-18 08:00:00	AMZN	Stock	0.8025	0.808	0.8	0.8	760000.0
2002-07-18 09:00:00	AMZN	Stock	0.8	0.8095	0.785	0.8005	11954000.0
2002-07-18 10:00:00	AMZN	Stock	0.8001	0.828	0.7985	0.8175	30210000.0
2002-07-18 11:00:00	AMZN	Stock	0.8175	0.8295	0.815	0.8205	18302000.0
2002-07-18 12:00:00	AMZN	Stock	0.8215	0.8245	0.8125	0.8135	4384000.0
2002-07-18 13:00:00	AMZN	Stock	0.8135	0.8206	0.812	0.8175	8086000.0
2002-07-18 14:00:00	AMZN	Stock	0.8175	0.8195	0.8	0.8015	17670000.0
2002-07-18 15:00:00	AMZN	Stock	0.802	0.809	0.7765	0.778	28078000.0
2002-07-18 16:00:00	AMZN	Stock	0.781	0.7865	0.775	0.778	3462000.0
2002-07-18 17:00:00	AMZN	Stock	0.7775	0.78	0.775	0.78	178000.0
2002-07-18 18:00:00	AMZN	Stock	0.7805	0.7805	0.78	0.78	30000.0
2002-07-18 09:00:00	CL	Stock	23.625	23.75	23.6	23.725	376200.0
2002-07-18 10:00:00	CL	Stock	23.72	24.025	23.7	23.84	619600.0
2002-07-18 11:00:00	CL	Stock	23.84	23.875	23.605	23.775	633600.0
2002-07-18 12:00:00	CL	Stock	23.765	23.765	23.5	23.505	762600.0
2002-07-18 13:00:00	CL	Stock	23.505	23.55	23.325	23.425	362600.0
2002-07-18 14:00:00	CL	Stock	23.425	23.425	23.01	23.03	569600.0
2002-07-18 15:00:00	CL	Stock	23.045	23.24	23.035	23.035	736800.0

> showing 50 of 18,485 rows — these rows as CSV

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