PREVIEW / stock_1hour / 2002-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-06.parquet
  size:    422 KB
  rows:    19,677
  symbols: 1,494

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-11-06 08:00:00	AAPL	Stock	0.3063	0.3063	0.3013	0.3013	112000.0
2002-11-06 09:00:00	AAPL	Stock	0.3013	0.3054	0.3	0.3012	15236088.0
2002-11-06 10:00:00	AAPL	Stock	0.3009	0.3093	0.3	0.3073	43351672.0
2002-11-06 11:00:00	AAPL	Stock	0.3075	0.3093	0.3038	0.3043	16169720.0
2002-11-06 12:00:00	AAPL	Stock	0.3045	0.3045	0.3018	0.3036	11562040.0
2002-11-06 13:00:00	AAPL	Stock	0.3039	0.3048	0.3013	0.3018	15609328.0
2002-11-06 14:00:00	AAPL	Stock	0.3021	0.3073	0.2982	0.3057	53978008.0
2002-11-06 15:00:00	AAPL	Stock	0.3055	0.308	0.3034	0.3075	42471800.0
2002-11-06 16:00:00	AAPL	Stock	0.3073	0.3107	0.3034	0.3073	5885600.0
2002-11-06 17:00:00	AAPL	Stock	0.3075	0.3075	0.292	0.292	1103536.0
2002-11-06 18:00:00	AAPL	Stock	0.3045	0.3045	0.3036	0.3036	123200.0
2002-11-06 08:00:00	MSFT	Stock	28.525	28.625	28.396	28.445	276238.0
2002-11-06 09:00:00	MSFT	Stock	28.45	28.52	28.325	28.381	12751918.0
2002-11-06 10:00:00	MSFT	Stock	28.3905	28.525	28.28	28.455	12397374.0
2002-11-06 11:00:00	MSFT	Stock	28.46	28.506	28.175	28.18	9579214.0
2002-11-06 12:00:00	MSFT	Stock	28.185	28.2205	27.927	28.075	17743458.0
2002-11-06 13:00:00	MSFT	Stock	28.075	28.145	27.975	27.98	6193850.0
2002-11-06 14:00:00	MSFT	Stock	27.99	28.505	27.765	28.4205	26909172.0
2002-11-06 15:00:00	MSFT	Stock	28.42	28.552	28.14	28.505	18761288.0
2002-11-06 16:00:00	MSFT	Stock	28.505	28.635	27.801	28.525	2721606.0
2002-11-06 17:00:00	MSFT	Stock	28.51	28.605	28.2	28.225	474244.0
2002-11-06 18:00:00	MSFT	Stock	28.24	28.515	28.125	28.15	45100.0
2002-11-06 08:00:00	NVDA	Stock	0.1292	0.1333	0.1276	0.1292	9078600.0
2002-11-06 09:00:00	NVDA	Stock	0.1292	0.1302	0.1248	0.1264	211933440.0
2002-11-06 10:00:00	NVDA	Stock	0.1265	0.1299	0.1257	0.1292	245308560.0
2002-11-06 11:00:00	NVDA	Stock	0.1292	0.1313	0.1271	0.1278	161508720.0
2002-11-06 12:00:00	NVDA	Stock	0.1278	0.1283	0.1264	0.1283	130488720.0
2002-11-06 13:00:00	NVDA	Stock	0.1283	0.129	0.1273	0.1279	75791160.0
2002-11-06 14:00:00	NVDA	Stock	0.1279	0.1329	0.1243	0.1282	381673200.0
2002-11-06 15:00:00	NVDA	Stock	0.1282	0.135	0.1279	0.1347	276183240.0
2002-11-06 16:00:00	NVDA	Stock	0.1347	0.1371	0.1274	0.1366	59290800.0
2002-11-06 17:00:00	NVDA	Stock	0.1366	0.1372	0.1308	0.1317	12177840.0
2002-11-06 18:00:00	NVDA	Stock	0.1317	0.1333	0.1308	0.1308	2793600.0
2002-11-06 08:00:00	AMZN	Stock	0.9375	0.949	0.9375	0.941	324000.0
2002-11-06 09:00:00	AMZN	Stock	0.941	0.9445	0.93	0.9302	12355660.0
2002-11-06 10:00:00	AMZN	Stock	0.93	0.938	0.9255	0.9345	16500400.0
2002-11-06 11:00:00	AMZN	Stock	0.933	0.9365	0.922	0.923	10890680.0
2002-11-06 12:00:00	AMZN	Stock	0.923	0.9302	0.913	0.929	18252680.0
2002-11-06 13:00:00	AMZN	Stock	0.9285	0.9325	0.925	0.9312	17543460.0
2002-11-06 14:00:00	AMZN	Stock	0.9305	0.9545	0.92	0.9535	33004480.0
2002-11-06 15:00:00	AMZN	Stock	0.953	0.9695	0.951	0.966	36119400.0
2002-11-06 16:00:00	AMZN	Stock	0.9675	0.9735	0.9575	0.965	3092800.0
2002-11-06 17:00:00	AMZN	Stock	0.967	0.967	0.95	0.9595	944000.0
2002-11-06 18:00:00	AMZN	Stock	0.9505	0.9595	0.9505	0.9595	80000.0
2002-11-06 09:00:00	CL	Stock	27.175	27.195	26.975	27.0	308400.0
2002-11-06 10:00:00	CL	Stock	26.99	27.12	26.95	27.05	466400.0
2002-11-06 11:00:00	CL	Stock	27.05	27.125	26.97	27.0	594000.0
2002-11-06 12:00:00	CL	Stock	27.0	27.0	26.775	26.785	291000.0
2002-11-06 13:00:00	CL	Stock	26.8	26.815	26.69	26.815	407400.0
2002-11-06 14:00:00	CL	Stock	26.825	26.875	26.475	26.57	1275400.0

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

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