PREVIEW / stock_1hour / 2003-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-19.parquet
  size:    477 KB
  rows:    22,074
  symbols: 1,610

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
2003-08-19 08:00:00	AAPL	Stock	0.3636	0.3636	0.3636	0.3636	28000.0
2003-08-19 09:00:00	AAPL	Stock	0.3638	0.3652	0.3571	0.3607	28135800.0
2003-08-19 10:00:00	AAPL	Stock	0.3613	0.3627	0.3593	0.362	21690536.0
2003-08-19 11:00:00	AAPL	Stock	0.362	0.3621	0.3598	0.3616	7782544.0
2003-08-19 12:00:00	AAPL	Stock	0.3616	0.3634	0.3614	0.3627	14598752.0
2003-08-19 13:00:00	AAPL	Stock	0.3623	0.363	0.3605	0.3627	10072832.0
2003-08-19 14:00:00	AAPL	Stock	0.3627	0.3636	0.3602	0.3613	12509448.0
2003-08-19 15:00:00	AAPL	Stock	0.3614	0.3638	0.3611	0.3634	17355632.0
2003-08-19 16:00:00	AAPL	Stock	0.3627	0.3638	0.3571	0.3602	3488800.0
2003-08-19 17:00:00	AAPL	Stock	0.3602	0.3602	0.3602	0.3602	56000.0
2003-08-19 08:00:00	MSFT	Stock	25.72	25.889	25.72	25.85	123847.0
2003-08-19 09:00:00	MSFT	Stock	25.85	25.96	25.77	25.86	9383252.0
2003-08-19 10:00:00	MSFT	Stock	25.87	26.15	25.78	26.13	11889240.0
2003-08-19 11:00:00	MSFT	Stock	26.13	26.35	26.028	26.31	11074133.0
2003-08-19 12:00:00	MSFT	Stock	26.32	26.5	26.28	26.36	9601496.0
2003-08-19 13:00:00	MSFT	Stock	26.36	26.4	26.28	26.38	4682452.0
2003-08-19 14:00:00	MSFT	Stock	26.39	26.39	26.21	26.34	6897076.0
2003-08-19 15:00:00	MSFT	Stock	26.34	26.65	26.31	26.63	10623376.0
2003-08-19 16:00:00	MSFT	Stock	26.63	26.65	25.8872	26.53	959391.0
2003-08-19 17:00:00	MSFT	Stock	26.54	26.58	26.5	26.53	105738.0
2003-08-19 18:00:00	MSFT	Stock	26.52	26.54	26.51	26.54	2900.0
2003-08-19 08:00:00	NVDA	Stock	0.141	0.141	0.1407	0.1409	594000.0
2003-08-19 09:00:00	NVDA	Stock	0.141	0.1446	0.1408	0.1434	166400400.0
2003-08-19 10:00:00	NVDA	Stock	0.1432	0.1494	0.1432	0.1483	369527760.0
2003-08-19 11:00:00	NVDA	Stock	0.1484	0.1487	0.1476	0.1486	118674840.0
2003-08-19 12:00:00	NVDA	Stock	0.1487	0.1488	0.1467	0.1482	158554080.0
2003-08-19 13:00:00	NVDA	Stock	0.1482	0.1483	0.1471	0.1476	88590600.0
2003-08-19 14:00:00	NVDA	Stock	0.1477	0.1486	0.1469	0.1483	101023560.0
2003-08-19 15:00:00	NVDA	Stock	0.1483	0.15	0.1482	0.1487	235422600.0
2003-08-19 16:00:00	NVDA	Stock	0.1487	0.1496	0.1475	0.1477	14076000.0
2003-08-19 17:00:00	NVDA	Stock	0.1475	0.1476	0.1465	0.1471	1014000.0
2003-08-19 18:00:00	NVDA	Stock	0.1464	0.1477	0.1464	0.1468	186000.0
2003-08-19 08:00:00	AMZN	Stock	2.025	2.1585	2.025	2.155	307320.0
2003-08-19 09:00:00	AMZN	Stock	2.1575	2.2095	2.1525	2.1915	56011020.0
2003-08-19 10:00:00	AMZN	Stock	2.191	2.2	2.1705	2.199	33415680.0
2003-08-19 11:00:00	AMZN	Stock	2.2	2.2	2.175	2.188	27906520.0
2003-08-19 12:00:00	AMZN	Stock	2.189	2.193	2.1675	2.1705	17981800.0
2003-08-19 13:00:00	AMZN	Stock	2.1705	2.1755	2.164	2.168	11703140.0
2003-08-19 14:00:00	AMZN	Stock	2.1685	2.17	2.148	2.1525	15383920.0
2003-08-19 15:00:00	AMZN	Stock	2.1515	2.1815	2.146	2.1755	23747620.0
2003-08-19 16:00:00	AMZN	Stock	2.178	2.18	2.1682	2.1705	2176000.0
2003-08-19 17:00:00	AMZN	Stock	2.1705	2.18	2.1705	2.18	100000.0
2003-08-19 18:00:00	AMZN	Stock	2.1705	2.1781	2.168	2.1781	78000.0
2003-08-19 09:00:00	CL	Stock	27.39	27.41	27.24	27.24	306200.0
2003-08-19 10:00:00	CL	Stock	27.245	27.295	27.165	27.19	297000.0
2003-08-19 11:00:00	CL	Stock	27.19	27.21	27.125	27.165	210200.0
2003-08-19 12:00:00	CL	Stock	27.16	27.23	27.145	27.2	270200.0
2003-08-19 13:00:00	CL	Stock	27.195	27.23	27.115	27.21	113800.0
2003-08-19 14:00:00	CL	Stock	27.21	27.21	27.11	27.155	181400.0
2003-08-19 15:00:00	CL	Stock	27.15	27.25	27.1	27.245	493200.0

> showing 50 of 22,074 rows — these rows as CSV

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