PREVIEW / stock_1hour / 2001-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-10-18.parquet
  size:    359 KB
  rows:    17,225
  symbols: 1,333

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
2001-10-18 08:00:00	AAPL	Stock	0.3071	0.308	0.3027	0.3036	6188000.0
2001-10-18 09:00:00	AAPL	Stock	0.3036	0.3252	0.3018	0.3189	92332800.0
2001-10-18 10:00:00	AAPL	Stock	0.3189	0.3255	0.3159	0.3209	125277600.0
2001-10-18 11:00:00	AAPL	Stock	0.3213	0.3255	0.3196	0.3211	106965600.0
2001-10-18 12:00:00	AAPL	Stock	0.3209	0.3218	0.3179	0.3188	49061600.0
2001-10-18 13:00:00	AAPL	Stock	0.3188	0.3196	0.3154	0.3173	85136800.0
2001-10-18 14:00:00	AAPL	Stock	0.3175	0.3214	0.3161	0.3191	52236800.0
2001-10-18 15:00:00	AAPL	Stock	0.3189	0.323	0.3188	0.3214	67967200.0
2001-10-18 16:00:00	AAPL	Stock	0.3214	0.3239	0.32	0.323	5807200.0
2001-10-18 17:00:00	AAPL	Stock	0.3243	0.3243	0.3214	0.3214	89600.0
2001-10-18 08:00:00	MSFT	Stock	28.0	28.225	28.0	28.225	52000.0
2001-10-18 09:00:00	MSFT	Stock	28.225	28.33	27.75	28.095	8377600.0
2001-10-18 10:00:00	MSFT	Stock	28.08	28.6	27.9695	28.56	11705600.0
2001-10-18 11:00:00	MSFT	Stock	28.575	28.79	28.3	28.36	10314000.0
2001-10-18 12:00:00	MSFT	Stock	28.355	28.5	28.075	28.11	7224600.0
2001-10-18 13:00:00	MSFT	Stock	28.11	28.265	27.95	28.1305	5549000.0
2001-10-18 14:00:00	MSFT	Stock	28.135	28.485	28.09	28.295	10459400.0
2001-10-18 15:00:00	MSFT	Stock	28.2951	28.5	28.13	28.375	12055000.0
2001-10-18 16:00:00	MSFT	Stock	28.4	29.22	27.5	28.835	8857400.0
2001-10-18 17:00:00	MSFT	Stock	28.81	28.905	28.525	28.675	783600.0
2001-10-18 18:00:00	MSFT	Stock	28.675	28.975	28.445	28.47	145000.0
2001-10-18 08:00:00	NVDA	Stock	0.3467	0.3492	0.3466	0.3481	1176000.0
2001-10-18 09:00:00	NVDA	Stock	0.3484	0.3583	0.3462	0.3503	167076000.0
2001-10-18 10:00:00	NVDA	Stock	0.3501	0.3609	0.3482	0.3537	176100000.0
2001-10-18 11:00:00	NVDA	Stock	0.3536	0.3624	0.3517	0.356	103464000.0
2001-10-18 12:00:00	NVDA	Stock	0.3562	0.3583	0.3512	0.3517	71520000.0
2001-10-18 13:00:00	NVDA	Stock	0.352	0.357	0.3476	0.357	101304000.0
2001-10-18 14:00:00	NVDA	Stock	0.357	0.3633	0.3554	0.3576	156240000.0
2001-10-18 15:00:00	NVDA	Stock	0.3575	0.3656	0.3563	0.3621	158232000.0
2001-10-18 16:00:00	NVDA	Stock	0.3622	0.3675	0.3551	0.3654	13488000.0
2001-10-18 17:00:00	NVDA	Stock	0.3642	0.3682	0.3617	0.365	1668000.0
2001-10-18 18:00:00	NVDA	Stock	0.3646	0.3664	0.3583	0.3617	1140000.0
2001-10-18 08:00:00	AMZN	Stock	0.44	0.4475	0.44	0.445	206000.0
2001-10-18 09:00:00	AMZN	Stock	0.445	0.453	0.423	0.4405	15416000.0
2001-10-18 10:00:00	AMZN	Stock	0.4395	0.446	0.4335	0.441	12264000.0
2001-10-18 11:00:00	AMZN	Stock	0.4415	0.4615	0.4405	0.4455	9714000.0
2001-10-18 12:00:00	AMZN	Stock	0.4455	0.4455	0.4335	0.434	9426000.0
2001-10-18 13:00:00	AMZN	Stock	0.4345	0.44	0.432	0.4325	5354000.0
2001-10-18 14:00:00	AMZN	Stock	0.4325	0.437	0.43	0.433	9498000.0
2001-10-18 15:00:00	AMZN	Stock	0.4325	0.4325	0.419	0.4235	20166000.0
2001-10-18 16:00:00	AMZN	Stock	0.4245	0.43	0.421	0.43	2066000.0
2001-10-18 17:00:00	AMZN	Stock	0.423	0.4235	0.415	0.415	42000.0
2001-10-18 09:00:00	CL	Stock	28.13	28.6	28.05	28.55	353200.0
2001-10-18 10:00:00	CL	Stock	28.57	28.95	28.57	28.905	415400.0
2001-10-18 11:00:00	CL	Stock	28.865	28.875	28.6	28.64	249200.0
2001-10-18 12:00:00	CL	Stock	28.64	28.8	28.56	28.76	239600.0
2001-10-18 13:00:00	CL	Stock	28.76	28.85	28.7	28.77	193600.0
2001-10-18 14:00:00	CL	Stock	28.78	28.895	28.75	28.765	279200.0
2001-10-18 15:00:00	CL	Stock	28.75	28.9	28.725	28.795	488400.0
2001-10-18 16:00:00	CL	Stock	28.795	28.825	28.795	28.8	50600.0

> showing 50 of 17,225 rows — these rows as CSV

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