PREVIEW / stock_1hour / 2006-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-16.parquet
  size:    597 KB
  rows:    28,128
  symbols: 2,218

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-16 07:00:00	AAPL	Stock	2.3643	2.3686	2.3643	2.3686	31808.0
2006-03-16 08:00:00	AAPL	Stock	2.3679	2.3786	2.3611	2.3786	2853872.0
2006-03-16 09:00:00	AAPL	Stock	2.3768	2.3893	2.3482	2.3571	114926084.0
2006-03-16 10:00:00	AAPL	Stock	2.3579	2.3636	2.3343	2.335	134369956.0
2006-03-16 11:00:00	AAPL	Stock	2.3346	2.3879	2.3325	2.3493	75077100.0
2006-03-16 12:00:00	AAPL	Stock	2.3493	2.3571	2.3464	2.3468	60229568.0
2006-03-16 13:00:00	AAPL	Stock	2.3468	2.3479	2.3232	2.3254	88519088.0
2006-03-16 14:00:00	AAPL	Stock	2.3254	2.3321	2.3089	2.3093	105974344.0
2006-03-16 15:00:00	AAPL	Stock	2.3093	2.3214	2.2964	2.2968	154548996.0
2006-03-16 16:00:00	AAPL	Stock	2.2968	2.3	2.295	2.2982	2874396.0
2006-03-16 17:00:00	AAPL	Stock	2.2982	2.3032	2.2968	2.2975	771596.0
2006-03-16 18:00:00	AAPL	Stock	2.2979	2.3036	2.2964	2.3018	461888.0
2006-03-16 08:00:00	MSFT	Stock	27.34	27.4	27.32	27.4	133237.0
2006-03-16 09:00:00	MSFT	Stock	27.4	27.47	27.27	27.41	9790420.0
2006-03-16 10:00:00	MSFT	Stock	27.41	27.46	27.33	27.362	12367136.0
2006-03-16 11:00:00	MSFT	Stock	27.36	27.44	27.32	27.37	9723506.0
2006-03-16 12:00:00	MSFT	Stock	27.38	27.46	27.37	27.39	6351171.0
2006-03-16 13:00:00	MSFT	Stock	27.388	27.48	27.34	27.37	9793895.0
2006-03-16 14:00:00	MSFT	Stock	27.37	27.42	27.36	27.37	8515849.0
2006-03-16 15:00:00	MSFT	Stock	27.37	27.43	27.22	27.23	15241126.0
2006-03-16 16:00:00	MSFT	Stock	27.27	27.31	27.24	27.27	290680.0
2006-03-16 17:00:00	MSFT	Stock	27.27	27.27	27.24	27.26	8535.0
2006-03-16 08:00:00	NVDA	Stock	0.4167	0.419	0.4167	0.4187	324840.0
2006-03-16 09:00:00	NVDA	Stock	0.4187	0.4187	0.4125	0.4128	60913200.0
2006-03-16 10:00:00	NVDA	Stock	0.4128	0.415	0.4078	0.4106	92465280.0
2006-03-16 11:00:00	NVDA	Stock	0.4107	0.4132	0.4107	0.4119	63936360.0
2006-03-16 12:00:00	NVDA	Stock	0.412	0.4152	0.4114	0.4142	36054240.0
2006-03-16 13:00:00	NVDA	Stock	0.4142	0.4142	0.4083	0.4087	48326280.0
2006-03-16 14:00:00	NVDA	Stock	0.4088	0.4117	0.4062	0.4063	56736840.0
2006-03-16 15:00:00	NVDA	Stock	0.4063	0.4071	0.4017	0.403	185745480.0
2006-03-16 16:00:00	NVDA	Stock	0.4032	0.4033	0.4008	0.4032	1477200.0
2006-03-16 17:00:00	NVDA	Stock	0.4036	0.4036	0.4007	0.4017	399120.0
2006-03-16 18:00:00	NVDA	Stock	0.4032	0.4032	0.4032	0.4032	12000.0
2006-03-16 08:00:00	AMZN	Stock	1.84	1.84	1.84	1.84	20000.0
2006-03-16 09:00:00	AMZN	Stock	1.8475	1.8575	1.837	1.839	9118180.0
2006-03-16 10:00:00	AMZN	Stock	1.839	1.853	1.838	1.844	12681180.0
2006-03-16 11:00:00	AMZN	Stock	1.844	1.8525	1.8435	1.852	9964240.0
2006-03-16 12:00:00	AMZN	Stock	1.852	1.8695	1.85	1.864	16515960.0
2006-03-16 13:00:00	AMZN	Stock	1.864	1.8665	1.8555	1.8575	7702900.0
2006-03-16 14:00:00	AMZN	Stock	1.8575	1.8695	1.837	1.8455	18827620.0
2006-03-16 15:00:00	AMZN	Stock	1.8455	1.851	1.838	1.838	18237460.0
2006-03-16 16:00:00	AMZN	Stock	1.84	1.842	1.8375	1.8375	137600.0
2006-03-16 17:00:00	AMZN	Stock	1.838	1.8385	1.836	1.8385	53400.0
2006-03-16 09:00:00	CL	Stock	28.35	28.5	28.345	28.415	1266000.0
2006-03-16 10:00:00	CL	Stock	28.42	28.54	28.4	28.455	455600.0
2006-03-16 11:00:00	CL	Stock	28.45	28.47	28.375	28.375	617800.0
2006-03-16 12:00:00	CL	Stock	28.375	28.385	28.155	28.19	618000.0
2006-03-16 13:00:00	CL	Stock	28.19	28.26	28.155	28.22	474400.0
2006-03-16 14:00:00	CL	Stock	28.215	28.28	28.215	28.23	577400.0
2006-03-16 15:00:00	CL	Stock	28.23	28.325	28.165	28.315	1097400.0

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

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