PREVIEW / stock_1hour / 2000-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-12-15.parquet
  size:    329 KB
  rows:    17,007
  symbols: 1,254

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-12-15 08:00:00	AAPL	Stock	0.2578	0.26	0.2567	0.2589	442400.0
2000-12-15 09:00:00	AAPL	Stock	0.26	0.2623	0.2556	0.2567	65604000.0
2000-12-15 10:00:00	AAPL	Stock	0.2567	0.2612	0.2511	0.2589	106248800.0
2000-12-15 11:00:00	AAPL	Stock	0.2578	0.26	0.2522	0.2522	33034400.0
2000-12-15 12:00:00	AAPL	Stock	0.2533	0.2533	0.2511	0.2533	31264800.0
2000-12-15 13:00:00	AAPL	Stock	0.2533	0.2545	0.2522	0.2545	24970400.0
2000-12-15 14:00:00	AAPL	Stock	0.2533	0.2545	0.2522	0.2545	22668800.0
2000-12-15 15:00:00	AAPL	Stock	0.2533	0.2578	0.25	0.2533	79525600.0
2000-12-15 16:00:00	AAPL	Stock	0.2533	0.2567	0.2511	0.2511	22030400.0
2000-12-15 17:00:00	AAPL	Stock	0.2517	0.2545	0.2511	0.2545	57428000.0
2000-12-15 18:00:00	AAPL	Stock	0.2545	0.2545	0.2506	0.2506	1265600.0
2000-12-15 08:00:00	MSFT	Stock	25.5	26.5	25.25	25.9062	2454402.0
2000-12-15 09:00:00	MSFT	Stock	25.9062	27.0625	25.3438	25.375	71840800.0
2000-12-15 10:00:00	MSFT	Stock	25.4062	25.5156	24.9375	25.1562	40334200.0
2000-12-15 11:00:00	MSFT	Stock	25.125	25.2188	24.7812	24.7812	30946400.0
2000-12-15 12:00:00	MSFT	Stock	24.8125	24.875	24.1875	24.4688	25384800.0
2000-12-15 13:00:00	MSFT	Stock	24.4688	24.5625	24.375	24.5	17498200.0
2000-12-15 14:00:00	MSFT	Stock	24.5	24.6875	24.375	24.5156	26337400.0
2000-12-15 15:00:00	MSFT	Stock	24.5312	24.7656	23.875	24.625	49770000.0
2000-12-15 16:00:00	MSFT	Stock	24.625	25.5312	24.375	24.5938	18671600.0
2000-12-15 17:00:00	MSFT	Stock	24.5312	24.75	24.4688	24.5938	7775400.0
2000-12-15 18:00:00	MSFT	Stock	24.6875	24.6875	24.5625	24.625	742000.0
2000-12-15 08:00:00	NVDA	Stock	0.1706	0.1706	0.1706	0.1706	48000.0
2000-12-15 09:00:00	NVDA	Stock	0.1688	0.1688	0.1612	0.1667	120360000.0
2000-12-15 10:00:00	NVDA	Stock	0.1667	0.1706	0.1651	0.1682	143256000.0
2000-12-15 11:00:00	NVDA	Stock	0.1688	0.1724	0.1661	0.1664	86928000.0
2000-12-15 12:00:00	NVDA	Stock	0.1661	0.1682	0.1656	0.1677	79728000.0
2000-12-15 13:00:00	NVDA	Stock	0.168	0.1682	0.1654	0.1654	103656000.0
2000-12-15 14:00:00	NVDA	Stock	0.1656	0.1669	0.1622	0.1651	179904000.0
2000-12-15 15:00:00	NVDA	Stock	0.1654	0.1677	0.1552	0.1568	247344000.0
2000-12-15 16:00:00	NVDA	Stock	0.156	0.1583	0.1542	0.156	31776000.0
2000-12-15 17:00:00	NVDA	Stock	0.1573	0.1573	0.1573	0.1573	240000.0
2000-12-15 18:00:00	NVDA	Stock	0.1578	0.1625	0.1573	0.1589	264000.0
2000-12-15 08:00:00	AMZN	Stock	1.15	1.15	1.1062	1.125	78000.0
2000-12-15 09:00:00	AMZN	Stock	1.1344	1.1375	1.0875	1.1156	20142000.0
2000-12-15 10:00:00	AMZN	Stock	1.1156	1.1672	1.1	1.1656	23786000.0
2000-12-15 11:00:00	AMZN	Stock	1.1656	1.175	1.1281	1.1312	29094000.0
2000-12-15 12:00:00	AMZN	Stock	1.1312	1.1438	1.1172	1.125	6952000.0
2000-12-15 13:00:00	AMZN	Stock	1.1234	1.1406	1.1219	1.125	11172000.0
2000-12-15 14:00:00	AMZN	Stock	1.125	1.2	1.1219	1.1844	35738000.0
2000-12-15 15:00:00	AMZN	Stock	1.1844	1.2125	1.1375	1.1438	21732000.0
2000-12-15 16:00:00	AMZN	Stock	1.1438	1.1656	1.1312	1.1438	6234000.0
2000-12-15 17:00:00	AMZN	Stock	1.1438	1.1453	1.1375	1.1375	5272000.0
2000-12-15 18:00:00	AMZN	Stock	1.1469	1.1813	1.1281	1.1469	66000.0
2000-12-15 09:00:00	CL	Stock	27.85	28.4	27.75	28.17	614000.0
2000-12-15 10:00:00	CL	Stock	28.2	28.55	28.155	28.5	485400.0
2000-12-15 11:00:00	CL	Stock	28.525	28.545	28.25	28.47	388200.0
2000-12-15 12:00:00	CL	Stock	28.445	28.5	28.26	28.34	200600.0
2000-12-15 13:00:00	CL	Stock	28.335	28.55	28.335	28.51	468200.0
2000-12-15 14:00:00	CL	Stock	28.515	28.515	28.325	28.45	183800.0

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

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