PREVIEW / stock_1hour / 2008-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-07.parquet
  size:    779 KB
  rows:    39,577
  symbols: 3,282

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
2008-11-07 07:00:00	AAPL	Stock	3.6179	3.6179	3.5625	3.5625	213472.0
2008-11-07 08:00:00	AAPL	Stock	3.5714	3.5786	3.5289	3.5293	5635980.0
2008-11-07 09:00:00	AAPL	Stock	3.5336	3.5571	3.4186	3.4432	174137096.0
2008-11-07 10:00:00	AAPL	Stock	3.4436	3.5661	3.4418	3.5282	243294128.0
2008-11-07 11:00:00	AAPL	Stock	3.5289	3.5321	3.4704	3.5229	150795372.0
2008-11-07 12:00:00	AAPL	Stock	3.5236	3.5461	3.5139	3.5393	92024520.0
2008-11-07 13:00:00	AAPL	Stock	3.5404	3.5532	3.5007	3.5286	81994640.0
2008-11-07 14:00:00	AAPL	Stock	3.5286	3.5482	3.4743	3.475	106957396.0
2008-11-07 15:00:00	AAPL	Stock	3.4754	3.5082	3.4404	3.5075	214387684.0
2008-11-07 16:00:00	AAPL	Stock	3.5082	3.5321	3.4752	3.5182	17811332.0
2008-11-07 17:00:00	AAPL	Stock	3.5182	3.52	3.5086	3.5143	574840.0
2008-11-07 18:00:00	AAPL	Stock	3.515	3.5232	3.5125	3.5232	449512.0
2008-11-07 19:00:00	AAPL	Stock	3.5232	3.5264	3.5196	3.5254	272664.0
2008-11-07 07:00:00	MSFT	Stock	21.38	21.45	21.11	21.11	2040.0
2008-11-07 08:00:00	MSFT	Stock	21.2	21.3	21.05	21.18	156699.0
2008-11-07 09:00:00	MSFT	Stock	21.16	21.39	21.0	21.13	7386109.0
2008-11-07 10:00:00	MSFT	Stock	21.13	21.48	21.12	21.4	13591907.0
2008-11-07 11:00:00	MSFT	Stock	21.4	21.43	21.21	21.42	8623835.0
2008-11-07 12:00:00	MSFT	Stock	21.42	21.5	21.26	21.38	6380862.0
2008-11-07 13:00:00	MSFT	Stock	21.38	21.45	21.23	21.41	6101492.0
2008-11-07 14:00:00	MSFT	Stock	21.43	21.49	21.15	21.15	7330730.0
2008-11-07 15:00:00	MSFT	Stock	21.15	21.54	21.03	21.53	16602389.0
2008-11-07 16:00:00	MSFT	Stock	21.53	21.64	21.262	21.5	2882926.0
2008-11-07 17:00:00	MSFT	Stock	21.5	21.56	21.5	21.5	460110.0
2008-11-07 18:00:00	MSFT	Stock	21.56	21.61	21.53	21.56	9369.0
2008-11-07 19:00:00	MSFT	Stock	21.53	21.6	21.53	21.6	400.0
2008-11-07 07:00:00	NVDA	Stock	0.2158	0.2158	0.2118	0.2118	44000.0
2008-11-07 08:00:00	NVDA	Stock	0.215	0.2215	0.2115	0.2125	6912720.0
2008-11-07 09:00:00	NVDA	Stock	0.2125	0.2232	0.2025	0.2132	389019760.0
2008-11-07 10:00:00	NVDA	Stock	0.2132	0.2268	0.2132	0.2195	257062400.0
2008-11-07 11:00:00	NVDA	Stock	0.2195	0.2218	0.2155	0.2175	106555440.0
2008-11-07 12:00:00	NVDA	Stock	0.2175	0.2212	0.215	0.2198	70798040.0
2008-11-07 13:00:00	NVDA	Stock	0.22	0.2212	0.2183	0.2205	47310680.0
2008-11-07 14:00:00	NVDA	Stock	0.2208	0.2212	0.2152	0.2152	71428560.0
2008-11-07 15:00:00	NVDA	Stock	0.2152	0.218	0.2128	0.218	150284640.0
2008-11-07 16:00:00	NVDA	Stock	0.2178	0.2223	0.2158	0.218	7080800.0
2008-11-07 17:00:00	NVDA	Stock	0.218	0.22	0.218	0.218	490600.0
2008-11-07 18:00:00	NVDA	Stock	0.2175	0.219	0.2175	0.219	154160.0
2008-11-07 19:00:00	NVDA	Stock	0.219	0.219	0.217	0.217	36000.0
2008-11-07 08:00:00	AMZN	Stock	2.3945	2.4195	2.3675	2.3925	528420.0
2008-11-07 09:00:00	AMZN	Stock	2.3785	2.4405	2.3505	2.3875	23934780.0
2008-11-07 10:00:00	AMZN	Stock	2.3875	2.4825	2.3875	2.435	27600060.0
2008-11-07 11:00:00	AMZN	Stock	2.4355	2.44	2.385	2.421	18548060.0
2008-11-07 12:00:00	AMZN	Stock	2.4215	2.4425	2.4	2.435	9753240.0
2008-11-07 13:00:00	AMZN	Stock	2.4355	2.4625	2.431	2.456	12566280.0
2008-11-07 14:00:00	AMZN	Stock	2.4572	2.4895	2.4335	2.4335	18864000.0
2008-11-07 15:00:00	AMZN	Stock	2.4335	2.466	2.408	2.4605	30523740.0
2008-11-07 16:00:00	AMZN	Stock	2.4605	2.474	2.425	2.4705	4940900.0
2008-11-07 17:00:00	AMZN	Stock	2.4605	2.4675	2.4605	2.4675	133940.0
2008-11-07 19:00:00	AMZN	Stock	2.4745	2.4745	2.474	2.474	5000.0

> showing 50 of 39,577 rows — these rows as CSV

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