PREVIEW / stock_1hour / 2001-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-18.parquet
  size:    363 KB
  rows:    17,478
  symbols: 1,316

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-07-18 08:00:00	AAPL	Stock	0.4018	0.4089	0.3959	0.3959	17315200.0
2001-07-18 09:00:00	AAPL	Stock	0.3964	0.4089	0.3768	0.378	229824000.0
2001-07-18 10:00:00	AAPL	Stock	0.378	0.3823	0.3679	0.3775	275016000.0
2001-07-18 11:00:00	AAPL	Stock	0.3775	0.3805	0.367	0.3695	113825600.0
2001-07-18 12:00:00	AAPL	Stock	0.3695	0.3759	0.3686	0.3732	82068000.0
2001-07-18 13:00:00	AAPL	Stock	0.3732	0.3739	0.3652	0.3686	94315200.0
2001-07-18 14:00:00	AAPL	Stock	0.3689	0.3711	0.3668	0.3695	58195200.0
2001-07-18 15:00:00	AAPL	Stock	0.3698	0.3759	0.3684	0.3711	186373600.0
2001-07-18 16:00:00	AAPL	Stock	0.3713	0.3929	0.3643	0.3723	21935200.0
2001-07-18 17:00:00	AAPL	Stock	0.3713	0.3713	0.3616	0.3643	229600.0
2001-07-18 18:00:00	AAPL	Stock	0.3646	0.3688	0.3646	0.3688	84000.0
2001-07-18 08:00:00	MSFT	Stock	35.45	35.905	35.45	35.45	264200.0
2001-07-18 09:00:00	MSFT	Stock	35.495	35.65	35.15	35.585	6917200.0
2001-07-18 10:00:00	MSFT	Stock	35.585	35.75	35.1	35.275	13566000.0
2001-07-18 11:00:00	MSFT	Stock	35.265	35.44	35.13	35.325	4883800.0
2001-07-18 12:00:00	MSFT	Stock	35.33	35.445	35.215	35.37	3882400.0
2001-07-18 13:00:00	MSFT	Stock	35.37	35.54	35.29	35.41	6418800.0
2001-07-18 14:00:00	MSFT	Stock	35.415	35.44	34.94	34.96	7524000.0
2001-07-18 15:00:00	MSFT	Stock	34.95	35.3	34.935	35.285	8895600.0
2001-07-18 16:00:00	MSFT	Stock	35.29	35.495	34.99	35.13	2135400.0
2001-07-18 17:00:00	MSFT	Stock	35.13	35.285	34.95	35.2	48600.0
2001-07-18 18:00:00	MSFT	Stock	35.1	35.14	35.1	35.1	6600.0
2001-07-18 08:00:00	NVDA	Stock	0.3219	0.3219	0.3175	0.3175	1728000.0
2001-07-18 09:00:00	NVDA	Stock	0.3175	0.326	0.3169	0.3258	118152000.0
2001-07-18 10:00:00	NVDA	Stock	0.3259	0.3286	0.3095	0.3153	205032000.0
2001-07-18 11:00:00	NVDA	Stock	0.3153	0.3177	0.3125	0.3138	68880000.0
2001-07-18 12:00:00	NVDA	Stock	0.3138	0.3154	0.3115	0.3151	61392000.0
2001-07-18 13:00:00	NVDA	Stock	0.3151	0.3162	0.3118	0.3131	74136000.0
2001-07-18 14:00:00	NVDA	Stock	0.3131	0.314	0.3104	0.3133	102432000.0
2001-07-18 15:00:00	NVDA	Stock	0.3133	0.3204	0.3121	0.3163	168888000.0
2001-07-18 16:00:00	NVDA	Stock	0.3163	0.318	0.3114	0.3132	14496000.0
2001-07-18 17:00:00	NVDA	Stock	0.315	0.3167	0.3129	0.3138	1704000.0
2001-07-18 08:00:00	AMZN	Stock	0.8165	0.8165	0.8075	0.8075	52000.0
2001-07-18 09:00:00	AMZN	Stock	0.832	0.8325	0.8	0.823	8034000.0
2001-07-18 10:00:00	AMZN	Stock	0.823	0.8325	0.8	0.8085	15834000.0
2001-07-18 11:00:00	AMZN	Stock	0.808	0.825	0.8015	0.8045	10342000.0
2001-07-18 12:00:00	AMZN	Stock	0.805	0.811	0.8	0.8075	5110000.0
2001-07-18 13:00:00	AMZN	Stock	0.8075	0.81	0.8	0.801	7516000.0
2001-07-18 14:00:00	AMZN	Stock	0.801	0.801	0.794	0.799	11804000.0
2001-07-18 15:00:00	AMZN	Stock	0.7985	0.803	0.794	0.798	9050000.0
2001-07-18 16:00:00	AMZN	Stock	0.7985	0.8065	0.798	0.798	1486000.0
2001-07-18 17:00:00	AMZN	Stock	0.798	0.7985	0.798	0.798	30000.0
2001-07-18 09:00:00	CL	Stock	27.9	28.14	27.865	28.14	555600.0
2001-07-18 10:00:00	CL	Stock	28.14	28.14	27.625	27.675	777200.0
2001-07-18 11:00:00	CL	Stock	27.675	27.765	27.62	27.64	429400.0
2001-07-18 12:00:00	CL	Stock	27.64	27.675	27.525	27.545	310200.0
2001-07-18 13:00:00	CL	Stock	27.54	27.75	27.5	27.74	650200.0
2001-07-18 14:00:00	CL	Stock	27.735	27.735	27.57	27.575	406800.0
2001-07-18 15:00:00	CL	Stock	27.58	27.745	27.55	27.655	832800.0
2001-07-18 16:00:00	CL	Stock	27.675	27.675	27.64	27.64	145400.0

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

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