PREVIEW / stock_1hour / 2005-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-14.parquet
  size:    557 KB
  rows:    26,706
  symbols: 1,993

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-14 08:00:00	AAPL	Stock	1.2825	1.2936	1.2825	1.29	445760.0
2005-06-14 09:00:00	AAPL	Stock	1.29	1.2911	1.2775	1.2843	71281952.0
2005-06-14 10:00:00	AAPL	Stock	1.2846	1.2893	1.2768	1.2825	57610336.0
2005-06-14 11:00:00	AAPL	Stock	1.2825	1.2875	1.2807	1.2839	28848512.0
2005-06-14 12:00:00	AAPL	Stock	1.2836	1.2875	1.2818	1.2857	24755696.0
2005-06-14 13:00:00	AAPL	Stock	1.2857	1.2861	1.2786	1.2861	41123096.0
2005-06-14 14:00:00	AAPL	Stock	1.2861	1.2893	1.2796	1.2836	45024420.0
2005-06-14 15:00:00	AAPL	Stock	1.2832	1.2864	1.2811	1.285	69647508.0
2005-06-14 16:00:00	AAPL	Stock	1.2854	1.2893	1.2821	1.2875	1994328.0
2005-06-14 17:00:00	AAPL	Stock	1.2875	1.2875	1.2837	1.2857	1691312.0
2005-06-14 18:00:00	AAPL	Stock	1.2875	1.3068	1.2875	1.3029	3223444.0
2005-06-14 07:00:00	MSFT	Stock	25.31	25.31	25.31	25.31	2200.0
2005-06-14 08:00:00	MSFT	Stock	25.33	25.38	25.32	25.37	26898.0
2005-06-14 09:00:00	MSFT	Stock	25.36	25.44	25.268	25.41	7398245.0
2005-06-14 10:00:00	MSFT	Stock	25.41	25.42	25.29	25.33	7622552.0
2005-06-14 11:00:00	MSFT	Stock	25.34	25.41	25.29	25.31	5207917.0
2005-06-14 12:00:00	MSFT	Stock	25.31	25.32	25.24	25.31	4596911.0
2005-06-14 13:00:00	MSFT	Stock	25.31	25.39	25.25	25.39	5105480.0
2005-06-14 14:00:00	MSFT	Stock	25.39	25.4	25.25	25.29	6579378.0
2005-06-14 15:00:00	MSFT	Stock	25.29	25.37	25.27	25.37	6488706.0
2005-06-14 16:00:00	MSFT	Stock	25.36	25.4	25.35	25.37	312941.0
2005-06-14 17:00:00	MSFT	Stock	25.37	25.37	25.307	25.36	879605.0
2005-06-14 18:00:00	MSFT	Stock	25.36	25.36	25.321	25.321	3210.0
2005-06-14 08:00:00	NVDA	Stock	0.2383	0.2392	0.2382	0.2392	288000.0
2005-06-14 09:00:00	NVDA	Stock	0.2384	0.2423	0.238	0.242	104869800.0
2005-06-14 10:00:00	NVDA	Stock	0.242	0.242	0.2328	0.2332	238110480.0
2005-06-14 11:00:00	NVDA	Stock	0.2332	0.2337	0.2262	0.2262	369513000.0
2005-06-14 12:00:00	NVDA	Stock	0.2263	0.228	0.2235	0.2255	261324720.0
2005-06-14 13:00:00	NVDA	Stock	0.2256	0.2258	0.2196	0.2201	382126560.0
2005-06-14 14:00:00	NVDA	Stock	0.2201	0.2222	0.2167	0.222	562157760.0
2005-06-14 15:00:00	NVDA	Stock	0.2219	0.2242	0.2207	0.2242	449011440.0
2005-06-14 16:00:00	NVDA	Stock	0.2239	0.2242	0.2232	0.2233	7975800.0
2005-06-14 17:00:00	NVDA	Stock	0.2232	0.2344	0.2231	0.2233	928080.0
2005-06-14 18:00:00	NVDA	Stock	0.2227	0.2227	0.2226	0.2226	24000.0
2005-06-14 08:00:00	AMZN	Stock	1.7425	1.7445	1.7425	1.7445	30000.0
2005-06-14 09:00:00	AMZN	Stock	1.7445	1.7535	1.734	1.7525	11003760.0
2005-06-14 10:00:00	AMZN	Stock	1.752	1.7555	1.7475	1.7535	13516300.0
2005-06-14 11:00:00	AMZN	Stock	1.7535	1.7555	1.7485	1.754	8326720.0
2005-06-14 12:00:00	AMZN	Stock	1.7541	1.7585	1.751	1.756	4406740.0
2005-06-14 13:00:00	AMZN	Stock	1.756	1.756	1.752	1.754	9589420.0
2005-06-14 14:00:00	AMZN	Stock	1.754	1.7555	1.751	1.7525	9724680.0
2005-06-14 15:00:00	AMZN	Stock	1.7525	1.7565	1.7485	1.753	14848120.0
2005-06-14 16:00:00	AMZN	Stock	1.7535	1.754	1.75	1.754	507420.0
2005-06-14 17:00:00	AMZN	Stock	1.752	1.754	1.7486	1.7486	55300.0
2005-06-14 18:00:00	AMZN	Stock	1.755	1.755	1.755	1.755	2000.0
2005-06-14 09:00:00	CL	Stock	24.775	24.845	24.775	24.815	293600.0
2005-06-14 10:00:00	CL	Stock	24.815	24.85	24.75	24.765	475000.0
2005-06-14 11:00:00	CL	Stock	24.765	24.795	24.74	24.76	292600.0
2005-06-14 12:00:00	CL	Stock	24.76	24.8	24.735	24.79	252400.0
2005-06-14 13:00:00	CL	Stock	24.8	24.875	24.775	24.865	410000.0

> showing 50 of 26,706 rows — these rows as CSV

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