PREVIEW / stock_1hour / 2005-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-09.parquet
  size:    573 KB
  rows:    27,144
  symbols: 1,934

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
2005-03-09 08:00:00	AAPL	Stock	1.4521	1.4529	1.4	1.4086	13659128.0
2005-03-09 09:00:00	AAPL	Stock	1.4086	1.4464	1.3914	1.4046	268660112.0
2005-03-09 10:00:00	AAPL	Stock	1.4039	1.4296	1.3868	1.4229	358532692.0
2005-03-09 11:00:00	AAPL	Stock	1.4232	1.425	1.4054	1.4089	115998736.0
2005-03-09 12:00:00	AAPL	Stock	1.4089	1.4093	1.3914	1.3921	148328404.0
2005-03-09 13:00:00	AAPL	Stock	1.3921	1.4014	1.3886	1.3982	116366096.0
2005-03-09 14:00:00	AAPL	Stock	1.3979	1.4075	1.3936	1.4061	99215648.0
2005-03-09 15:00:00	AAPL	Stock	1.4061	1.4179	1.3982	1.4061	180531092.0
2005-03-09 16:00:00	AAPL	Stock	1.4075	1.4082	1.4021	1.4054	3023244.0
2005-03-09 17:00:00	AAPL	Stock	1.4036	1.4061	1.4036	1.4061	520212.0
2005-03-09 18:00:00	AAPL	Stock	1.4061	1.4068	1.4043	1.4054	508480.0
2005-03-09 08:00:00	MSFT	Stock	25.4	25.45	25.38	25.39	115050.0
2005-03-09 09:00:00	MSFT	Stock	25.39	25.46	25.31	25.34	7463076.0
2005-03-09 10:00:00	MSFT	Stock	25.33	25.57	25.33	25.53	10935783.0
2005-03-09 11:00:00	MSFT	Stock	25.53	25.53	25.46	25.51	8101097.0
2005-03-09 12:00:00	MSFT	Stock	25.5	25.51	25.32	25.35	6984633.0
2005-03-09 13:00:00	MSFT	Stock	25.35	25.41	25.34	25.4	6995310.0
2005-03-09 14:00:00	MSFT	Stock	25.4	25.5	25.36	25.37	6551720.0
2005-03-09 15:00:00	MSFT	Stock	25.37	25.42	25.28	25.31	12217044.0
2005-03-09 16:00:00	MSFT	Stock	25.34	25.35	25.28	25.33	906485.0
2005-03-09 17:00:00	MSFT	Stock	25.34	25.37	25.31	25.33	26688.0
2005-03-09 18:00:00	MSFT	Stock	25.32	25.32	25.31	25.31	12016.0
2005-03-09 08:00:00	NVDA	Stock	0.2204	0.2204	0.2196	0.2196	738000.0
2005-03-09 09:00:00	NVDA	Stock	0.2196	0.223	0.2167	0.2195	209185200.0
2005-03-09 10:00:00	NVDA	Stock	0.2194	0.2212	0.2187	0.2209	150152760.0
2005-03-09 11:00:00	NVDA	Stock	0.2209	0.2217	0.2207	0.2214	74911080.0
2005-03-09 12:00:00	NVDA	Stock	0.2215	0.2216	0.2176	0.2177	87803880.0
2005-03-09 13:00:00	NVDA	Stock	0.2177	0.2183	0.2167	0.218	89280840.0
2005-03-09 14:00:00	NVDA	Stock	0.218	0.2187	0.2158	0.2165	104106600.0
2005-03-09 15:00:00	NVDA	Stock	0.2166	0.2167	0.2139	0.2145	179792040.0
2005-03-09 16:00:00	NVDA	Stock	0.2145	0.2148	0.2143	0.2143	2723040.0
2005-03-09 17:00:00	NVDA	Stock	0.2148	0.2148	0.2143	0.2143	1144200.0
2005-03-09 08:00:00	AMZN	Stock	1.7895	1.7955	1.7875	1.79	85400.0
2005-03-09 09:00:00	AMZN	Stock	1.79	1.7965	1.769	1.77	14380840.0
2005-03-09 10:00:00	AMZN	Stock	1.7695	1.7885	1.7675	1.779	23617540.0
2005-03-09 11:00:00	AMZN	Stock	1.7785	1.7795	1.762	1.762	13438920.0
2005-03-09 12:00:00	AMZN	Stock	1.762	1.7635	1.745	1.748	17171700.0
2005-03-09 13:00:00	AMZN	Stock	1.748	1.759	1.746	1.7585	14409320.0
2005-03-09 14:00:00	AMZN	Stock	1.759	1.767	1.7475	1.766	13152320.0
2005-03-09 15:00:00	AMZN	Stock	1.766	1.825	1.759	1.769	43776760.0
2005-03-09 16:00:00	AMZN	Stock	1.77	1.7825	1.7685	1.7715	3806560.0
2005-03-09 17:00:00	AMZN	Stock	1.775	1.775	1.77	1.77	203520.0
2005-03-09 09:00:00	CL	Stock	26.28	26.325	26.165	26.27	251400.0
2005-03-09 10:00:00	CL	Stock	26.27	26.365	26.21	26.325	422800.0
2005-03-09 11:00:00	CL	Stock	26.32	26.36	26.155	26.175	390600.0
2005-03-09 12:00:00	CL	Stock	26.17	26.19	25.935	25.935	422000.0
2005-03-09 13:00:00	CL	Stock	25.935	26.05	25.935	25.95	632200.0
2005-03-09 14:00:00	CL	Stock	25.95	25.975	25.9	25.915	479600.0
2005-03-09 15:00:00	CL	Stock	25.91	25.915	25.85	25.895	1224800.0
2005-03-09 16:00:00	CL	Stock	25.873	25.873	25.873	25.873	3800.0

> showing 50 of 27,144 rows — these rows as CSV

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