PREVIEW / stock_1hour / 2006-05-22

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-22.parquet
  size:    631 KB
  rows:    29,732
  symbols: 2,271

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-05-22 07:00:00	AAPL	Stock	2.2732	2.2821	2.2732	2.2732	21000.0
2006-05-22 08:00:00	AAPL	Stock	2.2821	2.2889	2.2804	2.2846	1733872.0
2006-05-22 09:00:00	AAPL	Stock	2.2857	2.2857	2.2639	2.2675	93606744.0
2006-05-22 10:00:00	AAPL	Stock	2.2675	2.2764	2.2486	2.2625	128150260.0
2006-05-22 11:00:00	AAPL	Stock	2.2625	2.2809	2.245	2.2525	116611236.0
2006-05-22 12:00:00	AAPL	Stock	2.2532	2.2771	2.2518	2.2582	109873260.0
2006-05-22 13:00:00	AAPL	Stock	2.2582	2.2646	2.25	2.255	72232832.0
2006-05-22 14:00:00	AAPL	Stock	2.2557	2.2618	2.2418	2.2536	76549844.0
2006-05-22 15:00:00	AAPL	Stock	2.2536	2.2814	2.2521	2.2632	108983028.0
2006-05-22 16:00:00	AAPL	Stock	2.2632	2.2643	2.2604	2.2636	1134812.0
2006-05-22 17:00:00	AAPL	Stock	2.2625	2.2636	2.2579	2.2579	3372628.0
2006-05-22 18:00:00	AAPL	Stock	2.2589	2.2618	2.2589	2.2589	61600.0
2006-05-22 04:00:00	MSFT	Stock	22.51	22.51	22.51	22.51	200.0
2006-05-22 05:00:00	MSFT	Stock	22.37	22.37	22.37	22.37	300.0
2006-05-22 06:00:00	MSFT	Stock	22.34	22.39	22.34	22.39	800.0
2006-05-22 07:00:00	MSFT	Stock	22.39	22.45	22.39	22.44	16300.0
2006-05-22 08:00:00	MSFT	Stock	22.46	22.51	22.43	22.47	112581.0
2006-05-22 09:00:00	MSFT	Stock	22.46	22.76	22.45	22.63	10567875.0
2006-05-22 10:00:00	MSFT	Stock	22.64	22.79	22.52	22.68	12842776.0
2006-05-22 11:00:00	MSFT	Stock	22.69	22.77	22.6	22.752	11950440.0
2006-05-22 12:00:00	MSFT	Stock	22.75	22.96	22.73	22.81	13393933.0
2006-05-22 13:00:00	MSFT	Stock	22.813	22.92	22.78	22.85	8022154.0
2006-05-22 14:00:00	MSFT	Stock	22.85	22.95	22.75	22.85	9931309.0
2006-05-22 15:00:00	MSFT	Stock	22.84	23.02	22.82	22.86	15331558.0
2006-05-22 16:00:00	MSFT	Stock	22.87	22.91	22.8	22.87	643446.0
2006-05-22 17:00:00	MSFT	Stock	22.88	22.88	22.86	22.88	212314.0
2006-05-22 18:00:00	MSFT	Stock	22.88	22.88	22.88	22.88	3233.0
2006-05-22 08:00:00	NVDA	Stock	0.4042	0.4055	0.3992	0.3992	87000.0
2006-05-22 09:00:00	NVDA	Stock	0.3992	0.4047	0.3902	0.397	85456800.0
2006-05-22 10:00:00	NVDA	Stock	0.397	0.3982	0.389	0.3925	103589280.0
2006-05-22 11:00:00	NVDA	Stock	0.3923	0.4038	0.3908	0.3957	105323040.0
2006-05-22 12:00:00	NVDA	Stock	0.3958	0.4008	0.395	0.3997	99198720.0
2006-05-22 13:00:00	NVDA	Stock	0.4	0.4003	0.3945	0.3967	67328460.0
2006-05-22 14:00:00	NVDA	Stock	0.3967	0.3997	0.3938	0.3952	109958400.0
2006-05-22 15:00:00	NVDA	Stock	0.3952	0.401	0.3945	0.3998	128058000.0
2006-05-22 16:00:00	NVDA	Stock	0.4	0.401	0.3998	0.4	2486940.0
2006-05-22 17:00:00	NVDA	Stock	0.4	0.4	0.4	0.4	378120.0
2006-05-22 18:00:00	NVDA	Stock	0.3987	0.4003	0.3987	0.4003	36000.0
2006-05-22 06:00:00	AMZN	Stock	1.7	1.7	1.7	1.7	6400.0
2006-05-22 07:00:00	AMZN	Stock	1.6755	1.6755	1.6755	1.6755	12000.0
2006-05-22 08:00:00	AMZN	Stock	1.6895	1.7	1.6865	1.7	240120.0
2006-05-22 09:00:00	AMZN	Stock	1.7035	1.7035	1.659	1.6665	19905960.0
2006-05-22 10:00:00	AMZN	Stock	1.666	1.698	1.659	1.682	21796140.0
2006-05-22 11:00:00	AMZN	Stock	1.682	1.71	1.6745	1.704	33677320.0
2006-05-22 12:00:00	AMZN	Stock	1.7045	1.7495	1.7045	1.7205	44523720.0
2006-05-22 13:00:00	AMZN	Stock	1.721	1.7215	1.6925	1.6945	18491260.0
2006-05-22 14:00:00	AMZN	Stock	1.694	1.7115	1.683	1.701	28023360.0
2006-05-22 15:00:00	AMZN	Stock	1.701	1.7425	1.699	1.7405	50444060.0
2006-05-22 16:00:00	AMZN	Stock	1.7415	1.7415	1.74	1.74	777340.0
2006-05-22 17:00:00	AMZN	Stock	1.738	1.7414	1.7375	1.7375	87100.0

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

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