PREVIEW / stock_1hour / 2005-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-13.parquet
  size:    535 KB
  rows:    25,373
  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-13 08:00:00	AAPL	Stock	1.2786	1.2911	1.2768	1.2882	710668.0
2005-06-13 09:00:00	AAPL	Stock	1.29	1.2964	1.2793	1.2925	73987424.0
2005-06-13 10:00:00	AAPL	Stock	1.2925	1.3075	1.2904	1.3057	77529368.0
2005-06-13 11:00:00	AAPL	Stock	1.3057	1.3068	1.2925	1.2925	61083624.0
2005-06-13 12:00:00	AAPL	Stock	1.2925	1.2993	1.2836	1.2907	45341072.0
2005-06-13 13:00:00	AAPL	Stock	1.2904	1.2918	1.2839	1.2843	40509840.0
2005-06-13 14:00:00	AAPL	Stock	1.2843	1.2896	1.2807	1.2857	53431084.0
2005-06-13 15:00:00	AAPL	Stock	1.2857	1.2861	1.2804	1.2818	69943720.0
2005-06-13 16:00:00	AAPL	Stock	1.2821	1.2846	1.2804	1.2821	2563064.0
2005-06-13 17:00:00	AAPL	Stock	1.2821	1.2821	1.2811	1.2811	144200.0
2005-06-13 18:00:00	AAPL	Stock	1.2811	1.2821	1.2804	1.2804	35000.0
2005-06-13 07:00:00	MSFT	Stock	25.4	25.4	25.38	25.38	4400.0
2005-06-13 08:00:00	MSFT	Stock	25.4	25.41	25.39	25.41	17208.0
2005-06-13 09:00:00	MSFT	Stock	25.39	25.42	25.34	25.34	4025678.0
2005-06-13 10:00:00	MSFT	Stock	25.35	25.46	25.26	25.4	8420270.0
2005-06-13 11:00:00	MSFT	Stock	25.4	25.49	25.38	25.44	3426612.0
2005-06-13 12:00:00	MSFT	Stock	25.45	25.46	25.36	25.401	3386048.0
2005-06-13 13:00:00	MSFT	Stock	25.4	25.44	25.32	25.35	4529239.0
2005-06-13 14:00:00	MSFT	Stock	25.36	25.45	25.35	25.37	5879844.0
2005-06-13 15:00:00	MSFT	Stock	25.38	25.41	25.3	25.3	8489945.0
2005-06-13 16:00:00	MSFT	Stock	25.3	25.32	25.29	25.3	2451455.0
2005-06-13 17:00:00	MSFT	Stock	25.32	25.33	25.3	25.3	2187.0
2005-06-13 18:00:00	MSFT	Stock	25.3	25.3	25.3	25.3	100.0
2005-06-13 09:00:00	NVDA	Stock	0.2333	0.24	0.2327	0.2398	170341320.0
2005-06-13 10:00:00	NVDA	Stock	0.2399	0.243	0.2388	0.243	372505560.0
2005-06-13 11:00:00	NVDA	Stock	0.243	0.2449	0.243	0.2438	157767600.0
2005-06-13 12:00:00	NVDA	Stock	0.2438	0.2444	0.2423	0.2426	128021280.0
2005-06-13 13:00:00	NVDA	Stock	0.2426	0.243	0.2395	0.2401	155206920.0
2005-06-13 14:00:00	NVDA	Stock	0.24	0.2405	0.2376	0.2389	186702240.0
2005-06-13 15:00:00	NVDA	Stock	0.2389	0.2392	0.2375	0.2381	163759560.0
2005-06-13 16:00:00	NVDA	Stock	0.2383	0.2383	0.2375	0.2381	5598720.0
2005-06-13 17:00:00	NVDA	Stock	0.2381	0.2425	0.2381	0.2425	276000.0
2005-06-13 18:00:00	NVDA	Stock	0.2379	0.2379	0.2376	0.2376	48000.0
2005-06-13 08:00:00	AMZN	Stock	1.7365	1.7365	1.7365	1.7365	14000.0
2005-06-13 09:00:00	AMZN	Stock	1.741	1.7425	1.7325	1.7425	7259000.0
2005-06-13 10:00:00	AMZN	Stock	1.742	1.7705	1.7385	1.765	19484820.0
2005-06-13 11:00:00	AMZN	Stock	1.765	1.7685	1.7615	1.7635	10319000.0
2005-06-13 12:00:00	AMZN	Stock	1.7635	1.7645	1.746	1.7505	7791660.0
2005-06-13 13:00:00	AMZN	Stock	1.75	1.751	1.7405	1.7405	6953620.0
2005-06-13 14:00:00	AMZN	Stock	1.741	1.7465	1.7345	1.7425	9305840.0
2005-06-13 15:00:00	AMZN	Stock	1.743	1.7465	1.736	1.7435	15831160.0
2005-06-13 16:00:00	AMZN	Stock	1.7435	1.7435	1.739	1.7435	256540.0
2005-06-13 09:00:00	CL	Stock	24.85	24.88	24.83	24.875	343600.0
2005-06-13 10:00:00	CL	Stock	24.875	24.925	24.765	24.925	472400.0
2005-06-13 11:00:00	CL	Stock	24.925	25.06	24.915	25.0175	500600.0
2005-06-13 12:00:00	CL	Stock	25.0175	25.02	24.91	24.925	143800.0
2005-06-13 13:00:00	CL	Stock	24.9295	24.96	24.86	24.87	165800.0
2005-06-13 14:00:00	CL	Stock	24.865	24.91	24.815	24.88	239800.0
2005-06-13 15:00:00	CL	Stock	24.875	24.89	24.805	24.845	527400.0
2005-06-13 16:00:00	CL	Stock	24.845	24.845	24.845	24.845	4600.0

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

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