PREVIEW / stock_1hour / 2003-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-05-21.parquet
  size:    431 KB
  rows:    21,018
  symbols: 1,570

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-05-21 08:00:00	AAPL	Stock	0.3196	0.3196	0.3177	0.3179	2189600.0
2003-05-21 09:00:00	AAPL	Stock	0.3177	0.3214	0.3155	0.3175	45359496.0
2003-05-21 10:00:00	AAPL	Stock	0.3177	0.323	0.3175	0.3204	68970496.0
2003-05-21 11:00:00	AAPL	Stock	0.3204	0.3211	0.3188	0.3198	25846800.0
2003-05-21 12:00:00	AAPL	Stock	0.3198	0.3202	0.318	0.3193	19209624.0
2003-05-21 13:00:00	AAPL	Stock	0.3195	0.3209	0.3177	0.3177	20636896.0
2003-05-21 14:00:00	AAPL	Stock	0.3177	0.3186	0.317	0.3184	31650920.0
2003-05-21 15:00:00	AAPL	Stock	0.3182	0.3193	0.3166	0.3186	34366416.0
2003-05-21 16:00:00	AAPL	Stock	0.3188	0.3189	0.3159	0.318	1136352.0
2003-05-21 17:00:00	AAPL	Stock	0.3189	0.3189	0.3188	0.3188	901600.0
2003-05-21 18:00:00	AAPL	Stock	0.317	0.317	0.317	0.317	554400.0
2003-05-21 08:00:00	MSFT	Stock	24.71	24.81	24.55	24.8	92093.0
2003-05-21 09:00:00	MSFT	Stock	24.8	24.801	24.42	24.441	9117048.0
2003-05-21 10:00:00	MSFT	Stock	24.4419	24.51	24.12	24.18	16280832.0
2003-05-21 11:00:00	MSFT	Stock	24.18	24.221	24.02	24.12	11307918.0
2003-05-21 12:00:00	MSFT	Stock	24.12	24.2	24.069	24.16	9077383.0
2003-05-21 13:00:00	MSFT	Stock	24.16	24.17	23.938	23.96	13156402.0
2003-05-21 14:00:00	MSFT	Stock	23.97	24.16	23.89	24.051	15283393.0
2003-05-21 15:00:00	MSFT	Stock	24.06	24.1137	23.95	24.033	14075934.0
2003-05-21 16:00:00	MSFT	Stock	24.032	24.1	24.0	24.07	1817747.0
2003-05-21 17:00:00	MSFT	Stock	24.07	24.087	23.99	23.99	237224.0
2003-05-21 18:00:00	MSFT	Stock	24.02	24.04	23.99	24.03	22785.0
2003-05-21 08:00:00	NVDA	Stock	0.17	0.17	0.168	0.1684	4818000.0
2003-05-21 09:00:00	NVDA	Stock	0.1687	0.1688	0.1675	0.1679	85528560.0
2003-05-21 10:00:00	NVDA	Stock	0.1679	0.1692	0.1677	0.1691	123418800.0
2003-05-21 11:00:00	NVDA	Stock	0.1691	0.1706	0.1687	0.169	90838560.0
2003-05-21 12:00:00	NVDA	Stock	0.169	0.1726	0.169	0.172	92843040.0
2003-05-21 13:00:00	NVDA	Stock	0.172	0.1724	0.1709	0.171	80011680.0
2003-05-21 14:00:00	NVDA	Stock	0.1709	0.1738	0.1708	0.1733	116564880.0
2003-05-21 15:00:00	NVDA	Stock	0.1734	0.1743	0.1723	0.1742	149045160.0
2003-05-21 16:00:00	NVDA	Stock	0.1742	0.1749	0.1739	0.1747	6299040.0
2003-05-21 17:00:00	NVDA	Stock	0.1743	0.1748	0.1742	0.1747	1758000.0
2003-05-21 18:00:00	NVDA	Stock	0.1745	0.1745	0.1681	0.1737	1524000.0
2003-05-21 08:00:00	AMZN	Stock	1.5755	1.5755	1.564	1.5745	198000.0
2003-05-21 09:00:00	AMZN	Stock	1.5746	1.592	1.567	1.5725	15855360.0
2003-05-21 10:00:00	AMZN	Stock	1.5725	1.5865	1.567	1.575	15700480.0
2003-05-21 11:00:00	AMZN	Stock	1.575	1.578	1.565	1.5674	8622780.0
2003-05-21 12:00:00	AMZN	Stock	1.567	1.5745	1.558	1.5715	9089780.0
2003-05-21 13:00:00	AMZN	Stock	1.572	1.5775	1.565	1.566	6691700.0
2003-05-21 14:00:00	AMZN	Stock	1.566	1.582	1.5655	1.5815	8199520.0
2003-05-21 15:00:00	AMZN	Stock	1.581	1.592	1.576	1.5855	18541920.0
2003-05-21 16:00:00	AMZN	Stock	1.587	1.5895	1.584	1.587	760060.0
2003-05-21 17:00:00	AMZN	Stock	1.5875	1.5875	1.5875	1.5875	172000.0
2003-05-21 18:00:00	AMZN	Stock	1.5815	1.5815	1.5815	1.5815	2000.0
2003-05-21 09:00:00	CL	Stock	29.6	29.62	29.455	29.455	390600.0
2003-05-21 10:00:00	CL	Stock	29.46	29.465	29.345	29.38	628200.0
2003-05-21 11:00:00	CL	Stock	29.4	29.41	29.23	29.25	546800.0
2003-05-21 12:00:00	CL	Stock	29.245	29.38	29.2	29.355	404800.0
2003-05-21 13:00:00	CL	Stock	29.345	29.36	29.215	29.24	306000.0
2003-05-21 14:00:00	CL	Stock	29.24	29.3	29.235	29.295	407800.0

> showing 50 of 21,018 rows — these rows as CSV

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