PREVIEW / stock_1hour / 2003-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-06-19.parquet
  size:    459 KB
  rows:    22,019
  symbols: 1,581

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-06-19 08:00:00	AAPL	Stock	0.3473	0.3482	0.3429	0.343	262976.0
2003-06-19 09:00:00	AAPL	Stock	0.3438	0.3457	0.3375	0.3405	39670624.0
2003-06-19 10:00:00	AAPL	Stock	0.3404	0.3441	0.3375	0.34	58318120.0
2003-06-19 11:00:00	AAPL	Stock	0.34	0.3411	0.3352	0.3395	23712080.0
2003-06-19 12:00:00	AAPL	Stock	0.3393	0.3455	0.3373	0.3445	45765048.0
2003-06-19 13:00:00	AAPL	Stock	0.3445	0.3502	0.3439	0.3479	52603712.0
2003-06-19 14:00:00	AAPL	Stock	0.3477	0.3493	0.345	0.345	40801544.0
2003-06-19 15:00:00	AAPL	Stock	0.345	0.3454	0.3395	0.3418	67091976.0
2003-06-19 16:00:00	AAPL	Stock	0.3413	0.3439	0.3395	0.3418	4962216.0
2003-06-19 18:00:00	AAPL	Stock	0.343	0.343	0.343	0.343	593600.0
2003-06-19 08:00:00	MSFT	Stock	26.15	26.24	26.091	26.19	72959.0
2003-06-19 09:00:00	MSFT	Stock	26.19	26.307	26.08	26.16	8724304.0
2003-06-19 10:00:00	MSFT	Stock	26.16	26.39	26.144	26.2	12181031.0
2003-06-19 11:00:00	MSFT	Stock	26.2	26.25	26.06	26.21	7102054.0
2003-06-19 12:00:00	MSFT	Stock	26.2	26.22	26.03	26.19	7945649.0
2003-06-19 13:00:00	MSFT	Stock	26.18	26.32	26.17	26.26	4561466.0
2003-06-19 14:00:00	MSFT	Stock	26.251	26.35	26.22	26.27	5775789.0
2003-06-19 15:00:00	MSFT	Stock	26.27	26.28	26.03	26.07	9782899.0
2003-06-19 16:00:00	MSFT	Stock	26.07	26.32	26.0038	26.0038	918648.0
2003-06-19 17:00:00	MSFT	Stock	26.07	26.09	26.022	26.023	12626.0
2003-06-19 18:00:00	MSFT	Stock	26.03	26.07	26.02	26.02	82343.0
2003-06-19 08:00:00	NVDA	Stock	0.2133	0.2146	0.2129	0.2137	474000.0
2003-06-19 09:00:00	NVDA	Stock	0.2122	0.2144	0.2108	0.2122	108463680.0
2003-06-19 10:00:00	NVDA	Stock	0.2121	0.2143	0.2087	0.2093	158592480.0
2003-06-19 11:00:00	NVDA	Stock	0.2092	0.2098	0.2068	0.2087	92174760.0
2003-06-19 12:00:00	NVDA	Stock	0.2087	0.2088	0.2069	0.2075	59502360.0
2003-06-19 13:00:00	NVDA	Stock	0.2077	0.2081	0.2053	0.2055	81553560.0
2003-06-19 14:00:00	NVDA	Stock	0.2055	0.2062	0.2028	0.2051	175654320.0
2003-06-19 15:00:00	NVDA	Stock	0.2051	0.2051	0.1986	0.1995	350652600.0
2003-06-19 16:00:00	NVDA	Stock	0.1994	0.1998	0.1983	0.1992	24175200.0
2003-06-19 17:00:00	NVDA	Stock	0.1992	0.1996	0.1967	0.1967	2775600.0
2003-06-19 18:00:00	NVDA	Stock	0.1963	0.1994	0.1959	0.1994	864000.0
2003-06-19 08:00:00	AMZN	Stock	1.79	1.806	1.79	1.806	68200.0
2003-06-19 09:00:00	AMZN	Stock	1.8	1.8125	1.761	1.806	16648800.0
2003-06-19 10:00:00	AMZN	Stock	1.8045	1.835	1.791	1.798	29511060.0
2003-06-19 11:00:00	AMZN	Stock	1.7975	1.8045	1.7865	1.8	14453960.0
2003-06-19 12:00:00	AMZN	Stock	1.7995	1.8	1.7855	1.7925	14577480.0
2003-06-19 13:00:00	AMZN	Stock	1.7925	1.811	1.792	1.801	8774560.0
2003-06-19 14:00:00	AMZN	Stock	1.801	1.801	1.792	1.7925	7251420.0
2003-06-19 15:00:00	AMZN	Stock	1.792	1.795	1.769	1.7745	19506400.0
2003-06-19 16:00:00	AMZN	Stock	1.7745	1.776	1.7716	1.775	524000.0
2003-06-19 17:00:00	AMZN	Stock	1.775	1.7775	1.775	1.7775	102000.0
2003-06-19 18:00:00	AMZN	Stock	1.775	1.775	1.775	1.775	108000.0
2003-06-19 09:00:00	CL	Stock	30.36	30.495	30.35	30.39	433000.0
2003-06-19 10:00:00	CL	Stock	30.31	30.4	30.13	30.175	484800.0
2003-06-19 11:00:00	CL	Stock	30.17	30.295	30.14	30.245	252600.0
2003-06-19 12:00:00	CL	Stock	30.255	30.34	30.125	30.315	263000.0
2003-06-19 13:00:00	CL	Stock	30.315	30.325	30.18	30.18	101000.0
2003-06-19 14:00:00	CL	Stock	30.18	30.2	30.04	30.045	392600.0
2003-06-19 15:00:00	CL	Stock	30.045	30.045	29.93	29.955	720600.0

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

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