PREVIEW / stock_1hour / 2006-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-27.parquet
  size:    620 KB
  rows:    29,628
  symbols: 2,315

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
2006-07-27 08:00:00	AAPL	Stock	2.3036	2.3161	2.2943	2.2982	2051644.0
2006-07-27 09:00:00	AAPL	Stock	2.2964	2.3179	2.295	2.3057	110241404.0
2006-07-27 10:00:00	AAPL	Stock	2.3057	2.3221	2.2929	2.3082	140858060.0
2006-07-27 11:00:00	AAPL	Stock	2.3079	2.3096	2.2729	2.275	115530576.0
2006-07-27 12:00:00	AAPL	Stock	2.275	2.2942	2.2714	2.2786	53976020.0
2006-07-27 13:00:00	AAPL	Stock	2.2786	2.3214	2.2521	2.2521	104698664.0
2006-07-27 14:00:00	AAPL	Stock	2.2521	2.2625	2.2461	2.2568	87298176.0
2006-07-27 15:00:00	AAPL	Stock	2.2568	2.2671	2.245	2.2643	111982108.0
2006-07-27 16:00:00	AAPL	Stock	2.2636	2.2668	2.2614	2.2646	1831480.0
2006-07-27 17:00:00	AAPL	Stock	2.2657	2.2668	2.2575	2.2596	155344.0
2006-07-27 18:00:00	AAPL	Stock	2.2625	2.2625	2.2604	2.2625	50176.0
2006-07-27 08:00:00	MSFT	Stock	24.4	24.45	24.38	24.45	34824.0
2006-07-27 09:00:00	MSFT	Stock	24.46	24.6	24.4	24.46	5635906.0
2006-07-27 10:00:00	MSFT	Stock	24.46	24.5	24.3	24.48	10055252.0
2006-07-27 11:00:00	MSFT	Stock	24.49	24.55	24.4	24.47	10369690.0
2006-07-27 12:00:00	MSFT	Stock	24.47	24.5	24.11	24.12	10002835.0
2006-07-27 13:00:00	MSFT	Stock	24.12	24.14	23.81	23.817	14492495.0
2006-07-27 14:00:00	MSFT	Stock	23.82	24.17	23.77	24.13	15276408.0
2006-07-27 15:00:00	MSFT	Stock	24.14	24.16	23.85	23.88	16094839.0
2006-07-27 16:00:00	MSFT	Stock	23.9	23.98	23.87	23.93	195960.0
2006-07-27 17:00:00	MSFT	Stock	23.95	23.95	23.868	23.94	7713.0
2006-07-27 18:00:00	MSFT	Stock	23.94	23.94	23.92	23.94	2364.0
2006-07-27 08:00:00	NVDA	Stock	0.3417	0.3445	0.3383	0.3445	90000.0
2006-07-27 09:00:00	NVDA	Stock	0.3417	0.3558	0.3417	0.3483	99957540.0
2006-07-27 10:00:00	NVDA	Stock	0.3483	0.3492	0.3433	0.3452	91821780.0
2006-07-27 11:00:00	NVDA	Stock	0.3452	0.3492	0.345	0.3461	147549960.0
2006-07-27 12:00:00	NVDA	Stock	0.346	0.3508	0.3452	0.3472	58422480.0
2006-07-27 13:00:00	NVDA	Stock	0.3472	0.3472	0.3373	0.3378	73333320.0
2006-07-27 14:00:00	NVDA	Stock	0.338	0.34	0.3362	0.3395	79271940.0
2006-07-27 15:00:00	NVDA	Stock	0.3397	0.3438	0.3393	0.342	128205720.0
2006-07-27 16:00:00	NVDA	Stock	0.3423	0.3433	0.3423	0.3433	431160.0
2006-07-27 17:00:00	NVDA	Stock	0.3433	0.3442	0.3433	0.3442	258000.0
2006-07-27 04:00:00	AMZN	Stock	1.3195	1.3195	1.3195	1.3195	2000.0
2006-07-27 05:00:00	AMZN	Stock	1.325	1.325	1.325	1.325	20000.0
2006-07-27 06:00:00	AMZN	Stock	1.325	1.325	1.325	1.325	12000.0
2006-07-27 07:00:00	AMZN	Stock	1.325	1.325	1.3165	1.3165	31120.0
2006-07-27 08:00:00	AMZN	Stock	1.3165	1.3245	1.313	1.32	1402920.0
2006-07-27 09:00:00	AMZN	Stock	1.3175	1.3275	1.3105	1.3245	69505800.0
2006-07-27 10:00:00	AMZN	Stock	1.324	1.331	1.319	1.3295	101283720.0
2006-07-27 11:00:00	AMZN	Stock	1.33	1.34	1.3	1.331	77372320.0
2006-07-27 12:00:00	AMZN	Stock	1.331	1.332	1.3225	1.329	65714340.0
2006-07-27 13:00:00	AMZN	Stock	1.3287	1.3325	1.3185	1.321	58734540.0
2006-07-27 14:00:00	AMZN	Stock	1.321	1.3285	1.319	1.328	43965340.0
2006-07-27 15:00:00	AMZN	Stock	1.328	1.329	1.324	1.3275	88770880.0
2006-07-27 16:00:00	AMZN	Stock	1.3265	1.328	1.3255	1.326	488420.0
2006-07-27 17:00:00	AMZN	Stock	1.326	1.3285	1.326	1.3285	43680.0
2006-07-27 18:00:00	AMZN	Stock	1.326	1.3285	1.3255	1.3285	20000.0
2006-07-27 09:00:00	CL	Stock	29.775	29.875	29.755	29.825	561600.0
2006-07-27 10:00:00	CL	Stock	29.83	29.84	29.635	29.73	629400.0
2006-07-27 11:00:00	CL	Stock	29.73	29.77	29.425	29.49	799000.0

> showing 50 of 29,628 rows — these rows as CSV

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