PREVIEW / stock_1hour / 2006-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-14.parquet
  size:    618 KB
  rows:    29,728
  symbols: 2,205

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-03-14 04:00:00	AAPL	Stock	2.3496	2.3496	2.3496	2.3496	4620.0
2006-03-14 05:00:00	AAPL	Stock	2.3446	2.3446	2.3446	2.3446	2800.0
2006-03-14 07:00:00	AAPL	Stock	2.3393	2.3432	2.3379	2.3393	22400.0
2006-03-14 08:00:00	AAPL	Stock	2.3393	2.3429	2.3236	2.3386	1683472.0
2006-03-14 09:00:00	AAPL	Stock	2.3386	2.3611	2.3382	2.3592	86373868.0
2006-03-14 10:00:00	AAPL	Stock	2.3589	2.3786	2.3557	2.3639	160346732.0
2006-03-14 11:00:00	AAPL	Stock	2.3636	2.3732	2.3593	2.3646	61888120.0
2006-03-14 12:00:00	AAPL	Stock	2.3646	2.3711	2.3646	2.3668	39882472.0
2006-03-14 13:00:00	AAPL	Stock	2.3675	2.3893	2.3668	2.3882	83322484.0
2006-03-14 14:00:00	AAPL	Stock	2.3886	2.3954	2.3807	2.3943	73872736.0
2006-03-14 15:00:00	AAPL	Stock	2.3943	2.4043	2.3911	2.4043	119325136.0
2006-03-14 16:00:00	AAPL	Stock	2.4036	2.4143	2.3779	2.4089	5196184.0
2006-03-14 17:00:00	AAPL	Stock	2.4089	2.4143	2.4079	2.4143	672700.0
2006-03-14 18:00:00	AAPL	Stock	2.4143	2.4193	2.4143	2.4143	292460.0
2006-03-14 05:00:00	MSFT	Stock	26.93	26.93	26.93	26.93	200.0
2006-03-14 06:00:00	MSFT	Stock	27.08	27.3	27.08	27.3	5000.0
2006-03-14 08:00:00	MSFT	Stock	27.1	27.1	27.03	27.07	5710.0
2006-03-14 09:00:00	MSFT	Stock	27.04	27.28	26.98	27.25	4485995.0
2006-03-14 10:00:00	MSFT	Stock	27.26	27.27	27.13	27.22	4485571.0
2006-03-14 11:00:00	MSFT	Stock	27.23	27.25	27.18	27.225	2782446.0
2006-03-14 12:00:00	MSFT	Stock	27.22	27.27	27.2	27.212	3178268.0
2006-03-14 13:00:00	MSFT	Stock	27.21	27.38	27.21	27.28	7631655.0
2006-03-14 14:00:00	MSFT	Stock	27.27	27.31	27.26	27.282	3921866.0
2006-03-14 15:00:00	MSFT	Stock	27.28	27.32	27.2	27.2	11708923.0
2006-03-14 16:00:00	MSFT	Stock	27.19	27.23	27.16	27.16	316961.0
2006-03-14 17:00:00	MSFT	Stock	27.19	27.2	27.18	27.2	3600.0
2006-03-14 18:00:00	MSFT	Stock	27.2	27.23	27.2	27.23	1534.0
2006-03-14 09:00:00	NVDA	Stock	0.4001	0.4084	0.3985	0.4073	73389000.0
2006-03-14 10:00:00	NVDA	Stock	0.4074	0.4098	0.4045	0.4057	72685680.0
2006-03-14 11:00:00	NVDA	Stock	0.4058	0.4112	0.4048	0.4102	75294720.0
2006-03-14 12:00:00	NVDA	Stock	0.4104	0.4124	0.4033	0.4078	139866840.0
2006-03-14 13:00:00	NVDA	Stock	0.4079	0.4102	0.4072	0.4084	61818720.0
2006-03-14 14:00:00	NVDA	Stock	0.4085	0.4107	0.4078	0.4095	49417320.0
2006-03-14 15:00:00	NVDA	Stock	0.4095	0.4113	0.4093	0.4107	100370760.0
2006-03-14 16:00:00	NVDA	Stock	0.4105	0.4114	0.4088	0.411	42304320.0
2006-03-14 17:00:00	NVDA	Stock	0.4104	0.411	0.4104	0.411	108000.0
2006-03-14 18:00:00	NVDA	Stock	0.411	0.411	0.411	0.411	30000.0
2006-03-14 09:00:00	AMZN	Stock	1.812	1.84	1.8005	1.8305	9474140.0
2006-03-14 10:00:00	AMZN	Stock	1.8305	1.833	1.81	1.822	11185760.0
2006-03-14 11:00:00	AMZN	Stock	1.822	1.8275	1.819	1.8225	7684820.0
2006-03-14 12:00:00	AMZN	Stock	1.8235	1.8245	1.816	1.8215	5108800.0
2006-03-14 13:00:00	AMZN	Stock	1.821	1.848	1.8175	1.8325	14403120.0
2006-03-14 14:00:00	AMZN	Stock	1.8325	1.849	1.8315	1.8445	15087680.0
2006-03-14 15:00:00	AMZN	Stock	1.844	1.85	1.837	1.847	18642460.0
2006-03-14 16:00:00	AMZN	Stock	1.848	1.851	1.8425	1.851	117020.0
2006-03-14 08:00:00	CL	Stock	28.65	28.7	28.585	28.59	14000.0
2006-03-14 09:00:00	CL	Stock	28.59	28.67	28.51	28.67	1024000.0
2006-03-14 10:00:00	CL	Stock	28.655	28.66	28.45	28.465	1204400.0
2006-03-14 11:00:00	CL	Stock	28.48	28.53	28.35	28.35	823000.0
2006-03-14 12:00:00	CL	Stock	28.33	28.435	28.21	28.295	2775600.0

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

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