PREVIEW / stock_1hour / 2005-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-07.parquet
  size:    559 KB
  rows:    26,922
  symbols: 1,990

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-07 08:00:00	AAPL	Stock	1.3561	1.3632	1.3304	1.3436	2698332.0
2005-06-07 09:00:00	AAPL	Stock	1.3443	1.3489	1.3021	1.3193	191506112.0
2005-06-07 10:00:00	AAPL	Stock	1.3193	1.3243	1.3096	1.3229	134756300.0
2005-06-07 11:00:00	AAPL	Stock	1.3229	1.3279	1.315	1.3214	81860940.0
2005-06-07 12:00:00	AAPL	Stock	1.3214	1.3218	1.3186	1.3204	42975408.0
2005-06-07 13:00:00	AAPL	Stock	1.3204	1.3214	1.3121	1.3146	58955484.0
2005-06-07 14:00:00	AAPL	Stock	1.315	1.3204	1.3046	1.3179	99288532.0
2005-06-07 15:00:00	AAPL	Stock	1.3182	1.3182	1.3018	1.3054	122794252.0
2005-06-07 16:00:00	AAPL	Stock	1.3054	1.3089	1.3036	1.3071	2967132.0
2005-06-07 17:00:00	AAPL	Stock	1.3064	1.3543	1.3039	1.305	1255884.0
2005-06-07 18:00:00	AAPL	Stock	1.305	1.3054	1.305	1.305	107100.0
2005-06-07 07:00:00	MSFT	Stock	25.45	25.45	25.45	25.45	800.0
2005-06-07 08:00:00	MSFT	Stock	25.44	25.52	25.38	25.38	104748.0
2005-06-07 09:00:00	MSFT	Stock	25.4	25.55	25.3	25.54	7499329.0
2005-06-07 10:00:00	MSFT	Stock	25.54	25.77	25.325	25.76	11817258.0
2005-06-07 11:00:00	MSFT	Stock	25.75	25.83	25.74	25.77	7977509.0
2005-06-07 12:00:00	MSFT	Stock	25.77	25.78	25.69	25.72	3917717.0
2005-06-07 13:00:00	MSFT	Stock	25.73	25.77	25.62	25.66	4240330.0
2005-06-07 14:00:00	MSFT	Stock	25.67	25.67	25.5	25.57	8962000.0
2005-06-07 15:00:00	MSFT	Stock	25.58	25.59	25.49	25.51	7544967.0
2005-06-07 16:00:00	MSFT	Stock	25.51	25.53	25.49	25.52	806959.0
2005-06-07 17:00:00	MSFT	Stock	25.52	25.54	25.506	25.53	62516.0
2005-06-07 08:00:00	NVDA	Stock	0.2344	0.2367	0.23	0.2317	18996000.0
2005-06-07 09:00:00	NVDA	Stock	0.2317	0.2333	0.2308	0.2327	172429800.0
2005-06-07 10:00:00	NVDA	Stock	0.2327	0.2358	0.2322	0.2357	162760320.0
2005-06-07 11:00:00	NVDA	Stock	0.2357	0.2358	0.2345	0.2347	47765760.0
2005-06-07 12:00:00	NVDA	Stock	0.2347	0.2348	0.234	0.2343	44872920.0
2005-06-07 13:00:00	NVDA	Stock	0.2342	0.2347	0.2313	0.2324	113173080.0
2005-06-07 14:00:00	NVDA	Stock	0.2325	0.2328	0.2312	0.2319	134824680.0
2005-06-07 15:00:00	NVDA	Stock	0.2317	0.2318	0.2271	0.2282	246417000.0
2005-06-07 16:00:00	NVDA	Stock	0.2279	0.2286	0.2274	0.228	16723080.0
2005-06-07 17:00:00	NVDA	Stock	0.2287	0.229	0.2283	0.229	300000.0
2005-06-07 08:00:00	AMZN	Stock	1.7895	1.7925	1.7895	1.7925	22000.0
2005-06-07 09:00:00	AMZN	Stock	1.793	1.8095	1.793	1.799	8967240.0
2005-06-07 10:00:00	AMZN	Stock	1.799	1.81	1.795	1.7995	15961900.0
2005-06-07 11:00:00	AMZN	Stock	1.8	1.8035	1.7865	1.8	13127900.0
2005-06-07 12:00:00	AMZN	Stock	1.7995	1.8025	1.794	1.8015	5823000.0
2005-06-07 13:00:00	AMZN	Stock	1.8015	1.8035	1.78	1.7835	10706340.0
2005-06-07 14:00:00	AMZN	Stock	1.7836	1.789	1.77	1.772	19656100.0
2005-06-07 15:00:00	AMZN	Stock	1.772	1.7725	1.7645	1.767	21317440.0
2005-06-07 16:00:00	AMZN	Stock	1.768	1.7685	1.765	1.7655	197300.0
2005-06-07 17:00:00	AMZN	Stock	1.7675	1.7675	1.7674	1.7674	148300.0
2005-06-07 18:00:00	AMZN	Stock	1.7675	1.7675	1.7675	1.7675	10000.0
2005-06-07 09:00:00	CL	Stock	24.45	24.64	24.45	24.64	627000.0
2005-06-07 10:00:00	CL	Stock	24.64	24.84	24.64	24.79	564800.0
2005-06-07 11:00:00	CL	Stock	24.795	24.8635	24.755	24.855	548600.0
2005-06-07 12:00:00	CL	Stock	24.855	24.9	24.835	24.89	400000.0
2005-06-07 13:00:00	CL	Stock	24.89	24.91	24.875	24.895	461800.0
2005-06-07 14:00:00	CL	Stock	24.9	24.91	24.81	24.89	697000.0
2005-06-07 15:00:00	CL	Stock	24.89	24.94	24.825	24.835	1170800.0

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

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