PREVIEW / stock_1hour / 2000-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-14.parquet
  size:    311 KB
  rows:    15,790
  symbols: 1,190

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
2000-07-14 08:00:00	AAPL	Stock	1.0095	1.0324	1.0089	1.0324	571200.0
2000-07-14 09:00:00	AAPL	Stock	1.0313	1.0379	1.0156	1.0279	25715200.0
2000-07-14 10:00:00	AAPL	Stock	1.0279	1.0368	1.0179	1.0301	23189600.0
2000-07-14 11:00:00	AAPL	Stock	1.0301	1.0379	1.0268	1.0335	22747200.0
2000-07-14 12:00:00	AAPL	Stock	1.0324	1.0379	1.019	1.0257	23486400.0
2000-07-14 13:00:00	AAPL	Stock	1.0257	1.0324	1.0234	1.0301	15164800.0
2000-07-14 14:00:00	AAPL	Stock	1.029	1.0536	1.029	1.0458	31600800.0
2000-07-14 15:00:00	AAPL	Stock	1.0458	1.0458	1.0179	1.0301	36808800.0
2000-07-14 16:00:00	AAPL	Stock	1.0313	1.0357	1.0179	1.0335	4317600.0
2000-07-14 17:00:00	AAPL	Stock	1.0446	1.0446	1.0296	1.0357	1153600.0
2000-07-14 18:00:00	AAPL	Stock	1.0357	1.0357	1.0357	1.0357	11200.0
2000-07-14 08:00:00	MSFT	Stock	40.125	40.125	39.5	40.0469	64000.0
2000-07-14 09:00:00	MSFT	Stock	40.0	40.0625	39.3125	39.4062	9052400.0
2000-07-14 10:00:00	MSFT	Stock	39.4062	39.625	39.2188	39.5	10460600.0
2000-07-14 11:00:00	MSFT	Stock	39.4688	39.5625	39.2188	39.4375	4918000.0
2000-07-14 12:00:00	MSFT	Stock	39.4375	39.5938	39.3125	39.4062	6487400.0
2000-07-14 13:00:00	MSFT	Stock	39.4062	39.5938	39.375	39.5938	3269800.0
2000-07-14 14:00:00	MSFT	Stock	39.5625	39.8438	39.5	39.8125	4178400.0
2000-07-14 15:00:00	MSFT	Stock	39.8125	39.875	39.3438	39.4688	9953400.0
2000-07-14 16:00:00	MSFT	Stock	39.4375	39.7656	39.2812	39.4688	1930200.0
2000-07-14 17:00:00	MSFT	Stock	39.4688	39.5625	39.375	39.5	400200.0
2000-07-14 18:00:00	MSFT	Stock	39.5	39.5	39.4375	39.5	2600.0
2000-07-14 08:00:00	NVDA	Stock	0.3094	0.3125	0.3094	0.3125	192000.0
2000-07-14 09:00:00	NVDA	Stock	0.3125	0.3221	0.3099	0.3109	55992000.0
2000-07-14 10:00:00	NVDA	Stock	0.3109	0.3161	0.3	0.3141	64776000.0
2000-07-14 11:00:00	NVDA	Stock	0.3104	0.3161	0.3055	0.3117	40800000.0
2000-07-14 12:00:00	NVDA	Stock	0.3109	0.3141	0.3102	0.312	22272000.0
2000-07-14 13:00:00	NVDA	Stock	0.3122	0.3122	0.3052	0.3057	32016000.0
2000-07-14 14:00:00	NVDA	Stock	0.3065	0.312	0.3042	0.3089	31488000.0
2000-07-14 15:00:00	NVDA	Stock	0.3112	0.3112	0.3042	0.3078	25296000.0
2000-07-14 16:00:00	NVDA	Stock	0.3078	0.3083	0.3047	0.3078	3600000.0
2000-07-14 17:00:00	NVDA	Stock	0.3076	0.3076	0.3074	0.3074	168000.0
2000-07-14 18:00:00	NVDA	Stock	0.3063	0.3063	0.3063	0.3063	24000.0
2000-07-14 08:00:00	AMZN	Stock	1.8	1.85	1.7844	1.8125	468000.0
2000-07-14 09:00:00	AMZN	Stock	1.8062	1.95	1.7719	1.95	43882000.0
2000-07-14 10:00:00	AMZN	Stock	1.9469	2.025	1.9188	1.9906	130474000.0
2000-07-14 11:00:00	AMZN	Stock	1.9906	2.0312	1.9875	1.9969	72218000.0
2000-07-14 12:00:00	AMZN	Stock	2.0	2.1188	1.9969	2.1156	64318000.0
2000-07-14 13:00:00	AMZN	Stock	2.1141	2.1344	2.0828	2.1062	45590000.0
2000-07-14 14:00:00	AMZN	Stock	2.1062	2.1375	2.0875	2.1312	33186000.0
2000-07-14 15:00:00	AMZN	Stock	2.1281	2.1594	2.1	2.1312	51100000.0
2000-07-14 16:00:00	AMZN	Stock	2.1328	2.15	1.8172	2.1125	2424000.0
2000-07-14 17:00:00	AMZN	Stock	2.1125	2.125	2.1062	2.1125	224000.0
2000-07-14 18:00:00	AMZN	Stock	2.1172	2.1188	2.1125	2.1156	40000.0
2000-07-14 09:00:00	CL	Stock	26.5938	26.6875	26.1875	26.4375	820400.0
2000-07-14 10:00:00	CL	Stock	26.4062	26.9375	26.3438	26.9375	1604800.0
2000-07-14 11:00:00	CL	Stock	26.9375	27.0	26.7812	26.9062	1239400.0
2000-07-14 12:00:00	CL	Stock	26.9062	27.1875	26.9062	27.0312	930000.0
2000-07-14 13:00:00	CL	Stock	27.0312	27.2188	27.0	27.1875	377200.0
2000-07-14 14:00:00	CL	Stock	27.1875	27.3125	27.0938	27.1875	840200.0

> showing 50 of 15,790 rows — these rows as CSV

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