PREVIEW / stock_1hour / 2004-02-19

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-02-19.parquet
  size:    521 KB
  rows:    23,922
  symbols: 1,723

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
2004-02-19 08:00:00	AAPL	Stock	0.418	0.418	0.418	0.418	28000.0
2004-02-19 09:00:00	AAPL	Stock	0.4186	0.4221	0.4159	0.4196	24983000.0
2004-02-19 10:00:00	AAPL	Stock	0.4193	0.4193	0.4134	0.4145	27170808.0
2004-02-19 11:00:00	AAPL	Stock	0.4145	0.4146	0.4057	0.4059	55134912.0
2004-02-19 12:00:00	AAPL	Stock	0.4057	0.4102	0.405	0.4095	35666568.0
2004-02-19 13:00:00	AAPL	Stock	0.4093	0.4098	0.4057	0.4089	17081232.0
2004-02-19 14:00:00	AAPL	Stock	0.4089	0.4089	0.4041	0.4043	45152296.0
2004-02-19 15:00:00	AAPL	Stock	0.4041	0.4068	0.4004	0.4011	102056640.0
2004-02-19 16:00:00	AAPL	Stock	0.4011	0.4036	0.3996	0.4002	10376968.0
2004-02-19 17:00:00	AAPL	Stock	0.4002	0.4002	0.4	0.4002	1416800.0
2004-02-19 08:00:00	MSFT	Stock	26.85	26.99	26.85	26.94	101436.0
2004-02-19 09:00:00	MSFT	Stock	26.96	26.98	26.76	26.86	5788065.0
2004-02-19 10:00:00	MSFT	Stock	26.86	26.87	26.76	26.82	6965381.0
2004-02-19 11:00:00	MSFT	Stock	26.82	26.95	26.78	26.88	10242163.0
2004-02-19 12:00:00	MSFT	Stock	26.88	26.94	26.79	26.87	4970724.0
2004-02-19 13:00:00	MSFT	Stock	26.87	26.92	26.83	26.88	5194810.0
2004-02-19 14:00:00	MSFT	Stock	26.88	26.91	26.72	26.73	6359031.0
2004-02-19 15:00:00	MSFT	Stock	26.72	26.73	26.45	26.45	16523243.0
2004-02-19 16:00:00	MSFT	Stock	26.45	26.7	26.37	26.43	1141848.0
2004-02-19 17:00:00	MSFT	Stock	26.43	26.53	26.43	26.43	796388.0
2004-02-19 18:00:00	MSFT	Stock	26.51	26.54	26.5	26.51	2700.0
2004-02-19 08:00:00	NVDA	Stock	0.1966	0.1987	0.1966	0.1987	1534800.0
2004-02-19 09:00:00	NVDA	Stock	0.1988	0.2	0.198	0.199	89140440.0
2004-02-19 10:00:00	NVDA	Stock	0.199	0.2002	0.1979	0.2002	66732600.0
2004-02-19 11:00:00	NVDA	Stock	0.2002	0.2004	0.1988	0.1999	69517080.0
2004-02-19 12:00:00	NVDA	Stock	0.1999	0.2022	0.1996	0.2018	70047960.0
2004-02-19 13:00:00	NVDA	Stock	0.2019	0.202	0.1996	0.2008	64780800.0
2004-02-19 14:00:00	NVDA	Stock	0.2008	0.2017	0.1999	0.1999	86159280.0
2004-02-19 15:00:00	NVDA	Stock	0.1999	0.2	0.1958	0.1966	165861480.0
2004-02-19 16:00:00	NVDA	Stock	0.1962	0.1967	0.1959	0.1962	2380080.0
2004-02-19 17:00:00	NVDA	Stock	0.1962	0.1965	0.1962	0.1965	1596000.0
2004-02-19 08:00:00	AMZN	Stock	2.2438	2.265	2.2438	2.265	74000.0
2004-02-19 09:00:00	AMZN	Stock	2.2625	2.308	2.255	2.2985	30965220.0
2004-02-19 10:00:00	AMZN	Stock	2.2985	2.301	2.28	2.2875	23622060.0
2004-02-19 11:00:00	AMZN	Stock	2.2876	2.2905	2.2755	2.2808	12077540.0
2004-02-19 12:00:00	AMZN	Stock	2.2805	2.286	2.266	2.285	11857560.0
2004-02-19 13:00:00	AMZN	Stock	2.284	2.2845	2.255	2.266	13230400.0
2004-02-19 14:00:00	AMZN	Stock	2.266	2.2675	2.25	2.2545	12381000.0
2004-02-19 15:00:00	AMZN	Stock	2.2545	2.256	2.233	2.233	34385400.0
2004-02-19 16:00:00	AMZN	Stock	2.236	2.2755	2.23	2.262	3675480.0
2004-02-19 17:00:00	AMZN	Stock	2.2325	2.26	2.2325	2.25	505620.0
2004-02-19 18:00:00	AMZN	Stock	2.2505	2.2555	2.25	2.25	62000.0
2004-02-19 09:00:00	CL	Stock	27.825	27.97	27.805	27.97	454200.0
2004-02-19 10:00:00	CL	Stock	27.975	28.1	27.97	28.085	860000.0
2004-02-19 11:00:00	CL	Stock	28.085	28.165	28.025	28.14	636800.0
2004-02-19 12:00:00	CL	Stock	28.145	28.26	28.11	28.24	691800.0
2004-02-19 13:00:00	CL	Stock	28.235	28.4	28.21	28.34	1076800.0
2004-02-19 14:00:00	CL	Stock	28.335	28.45	28.28	28.41	935200.0
2004-02-19 15:00:00	CL	Stock	28.405	28.425	28.18	28.245	1327000.0
2004-02-19 16:00:00	CL	Stock	28.25	28.2515	28.025	28.025	17600.0

> showing 50 of 23,922 rows — these rows as CSV

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