PREVIEW / stock_1hour / 2008-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-05.parquet
  size:    808 KB
  rows:    40,432
  symbols: 3,280

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-05 04:00:00	AAPL	Stock	3.9529	3.9529	3.9529	3.9529	8400.0
2008-11-05 06:00:00	AAPL	Stock	3.9425	3.9425	3.9282	3.9282	14000.0
2008-11-05 07:00:00	AAPL	Stock	3.9282	3.9289	3.8929	3.8929	677600.0
2008-11-05 08:00:00	AAPL	Stock	3.8954	3.9161	3.8857	3.9039	3457888.0
2008-11-05 09:00:00	AAPL	Stock	3.9036	3.9046	3.8304	3.8757	169984528.0
2008-11-05 10:00:00	AAPL	Stock	3.8761	3.9186	3.8625	3.8689	196621712.0
2008-11-05 11:00:00	AAPL	Stock	3.8696	3.8832	3.8429	3.8504	122340904.0
2008-11-05 12:00:00	AAPL	Stock	3.8507	3.8557	3.7796	3.8268	172381552.0
2008-11-05 13:00:00	AAPL	Stock	3.8268	3.8314	3.7704	3.7754	125955872.0
2008-11-05 14:00:00	AAPL	Stock	3.775	3.7971	3.7539	3.7618	170632028.0
2008-11-05 15:00:00	AAPL	Stock	3.7628	3.7832	3.6782	3.6879	265559476.0
2008-11-05 16:00:00	AAPL	Stock	3.6875	3.8136	3.65	3.65	20446664.0
2008-11-05 17:00:00	AAPL	Stock	3.6536	3.6893	3.6143	3.6346	2076340.0
2008-11-05 18:00:00	AAPL	Stock	3.6346	3.6368	3.6282	3.6339	517692.0
2008-11-05 19:00:00	AAPL	Stock	3.6321	3.6393	3.6286	3.6321	465304.0
2008-11-05 06:00:00	MSFT	Stock	23.75	23.75	23.75	23.75	100.0
2008-11-05 07:00:00	MSFT	Stock	23.5	23.5	23.15	23.29	3700.0
2008-11-05 08:00:00	MSFT	Stock	23.29	23.35	23.11	23.24	35786.0
2008-11-05 09:00:00	MSFT	Stock	23.25	23.34	23.11	23.175	5155493.0
2008-11-05 10:00:00	MSFT	Stock	23.18	23.34	23.15	23.25	8831654.0
2008-11-05 11:00:00	MSFT	Stock	23.25	23.3	22.74	22.91	10349346.0
2008-11-05 12:00:00	MSFT	Stock	22.91	22.93	22.57	22.77	8634993.0
2008-11-05 13:00:00	MSFT	Stock	22.77	22.85	22.64	22.69	8216223.0
2008-11-05 14:00:00	MSFT	Stock	22.69	22.8	22.53	22.688	9066892.0
2008-11-05 15:00:00	MSFT	Stock	22.68	22.8	22.05	22.08	21743688.0
2008-11-05 16:00:00	MSFT	Stock	22.08	23.206	21.89	22.0	5848260.0
2008-11-05 17:00:00	MSFT	Stock	22.0	22.1	21.91	21.95	92836.0
2008-11-05 18:00:00	MSFT	Stock	21.94	21.95	21.9	21.94	17172.0
2008-11-05 19:00:00	MSFT	Stock	21.94	21.95	21.88	21.88	15086.0
2008-11-05 08:00:00	NVDA	Stock	0.2225	0.225	0.215	0.2175	919200.0
2008-11-05 09:00:00	NVDA	Stock	0.2175	0.2212	0.2155	0.219	136428160.0
2008-11-05 10:00:00	NVDA	Stock	0.219	0.2225	0.2185	0.222	153623480.0
2008-11-05 11:00:00	NVDA	Stock	0.222	0.2225	0.2183	0.2208	115965120.0
2008-11-05 12:00:00	NVDA	Stock	0.2208	0.2212	0.2172	0.2189	55073400.0
2008-11-05 13:00:00	NVDA	Stock	0.219	0.2195	0.2178	0.2188	51705800.0
2008-11-05 14:00:00	NVDA	Stock	0.2188	0.22	0.2168	0.2175	82649320.0
2008-11-05 15:00:00	NVDA	Stock	0.2175	0.2198	0.2128	0.2135	170409120.0
2008-11-05 16:00:00	NVDA	Stock	0.2135	0.2192	0.2127	0.2145	3401520.0
2008-11-05 17:00:00	NVDA	Stock	0.2158	0.2158	0.21	0.2108	472800.0
2008-11-05 18:00:00	NVDA	Stock	0.211	0.212	0.2105	0.2108	204800.0
2008-11-05 19:00:00	NVDA	Stock	0.2125	0.217	0.2125	0.215	188920.0
2008-11-05 08:00:00	AMZN	Stock	2.89	2.89	2.865	2.875	134420.0
2008-11-05 09:00:00	AMZN	Stock	2.8655	2.9	2.7715	2.784	30789440.0
2008-11-05 10:00:00	AMZN	Stock	2.7835	2.8175	2.7575	2.777	30811400.0
2008-11-05 11:00:00	AMZN	Stock	2.7775	2.809	2.7255	2.7465	21499600.0
2008-11-05 12:00:00	AMZN	Stock	2.7475	2.7545	2.679	2.699	35641760.0
2008-11-05 13:00:00	AMZN	Stock	2.7	2.7095	2.6675	2.676	21998740.0
2008-11-05 14:00:00	AMZN	Stock	2.6752	2.6995	2.6525	2.662	27496060.0
2008-11-05 15:00:00	AMZN	Stock	2.6625	2.683	2.581	2.599	54227420.0
2008-11-05 16:00:00	AMZN	Stock	2.6005	2.8	2.5795	2.5795	6339360.0

> showing 50 of 40,432 rows — these rows as CSV

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