PREVIEW / stock_1hour / 2008-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-24.parquet
  size:    820 KB
  rows:    41,001
  symbols: 3,264

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-01-24 06:00:00	AAPL	Stock	5.0446	5.0893	5.0446	5.0714	151060.0
2008-01-24 07:00:00	AAPL	Stock	5.0714	5.0732	5.0129	5.0129	1684816.0
2008-01-24 08:00:00	AAPL	Stock	5.0161	5.0325	4.9607	4.9807	9139424.0
2008-01-24 09:00:00	AAPL	Stock	4.9857	5.025	4.9064	5.0	282842756.0
2008-01-24 10:00:00	AAPL	Stock	5.0	5.0211	4.825	4.8311	389068904.0
2008-01-24 11:00:00	AAPL	Stock	4.8321	4.8575	4.7321	4.8189	338339736.0
2008-01-24 12:00:00	AAPL	Stock	4.8186	4.8518	4.7686	4.7954	164274488.0
2008-01-24 13:00:00	AAPL	Stock	4.7957	4.7971	4.7414	4.7464	177322656.0
2008-01-24 14:00:00	AAPL	Stock	4.7464	4.8279	4.7146	4.7689	263358872.0
2008-01-24 15:00:00	AAPL	Stock	4.7689	4.8486	4.75	4.8404	287846664.0
2008-01-24 16:00:00	AAPL	Stock	4.8425	4.9286	4.8025	4.925	87629668.0
2008-01-24 17:00:00	AAPL	Stock	4.9268	4.9268	4.8429	4.9214	2697716.0
2008-01-24 18:00:00	AAPL	Stock	4.9214	4.9225	4.9054	4.9196	1035888.0
2008-01-24 19:00:00	AAPL	Stock	4.9196	4.9243	4.9125	4.9214	788956.0
2008-01-24 07:00:00	MSFT	Stock	32.21	32.3	32.21	32.25	7200.0
2008-01-24 08:00:00	MSFT	Stock	32.25	32.4	32.15	32.35	288089.0
2008-01-24 09:00:00	MSFT	Stock	32.34	32.64	32.15	32.42	16008352.0
2008-01-24 10:00:00	MSFT	Stock	32.43	32.56	32.12	32.32	21162586.0
2008-01-24 11:00:00	MSFT	Stock	32.32	32.87	32.25	32.762	16042201.0
2008-01-24 12:00:00	MSFT	Stock	32.76	32.79	32.5	32.69	10051412.0
2008-01-24 13:00:00	MSFT	Stock	32.69	32.73	32.54	32.68	9242063.0
2008-01-24 14:00:00	MSFT	Stock	32.68	33.17	32.58	33.11	27709194.0
2008-01-24 15:00:00	MSFT	Stock	33.11	33.36	32.695	33.24	34046014.0
2008-01-24 16:00:00	MSFT	Stock	33.24	35.32	32.39	35.3	18606511.0
2008-01-24 17:00:00	MSFT	Stock	35.29	35.31	33.25	34.81	2204637.0
2008-01-24 18:00:00	MSFT	Stock	34.8	34.84	34.65	34.7	236699.0
2008-01-24 19:00:00	MSFT	Stock	34.7	34.8	34.7	34.75	111476.0
2008-01-24 08:00:00	NVDA	Stock	0.6125	0.618	0.6063	0.6133	190800.0
2008-01-24 09:00:00	NVDA	Stock	0.615	0.6362	0.6068	0.6253	71426160.0
2008-01-24 10:00:00	NVDA	Stock	0.6253	0.6355	0.6193	0.6238	90951280.0
2008-01-24 11:00:00	NVDA	Stock	0.6238	0.635	0.6158	0.632	63345720.0
2008-01-24 12:00:00	NVDA	Stock	0.6315	0.6325	0.6225	0.629	51957840.0
2008-01-24 13:00:00	NVDA	Stock	0.629	0.6328	0.6225	0.6305	46576880.0
2008-01-24 14:00:00	NVDA	Stock	0.6305	0.6375	0.6275	0.6345	81022800.0
2008-01-24 15:00:00	NVDA	Stock	0.6343	0.647	0.6313	0.6465	160955240.0
2008-01-24 16:00:00	NVDA	Stock	0.646	0.6595	0.6223	0.6595	16547920.0
2008-01-24 17:00:00	NVDA	Stock	0.659	0.6625	0.6525	0.6625	126240.0
2008-01-24 18:00:00	NVDA	Stock	0.6588	0.6618	0.657	0.658	164000.0
2008-01-24 19:00:00	NVDA	Stock	0.6618	0.6673	0.6618	0.6673	138800.0
2008-01-24 08:00:00	AMZN	Stock	3.7	3.7345	3.6875	3.7175	147720.0
2008-01-24 09:00:00	AMZN	Stock	3.7175	3.7975	3.7005	3.761	30320000.0
2008-01-24 10:00:00	AMZN	Stock	3.759	3.81	3.7095	3.747	41039460.0
2008-01-24 11:00:00	AMZN	Stock	3.747	3.83	3.729	3.7875	22007680.0
2008-01-24 12:00:00	AMZN	Stock	3.7875	3.8225	3.77	3.797	17376340.0
2008-01-24 13:00:00	AMZN	Stock	3.796	3.8675	3.787	3.828	24436740.0
2008-01-24 14:00:00	AMZN	Stock	3.8295	3.875	3.818	3.836	21239600.0
2008-01-24 15:00:00	AMZN	Stock	3.835	3.894	3.8265	3.8835	35126540.0
2008-01-24 16:00:00	AMZN	Stock	3.8835	3.93	3.7971	3.93	5652880.0
2008-01-24 17:00:00	AMZN	Stock	3.93	3.9475	3.8835	3.925	293860.0
2008-01-24 18:00:00	AMZN	Stock	3.9125	3.925	3.912	3.925	21500.0

> showing 50 of 41,001 rows — these rows as CSV

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