PREVIEW / stock_1hour / 2006-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-17.parquet
  size:    591 KB
  rows:    28,457
  symbols: 2,317

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-17 04:00:00	AAPL	Stock	1.825	1.825	1.8107	1.8214	227108.0
2006-07-17 05:00:00	AAPL	Stock	1.8282	1.8282	1.8282	1.8282	28000.0
2006-07-17 06:00:00	AAPL	Stock	1.8214	1.8375	1.8214	1.8375	11200.0
2006-07-17 07:00:00	AAPL	Stock	1.8357	1.8482	1.8339	1.8446	365736.0
2006-07-17 08:00:00	AAPL	Stock	1.8393	1.8621	1.83	1.8475	11667124.0
2006-07-17 09:00:00	AAPL	Stock	1.8471	1.8732	1.8357	1.8493	184493232.0
2006-07-17 10:00:00	AAPL	Stock	1.8493	1.8714	1.8471	1.8714	208297544.0
2006-07-17 11:00:00	AAPL	Stock	1.8714	1.8957	1.8643	1.8889	199580192.0
2006-07-17 12:00:00	AAPL	Stock	1.8889	1.8904	1.8793	1.8807	77779352.0
2006-07-17 13:00:00	AAPL	Stock	1.8807	1.8911	1.8761	1.8886	69199900.0
2006-07-17 14:00:00	AAPL	Stock	1.8886	1.8968	1.8825	1.8868	96170620.0
2006-07-17 15:00:00	AAPL	Stock	1.8864	1.8882	1.8657	1.8671	169358336.0
2006-07-17 16:00:00	AAPL	Stock	1.8675	1.8729	1.8661	1.8696	1496236.0
2006-07-17 17:00:00	AAPL	Stock	1.8714	1.8757	1.8714	1.8746	357840.0
2006-07-17 18:00:00	AAPL	Stock	1.8736	1.8746	1.8714	1.8746	30100.0
2006-07-17 04:00:00	MSFT	Stock	22.2	22.2	22.2	22.2	100.0
2006-07-17 08:00:00	MSFT	Stock	22.25	22.25	22.19	22.23	29200.0
2006-07-17 09:00:00	MSFT	Stock	22.22	22.48	22.22	22.41	5516552.0
2006-07-17 10:00:00	MSFT	Stock	22.4	22.54	22.35	22.52	6976008.0
2006-07-17 11:00:00	MSFT	Stock	22.53	22.61	22.47	22.48	5591517.0
2006-07-17 12:00:00	MSFT	Stock	22.48	22.5	22.43	22.45	3085781.0
2006-07-17 13:00:00	MSFT	Stock	22.46	22.52	22.43	22.52	2874207.0
2006-07-17 14:00:00	MSFT	Stock	22.52	22.54	22.44	22.46	3348961.0
2006-07-17 15:00:00	MSFT	Stock	22.45	22.5	22.42	22.43	8072939.0
2006-07-17 16:00:00	MSFT	Stock	22.43	22.67	22.43	22.46	781473.0
2006-07-17 17:00:00	MSFT	Stock	22.5	22.55	22.5	22.55	1100.0
2006-07-17 18:00:00	MSFT	Stock	22.5	22.54	22.5	22.54	229.0
2006-07-17 08:00:00	NVDA	Stock	0.2967	0.2967	0.2933	0.2933	22200.0
2006-07-17 09:00:00	NVDA	Stock	0.2952	0.2988	0.2923	0.2958	48573240.0
2006-07-17 10:00:00	NVDA	Stock	0.2955	0.2973	0.2935	0.2953	79072140.0
2006-07-17 11:00:00	NVDA	Stock	0.2955	0.2998	0.2948	0.299	61145220.0
2006-07-17 12:00:00	NVDA	Stock	0.299	0.3002	0.2975	0.2991	53245620.0
2006-07-17 13:00:00	NVDA	Stock	0.2992	0.2993	0.2967	0.297	41675340.0
2006-07-17 14:00:00	NVDA	Stock	0.297	0.2997	0.2947	0.295	37674360.0
2006-07-17 15:00:00	NVDA	Stock	0.295	0.2982	0.2917	0.2967	157274160.0
2006-07-17 16:00:00	NVDA	Stock	0.2965	0.2968	0.2943	0.2962	2402940.0
2006-07-17 17:00:00	NVDA	Stock	0.2967	0.2975	0.2967	0.2975	74640.0
2006-07-17 08:00:00	AMZN	Stock	1.647	1.647	1.647	1.647	4000.0
2006-07-17 09:00:00	AMZN	Stock	1.645	1.6965	1.6325	1.683	24655580.0
2006-07-17 10:00:00	AMZN	Stock	1.6825	1.6845	1.6655	1.6755	24472980.0
2006-07-17 11:00:00	AMZN	Stock	1.6755	1.6795	1.651	1.6515	24588160.0
2006-07-17 12:00:00	AMZN	Stock	1.6515	1.6695	1.646	1.6575	16282940.0
2006-07-17 13:00:00	AMZN	Stock	1.6575	1.6795	1.6575	1.677	15625480.0
2006-07-17 14:00:00	AMZN	Stock	1.677	1.687	1.677	1.6825	13405940.0
2006-07-17 15:00:00	AMZN	Stock	1.6825	1.6885	1.6725	1.6835	22164880.0
2006-07-17 16:00:00	AMZN	Stock	1.684	1.6875	1.6835	1.685	480700.0
2006-07-17 17:00:00	AMZN	Stock	1.699	1.699	1.683	1.684	210000.0
2006-07-17 08:00:00	CL	Stock	30.505	30.505	30.505	30.505	1126400.0
2006-07-17 09:00:00	CL	Stock	30.475	30.545	30.415	30.525	212800.0
2006-07-17 10:00:00	CL	Stock	30.54	30.55	30.375	30.52	374400.0

> showing 50 of 28,457 rows — these rows as CSV

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