PREVIEW / stock_1hour / 2002-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-20.parquet
  size:    413 KB
  rows:    19,239
  symbols: 1,444

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
2002-06-20 08:00:00	AAPL	Stock	0.3063	0.3068	0.3063	0.3068	453600.0
2002-06-20 09:00:00	AAPL	Stock	0.3063	0.3096	0.3041	0.3095	51794400.0
2002-06-20 10:00:00	AAPL	Stock	0.3096	0.313	0.3045	0.3091	77582400.0
2002-06-20 11:00:00	AAPL	Stock	0.3091	0.3121	0.308	0.3114	32978400.0
2002-06-20 12:00:00	AAPL	Stock	0.3114	0.3143	0.3045	0.3071	37318400.0
2002-06-20 13:00:00	AAPL	Stock	0.3071	0.31	0.3036	0.3043	29982400.0
2002-06-20 14:00:00	AAPL	Stock	0.3043	0.3063	0.3009	0.3034	41423200.0
2002-06-20 15:00:00	AAPL	Stock	0.3034	0.3066	0.3023	0.3057	77683200.0
2002-06-20 16:00:00	AAPL	Stock	0.3057	0.3064	0.3023	0.3064	38662400.0
2002-06-20 17:00:00	AAPL	Stock	0.3063	0.3063	0.3046	0.3046	1960000.0
2002-06-20 18:00:00	AAPL	Stock	0.3054	0.3054	0.3054	0.3054	28000.0
2002-06-20 08:00:00	MSFT	Stock	27.125	27.19	26.96	27.05	110800.0
2002-06-20 09:00:00	MSFT	Stock	27.05	27.5245	27.05	27.43	11705000.0
2002-06-20 10:00:00	MSFT	Stock	27.43	27.55	27.25	27.3855	17098000.0
2002-06-20 11:00:00	MSFT	Stock	27.39	27.45	27.305	27.32	6833400.0
2002-06-20 12:00:00	MSFT	Stock	27.32	27.49	27.23	27.345	11641000.0
2002-06-20 13:00:00	MSFT	Stock	27.34	27.445	27.255	27.335	7036600.0
2002-06-20 14:00:00	MSFT	Stock	27.335	27.395	27.24	27.375	6486800.0
2002-06-20 15:00:00	MSFT	Stock	27.375	27.38	26.965	27.045	16988200.0
2002-06-20 16:00:00	MSFT	Stock	27.045	27.335	26.975	27.05	6476400.0
2002-06-20 17:00:00	MSFT	Stock	27.075	27.135	27.05	27.065	444600.0
2002-06-20 18:00:00	MSFT	Stock	27.095	27.095	27.005	27.05	22000.0
2002-06-20 08:00:00	NVDA	Stock	0.1958	0.1986	0.1942	0.1983	3060000.0
2002-06-20 09:00:00	NVDA	Stock	0.1983	0.2046	0.1983	0.2032	253632000.0
2002-06-20 10:00:00	NVDA	Stock	0.2031	0.2042	0.1943	0.1997	318192000.0
2002-06-20 11:00:00	NVDA	Stock	0.1997	0.2017	0.199	0.1999	154440000.0
2002-06-20 12:00:00	NVDA	Stock	0.1999	0.2023	0.1996	0.2005	199380000.0
2002-06-20 13:00:00	NVDA	Stock	0.2004	0.2017	0.1979	0.1994	102540000.0
2002-06-20 14:00:00	NVDA	Stock	0.1991	0.2012	0.1979	0.2002	132444000.0
2002-06-20 15:00:00	NVDA	Stock	0.2	0.2002	0.1958	0.1969	215580000.0
2002-06-20 16:00:00	NVDA	Stock	0.1969	0.198	0.1964	0.1969	14868000.0
2002-06-20 17:00:00	NVDA	Stock	0.1978	0.1982	0.1967	0.1982	2196000.0
2002-06-20 18:00:00	NVDA	Stock	0.1982	0.1982	0.1969	0.1982	1092000.0
2002-06-20 08:00:00	AMZN	Stock	0.919	0.9295	0.9125	0.915	140000.0
2002-06-20 09:00:00	AMZN	Stock	0.915	0.919	0.9075	0.913	15966000.0
2002-06-20 10:00:00	AMZN	Stock	0.913	0.9165	0.8935	0.9001	29402000.0
2002-06-20 11:00:00	AMZN	Stock	0.901	0.9025	0.8935	0.8955	28874000.0
2002-06-20 12:00:00	AMZN	Stock	0.8955	0.9095	0.8955	0.8995	18680000.0
2002-06-20 13:00:00	AMZN	Stock	0.899	0.901	0.897	0.8975	8754000.0
2002-06-20 14:00:00	AMZN	Stock	0.8975	0.904	0.894	0.894	8906000.0
2002-06-20 15:00:00	AMZN	Stock	0.8945	0.8945	0.867	0.875	35888000.0
2002-06-20 16:00:00	AMZN	Stock	0.874	0.879	0.8685	0.8755	24914000.0
2002-06-20 17:00:00	AMZN	Stock	0.8775	0.8775	0.875	0.8775	364000.0
2002-06-20 09:00:00	CL	Stock	26.075	26.25	26.07	26.1	485400.0
2002-06-20 10:00:00	CL	Stock	26.1	26.15	25.945	25.945	683000.0
2002-06-20 11:00:00	CL	Stock	25.945	26.02	25.85	25.935	528200.0
2002-06-20 12:00:00	CL	Stock	25.935	26.075	25.925	26.035	627400.0
2002-06-20 13:00:00	CL	Stock	26.035	26.04	25.96	25.995	437000.0
2002-06-20 14:00:00	CL	Stock	25.995	26.06	25.94	25.99	598000.0
2002-06-20 15:00:00	CL	Stock	25.99	26.025	25.8	25.83	1633600.0

> showing 50 of 19,239 rows — these rows as CSV

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