PREVIEW / stock_1hour / 2005-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-10.parquet
  size:    529 KB
  rows:    25,273
  symbols: 1,987

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
2005-06-10 07:00:00	AAPL	Stock	1.3393	1.3536	1.3393	1.35	525644.0
2005-06-10 08:00:00	AAPL	Stock	1.3482	1.3543	1.3429	1.3446	2786532.0
2005-06-10 09:00:00	AAPL	Stock	1.3439	1.3462	1.3007	1.305	116279380.0
2005-06-10 10:00:00	AAPL	Stock	1.305	1.3107	1.295	1.3021	115779496.0
2005-06-10 11:00:00	AAPL	Stock	1.3021	1.3043	1.2893	1.29	59080056.0
2005-06-10 12:00:00	AAPL	Stock	1.29	1.3018	1.2807	1.2807	83245092.0
2005-06-10 13:00:00	AAPL	Stock	1.2807	1.2836	1.2686	1.2771	107100476.0
2005-06-10 14:00:00	AAPL	Stock	1.2775	1.2821	1.2693	1.2732	66525592.0
2005-06-10 15:00:00	AAPL	Stock	1.2732	1.2843	1.2729	1.2786	118398868.0
2005-06-10 16:00:00	AAPL	Stock	1.2789	1.2814	1.27	1.275	5518884.0
2005-06-10 17:00:00	AAPL	Stock	1.275	1.2793	1.2729	1.2793	247716.0
2005-06-10 18:00:00	AAPL	Stock	1.2732	1.2739	1.2732	1.2736	125160.0
2005-06-10 08:00:00	MSFT	Stock	25.5	25.57	25.5	25.53	8871.0
2005-06-10 09:00:00	MSFT	Stock	25.51	25.53	25.44	25.45	4364031.0
2005-06-10 10:00:00	MSFT	Stock	25.45	25.47	25.39	25.41	6904401.0
2005-06-10 11:00:00	MSFT	Stock	25.41	25.43	25.38	25.4	6873946.0
2005-06-10 12:00:00	MSFT	Stock	25.4	25.44	25.34	25.42	4677744.0
2005-06-10 13:00:00	MSFT	Stock	25.42	25.49	25.4	25.45	4135386.0
2005-06-10 14:00:00	MSFT	Stock	25.45	25.5	25.37	25.392	3687606.0
2005-06-10 15:00:00	MSFT	Stock	25.39	25.46	25.37	25.43	6029839.0
2005-06-10 16:00:00	MSFT	Stock	25.43	25.49	25.4	25.45	404753.0
2005-06-10 17:00:00	MSFT	Stock	25.43	25.45	25.4	25.44	33761.0
2005-06-10 18:00:00	MSFT	Stock	25.42	25.43	25.42	25.43	3500.0
2005-06-10 09:00:00	NVDA	Stock	0.2357	0.236	0.2332	0.2333	105470520.0
2005-06-10 10:00:00	NVDA	Stock	0.2332	0.2339	0.2316	0.2326	88089600.0
2005-06-10 11:00:00	NVDA	Stock	0.2326	0.2346	0.2323	0.2327	50123040.0
2005-06-10 12:00:00	NVDA	Stock	0.2327	0.2337	0.2321	0.233	41387160.0
2005-06-10 13:00:00	NVDA	Stock	0.2329	0.2346	0.2328	0.234	35388000.0
2005-06-10 14:00:00	NVDA	Stock	0.234	0.2342	0.2327	0.2334	39239880.0
2005-06-10 15:00:00	NVDA	Stock	0.2334	0.2347	0.2331	0.2331	97030680.0
2005-06-10 16:00:00	NVDA	Stock	0.2332	0.2354	0.2329	0.2341	4465920.0
2005-06-10 17:00:00	NVDA	Stock	0.2341	0.2341	0.2332	0.2332	37200.0
2005-06-10 18:00:00	NVDA	Stock	0.2332	0.2332	0.2332	0.2332	12000.0
2005-06-10 08:00:00	AMZN	Stock	1.761	1.763	1.761	1.763	6000.0
2005-06-10 09:00:00	AMZN	Stock	1.764	1.7645	1.7365	1.7375	10337560.0
2005-06-10 10:00:00	AMZN	Stock	1.737	1.739	1.7255	1.732	15897820.0
2005-06-10 11:00:00	AMZN	Stock	1.7325	1.737	1.73	1.732	6319520.0
2005-06-10 12:00:00	AMZN	Stock	1.7315	1.736	1.7235	1.731	7936940.0
2005-06-10 13:00:00	AMZN	Stock	1.731	1.742	1.7305	1.7315	5451540.0
2005-06-10 14:00:00	AMZN	Stock	1.732	1.7375	1.7275	1.736	6136320.0
2005-06-10 15:00:00	AMZN	Stock	1.7365	1.7625	1.734	1.7475	14565000.0
2005-06-10 16:00:00	AMZN	Stock	1.7475	1.7475	1.7435	1.7435	468900.0
2005-06-10 09:00:00	CL	Stock	24.9	25.045	24.885	25.04	376200.0
2005-06-10 10:00:00	CL	Stock	25.04	25.075	24.885	24.9	563800.0
2005-06-10 11:00:00	CL	Stock	24.9	24.91	24.84	24.85	507400.0
2005-06-10 12:00:00	CL	Stock	24.85	24.88	24.83	24.84	588400.0
2005-06-10 13:00:00	CL	Stock	24.84	24.92	24.82	24.9	562600.0
2005-06-10 14:00:00	CL	Stock	24.895	24.91	24.855	24.875	310000.0
2005-06-10 15:00:00	CL	Stock	24.875	24.92	24.875	24.885	628400.0
2005-06-10 16:00:00	CL	Stock	24.85	24.85	24.85	24.85	104600.0

> showing 50 of 25,273 rows — these rows as CSV

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