PREVIEW / stock_1hour / 2003-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-06-04.parquet
  size:    453 KB
  rows:    21,968
  symbols: 1,580

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-04 09:00:00	AAPL	Stock	0.3089	0.3098	0.3061	0.308	19216904.0
2003-06-04 10:00:00	AAPL	Stock	0.308	0.3146	0.3079	0.3146	40343184.0
2003-06-04 11:00:00	AAPL	Stock	0.3146	0.315	0.3105	0.313	41494432.0
2003-06-04 12:00:00	AAPL	Stock	0.3129	0.3148	0.3114	0.3116	20329568.0
2003-06-04 13:00:00	AAPL	Stock	0.3114	0.3138	0.3109	0.313	16971640.0
2003-06-04 14:00:00	AAPL	Stock	0.3132	0.3139	0.3118	0.3129	26388152.0
2003-06-04 15:00:00	AAPL	Stock	0.3129	0.3177	0.3121	0.3139	61049464.0
2003-06-04 16:00:00	AAPL	Stock	0.3139	0.3148	0.3134	0.3139	5280744.0
2003-06-04 17:00:00	AAPL	Stock	0.3139	0.3139	0.3091	0.3091	5684000.0
2003-06-04 08:00:00	MSFT	Stock	24.88	24.9	24.82	24.85	63311.0
2003-06-04 09:00:00	MSFT	Stock	24.85	25.04	24.85	24.95	6050169.0
2003-06-04 10:00:00	MSFT	Stock	24.957	25.21	24.92	25.206	15182361.0
2003-06-04 11:00:00	MSFT	Stock	25.2	25.22	24.96	24.97	9044394.0
2003-06-04 12:00:00	MSFT	Stock	24.97	25.04	24.89	24.92	5600346.0
2003-06-04 13:00:00	MSFT	Stock	24.92	25.02	24.88	24.938	4827262.0
2003-06-04 14:00:00	MSFT	Stock	24.939	24.97	24.82	24.91	8844636.0
2003-06-04 15:00:00	MSFT	Stock	24.91	25.12	24.74	24.86	17834122.0
2003-06-04 16:00:00	MSFT	Stock	24.851	24.99	24.65	24.7	2075668.0
2003-06-04 17:00:00	MSFT	Stock	24.7	24.88	24.5	24.62	6624520.0
2003-06-04 18:00:00	MSFT	Stock	24.6	24.66	24.581	24.6	38248.0
2003-06-04 08:00:00	NVDA	Stock	0.2102	0.2121	0.2102	0.2112	402000.0
2003-06-04 09:00:00	NVDA	Stock	0.211	0.2112	0.2063	0.2075	138680640.0
2003-06-04 10:00:00	NVDA	Stock	0.2076	0.2117	0.2072	0.211	275508600.0
2003-06-04 11:00:00	NVDA	Stock	0.211	0.2112	0.2086	0.2086	177662160.0
2003-06-04 12:00:00	NVDA	Stock	0.2086	0.2112	0.2075	0.2097	94643640.0
2003-06-04 13:00:00	NVDA	Stock	0.2095	0.2115	0.2092	0.2107	57808080.0
2003-06-04 14:00:00	NVDA	Stock	0.2107	0.2122	0.2103	0.2109	84800760.0
2003-06-04 15:00:00	NVDA	Stock	0.211	0.2154	0.2108	0.215	222252360.0
2003-06-04 16:00:00	NVDA	Stock	0.2149	0.2152	0.2137	0.2149	10274280.0
2003-06-04 17:00:00	NVDA	Stock	0.2146	0.215	0.2102	0.2142	4669680.0
2003-06-04 18:00:00	NVDA	Stock	0.2142	0.2142	0.2129	0.2132	791400.0
2003-06-04 08:00:00	AMZN	Stock	1.7645	1.7651	1.75	1.7605	86000.0
2003-06-04 09:00:00	AMZN	Stock	1.7605	1.78	1.75	1.7598	23595920.0
2003-06-04 10:00:00	AMZN	Stock	1.7585	1.775	1.755	1.7635	42810200.0
2003-06-04 11:00:00	AMZN	Stock	1.7635	1.7685	1.7375	1.7415	28919800.0
2003-06-04 12:00:00	AMZN	Stock	1.741	1.7578	1.735	1.7505	17371880.0
2003-06-04 13:00:00	AMZN	Stock	1.7505	1.764	1.7485	1.7635	15834380.0
2003-06-04 14:00:00	AMZN	Stock	1.764	1.7685	1.753	1.7605	17456980.0
2003-06-04 15:00:00	AMZN	Stock	1.76	1.772	1.7575	1.7685	24098940.0
2003-06-04 16:00:00	AMZN	Stock	1.768	1.7745	1.7609	1.773	2514480.0
2003-06-04 17:00:00	AMZN	Stock	1.773	1.773	1.7615	1.768	1750000.0
2003-06-04 18:00:00	AMZN	Stock	1.768	1.768	1.768	1.768	16000.0
2003-06-04 09:00:00	CL	Stock	29.77	29.77	29.63	29.715	185600.0
2003-06-04 10:00:00	CL	Stock	29.72	29.945	29.69	29.885	451200.0
2003-06-04 11:00:00	CL	Stock	29.875	29.875	29.72	29.725	459600.0
2003-06-04 12:00:00	CL	Stock	29.725	29.8	29.7	29.735	298200.0
2003-06-04 13:00:00	CL	Stock	29.715	29.745	29.625	29.695	316200.0
2003-06-04 14:00:00	CL	Stock	29.695	29.7	29.55	29.575	494600.0
2003-06-04 15:00:00	CL	Stock	29.575	29.675	29.55	29.645	742600.0
2003-06-04 16:00:00	CL	Stock	29.645	29.66	29.645	29.66	90400.0

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

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