PREVIEW / stock_1hour / 2002-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-09.parquet
  size:    410 KB
  rows:    19,115
  symbols: 1,448

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-09 08:00:00	AAPL	Stock	0.3218	0.3218	0.318	0.3182	134400.0
2002-07-09 09:00:00	AAPL	Stock	0.3209	0.3252	0.3198	0.3223	34361600.0
2002-07-09 10:00:00	AAPL	Stock	0.3221	0.3227	0.3118	0.3223	57472800.0
2002-07-09 11:00:00	AAPL	Stock	0.3225	0.3266	0.3164	0.3179	22456000.0
2002-07-09 12:00:00	AAPL	Stock	0.3179	0.3232	0.3168	0.3214	12521600.0
2002-07-09 13:00:00	AAPL	Stock	0.3216	0.3243	0.3182	0.3191	23990400.0
2002-07-09 14:00:00	AAPL	Stock	0.3207	0.3214	0.315	0.3171	20714400.0
2002-07-09 15:00:00	AAPL	Stock	0.3171	0.32	0.3129	0.3129	34832000.0
2002-07-09 16:00:00	AAPL	Stock	0.313	0.3197	0.3125	0.3125	13568800.0
2002-07-09 17:00:00	AAPL	Stock	0.3125	0.313	0.3125	0.313	1960000.0
2002-07-09 08:00:00	MSFT	Stock	26.45	26.716	26.39	26.625	203200.0
2002-07-09 09:00:00	MSFT	Stock	26.636	27.07	26.565	26.98	10705800.0
2002-07-09 10:00:00	MSFT	Stock	26.985	27.245	26.536	27.16	15488400.0
2002-07-09 11:00:00	MSFT	Stock	27.16	27.365	26.87	26.9925	11304800.0
2002-07-09 12:00:00	MSFT	Stock	26.99	27.265	26.915	27.1	8236800.0
2002-07-09 13:00:00	MSFT	Stock	27.1	27.28	26.98	27.055	7277000.0
2002-07-09 14:00:00	MSFT	Stock	27.06	27.11	26.77	26.845	11235600.0
2002-07-09 15:00:00	MSFT	Stock	26.835	26.985	26.485	26.615	13884800.0
2002-07-09 16:00:00	MSFT	Stock	26.61	26.9744	26.55	26.65	3960600.0
2002-07-09 17:00:00	MSFT	Stock	26.66	26.955	26.605	26.655	399000.0
2002-07-09 18:00:00	MSFT	Stock	26.655	26.705	26.655	26.655	9600.0
2002-07-09 08:00:00	NVDA	Stock	0.1615	0.1637	0.1601	0.163	3588000.0
2002-07-09 09:00:00	NVDA	Stock	0.1621	0.1655	0.1592	0.1616	179844000.0
2002-07-09 10:00:00	NVDA	Stock	0.1616	0.1616	0.1575	0.159	188292000.0
2002-07-09 11:00:00	NVDA	Stock	0.159	0.1623	0.1585	0.1593	129588000.0
2002-07-09 12:00:00	NVDA	Stock	0.1591	0.1601	0.1587	0.1596	82248000.0
2002-07-09 13:00:00	NVDA	Stock	0.1595	0.1603	0.1567	0.1572	84408000.0
2002-07-09 14:00:00	NVDA	Stock	0.1575	0.1579	0.1515	0.1539	182364000.0
2002-07-09 15:00:00	NVDA	Stock	0.1538	0.1562	0.1532	0.1552	161520000.0
2002-07-09 16:00:00	NVDA	Stock	0.155	0.1582	0.1542	0.1554	46296000.0
2002-07-09 17:00:00	NVDA	Stock	0.155	0.1557	0.155	0.1557	2064000.0
2002-07-09 18:00:00	NVDA	Stock	0.1552	0.1555	0.155	0.1555	192000.0
2002-07-09 08:00:00	AMZN	Stock	0.7478	0.7505	0.7478	0.748	66000.0
2002-07-09 09:00:00	AMZN	Stock	0.7485	0.775	0.747	0.762	22538000.0
2002-07-09 10:00:00	AMZN	Stock	0.7616	0.785	0.7494	0.783	23654000.0
2002-07-09 11:00:00	AMZN	Stock	0.783	0.791	0.7775	0.78	18906000.0
2002-07-09 12:00:00	AMZN	Stock	0.78	0.7985	0.7775	0.795	16838000.0
2002-07-09 13:00:00	AMZN	Stock	0.795	0.8015	0.788	0.7895	15958000.0
2002-07-09 14:00:00	AMZN	Stock	0.7895	0.7915	0.7785	0.78	17558000.0
2002-07-09 15:00:00	AMZN	Stock	0.78	0.7845	0.7675	0.78	28096000.0
2002-07-09 16:00:00	AMZN	Stock	0.7805	0.7805	0.7725	0.776	1888000.0
2002-07-09 17:00:00	AMZN	Stock	0.775	0.78	0.775	0.7795	438000.0
2002-07-09 18:00:00	AMZN	Stock	0.7795	0.7795	0.775	0.775	40000.0
2002-07-09 09:00:00	CL	Stock	25.45	25.625	25.43	25.585	294800.0
2002-07-09 10:00:00	CL	Stock	25.585	25.59	25.445	25.445	512200.0
2002-07-09 11:00:00	CL	Stock	25.43	25.475	25.2	25.26	524200.0
2002-07-09 12:00:00	CL	Stock	25.255	25.31	25.14	25.215	389600.0
2002-07-09 13:00:00	CL	Stock	25.22	25.305	25.175	25.255	332600.0
2002-07-09 14:00:00	CL	Stock	25.22	25.235	25.08	25.105	462600.0
2002-07-09 15:00:00	CL	Stock	25.1	25.105	24.925	24.95	816600.0

> showing 50 of 19,115 rows — these rows as CSV

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