PREVIEW / stock_1hour / 2002-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-16.parquet
  size:    398 KB
  rows:    18,857
  symbols: 1,451

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-16 08:00:00	AAPL	Stock	0.3205	0.3214	0.3205	0.3214	72800.0
2002-07-16 09:00:00	AAPL	Stock	0.3232	0.3296	0.3214	0.3268	43584800.0
2002-07-16 10:00:00	AAPL	Stock	0.3271	0.3316	0.3259	0.3288	89902400.0
2002-07-16 11:00:00	AAPL	Stock	0.3288	0.3304	0.3246	0.3282	73673600.0
2002-07-16 12:00:00	AAPL	Stock	0.3282	0.3304	0.3254	0.3286	31836000.0
2002-07-16 13:00:00	AAPL	Stock	0.3286	0.3288	0.3198	0.3234	44111200.0
2002-07-16 14:00:00	AAPL	Stock	0.3234	0.3255	0.3214	0.3231	34916000.0
2002-07-16 15:00:00	AAPL	Stock	0.3227	0.3227	0.3145	0.3188	58396800.0
2002-07-16 16:00:00	AAPL	Stock	0.3187	0.3204	0.2906	0.2929	32356800.0
2002-07-16 17:00:00	AAPL	Stock	0.2932	0.3259	0.2893	0.2902	10376800.0
2002-07-16 18:00:00	AAPL	Stock	0.2902	0.3265	0.29	0.2927	1204000.0
2002-07-16 08:00:00	MSFT	Stock	25.65	25.825	25.5	25.76	139600.0
2002-07-16 09:00:00	MSFT	Stock	25.755	26.015	25.595	25.6615	12903400.0
2002-07-16 10:00:00	MSFT	Stock	25.67	26.075	25.32	26.065	18376400.0
2002-07-16 11:00:00	MSFT	Stock	26.065	26.35	25.705	26.135	14345800.0
2002-07-16 12:00:00	MSFT	Stock	26.1495	26.4	25.9	26.295	10177000.0
2002-07-16 13:00:00	MSFT	Stock	26.285	26.375	25.6105	25.705	13264000.0
2002-07-16 14:00:00	MSFT	Stock	25.725	25.98	25.63	25.8	10038200.0
2002-07-16 15:00:00	MSFT	Stock	25.8	25.815	25.36	25.625	13696800.0
2002-07-16 16:00:00	MSFT	Stock	25.64	25.67	25.125	25.4	2474600.0
2002-07-16 17:00:00	MSFT	Stock	25.4	25.875	25.37	25.55	512600.0
2002-07-16 18:00:00	MSFT	Stock	26.1325	26.1325	25.545	25.575	112400.0
2002-07-16 08:00:00	NVDA	Stock	0.1823	0.1823	0.1777	0.1787	1524000.0
2002-07-16 09:00:00	NVDA	Stock	0.1787	0.1831	0.1776	0.1807	168624000.0
2002-07-16 10:00:00	NVDA	Stock	0.1807	0.1912	0.1792	0.1911	297564000.0
2002-07-16 11:00:00	NVDA	Stock	0.1914	0.1946	0.1865	0.192	295644000.0
2002-07-16 12:00:00	NVDA	Stock	0.1918	0.1928	0.1881	0.1904	130752000.0
2002-07-16 13:00:00	NVDA	Stock	0.1902	0.1904	0.1801	0.1812	277332000.0
2002-07-16 14:00:00	NVDA	Stock	0.1813	0.1849	0.1801	0.1803	265704000.0
2002-07-16 15:00:00	NVDA	Stock	0.1803	0.1803	0.1746	0.1779	298044000.0
2002-07-16 16:00:00	NVDA	Stock	0.1779	0.179	0.1721	0.1741	12396000.0
2002-07-16 17:00:00	NVDA	Stock	0.174	0.1792	0.174	0.1754	4644000.0
2002-07-16 18:00:00	NVDA	Stock	0.1758	0.1775	0.1757	0.1758	684000.0
2002-07-16 08:00:00	AMZN	Stock	0.7988	0.7988	0.7915	0.7915	1472000.0
2002-07-16 09:00:00	AMZN	Stock	0.79	0.811	0.783	0.8015	16626000.0
2002-07-16 10:00:00	AMZN	Stock	0.8015	0.8225	0.7906	0.813	43048000.0
2002-07-16 11:00:00	AMZN	Stock	0.813	0.8465	0.8115	0.8455	38434000.0
2002-07-16 12:00:00	AMZN	Stock	0.8455	0.8539	0.8385	0.8485	36322000.0
2002-07-16 13:00:00	AMZN	Stock	0.8485	0.8515	0.8335	0.834	21164000.0
2002-07-16 14:00:00	AMZN	Stock	0.834	0.8385	0.8275	0.834	20988000.0
2002-07-16 15:00:00	AMZN	Stock	0.834	0.834	0.81	0.8165	31054000.0
2002-07-16 16:00:00	AMZN	Stock	0.8145	0.82	0.8125	0.8125	2316000.0
2002-07-16 17:00:00	AMZN	Stock	0.813	0.813	0.813	0.813	68000.0
2002-07-16 18:00:00	AMZN	Stock	0.8145	0.8145	0.8145	0.8145	16000.0
2002-07-16 09:00:00	CL	Stock	24.125	24.15	23.75	23.76	320800.0
2002-07-16 10:00:00	CL	Stock	23.77	23.79	23.215	23.665	557600.0
2002-07-16 11:00:00	CL	Stock	23.66	24.055	23.66	23.97	744000.0
2002-07-16 12:00:00	CL	Stock	23.995	24.06	23.725	24.03	326800.0
2002-07-16 13:00:00	CL	Stock	24.01	24.075	23.65	23.68	368400.0
2002-07-16 14:00:00	CL	Stock	23.68	24.065	23.675	24.005	374800.0

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

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