PREVIEW / stock_1hour / 2008-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-24.parquet
  size:    841 KB
  rows:    40,369
  symbols: 3,341

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-06-24 07:00:00	AAPL	Stock	6.15	6.15	6.1164	6.1389	157780.0
2008-06-24 08:00:00	AAPL	Stock	6.1336	6.1429	6.1179	6.135	1168972.0
2008-06-24 09:00:00	AAPL	Stock	6.1375	6.2107	6.1236	6.1946	78543780.0
2008-06-24 10:00:00	AAPL	Stock	6.1964	6.2321	6.1429	6.2155	133411460.0
2008-06-24 11:00:00	AAPL	Stock	6.2182	6.2764	6.2039	6.2607	95623192.0
2008-06-24 12:00:00	AAPL	Stock	6.2593	6.2779	6.2232	6.2357	49455364.0
2008-06-24 13:00:00	AAPL	Stock	6.235	6.2546	6.2125	6.2357	57966524.0
2008-06-24 14:00:00	AAPL	Stock	6.2357	6.2579	6.1796	6.2039	69138468.0
2008-06-24 15:00:00	AAPL	Stock	6.2037	6.2171	6.1571	6.1875	106960364.0
2008-06-24 16:00:00	AAPL	Stock	6.1875	6.2041	6.1741	6.1964	7401884.0
2008-06-24 17:00:00	AAPL	Stock	6.1964	6.1979	6.1929	6.1961	53984.0
2008-06-24 18:00:00	AAPL	Stock	6.1961	6.2018	6.1957	6.1964	98280.0
2008-06-24 19:00:00	AAPL	Stock	6.1982	6.2018	6.1946	6.1957	54264.0
2008-06-24 07:00:00	MSFT	Stock	27.75	27.75	27.63	27.64	1100.0
2008-06-24 08:00:00	MSFT	Stock	27.78	27.85	27.64	27.79	30066.0
2008-06-24 09:00:00	MSFT	Stock	27.8	28.0	27.66	27.74	5468567.0
2008-06-24 10:00:00	MSFT	Stock	27.74	27.75	27.51	27.74	9262342.0
2008-06-24 11:00:00	MSFT	Stock	27.74	27.94	27.65	27.8	7639918.0
2008-06-24 12:00:00	MSFT	Stock	27.79	27.95	27.72	27.8	6308484.0
2008-06-24 13:00:00	MSFT	Stock	27.8	28.01	27.73	28.0	9154229.0
2008-06-24 14:00:00	MSFT	Stock	27.99	28.0	27.74	27.82	7489716.0
2008-06-24 15:00:00	MSFT	Stock	27.82	27.91	27.64	27.73	11817464.0
2008-06-24 16:00:00	MSFT	Stock	27.75	27.846	27.66	27.73	4112504.0
2008-06-24 17:00:00	MSFT	Stock	27.73	27.76	27.73	27.76	4872.0
2008-06-24 18:00:00	MSFT	Stock	27.77	27.78	27.75	27.75	2538.0
2008-06-24 19:00:00	MSFT	Stock	27.75	27.75	27.7	27.72	4930.0
2008-06-24 07:00:00	NVDA	Stock	0.4818	0.4818	0.4818	0.4818	4000.0
2008-06-24 08:00:00	NVDA	Stock	0.4818	0.4818	0.4738	0.4763	447600.0
2008-06-24 09:00:00	NVDA	Stock	0.4763	0.4938	0.4748	0.4868	59782840.0
2008-06-24 10:00:00	NVDA	Stock	0.4865	0.497	0.4812	0.4955	183058440.0
2008-06-24 11:00:00	NVDA	Stock	0.4952	0.5018	0.492	0.4975	163715480.0
2008-06-24 12:00:00	NVDA	Stock	0.4972	0.503	0.4958	0.497	104905800.0
2008-06-24 13:00:00	NVDA	Stock	0.497	0.5035	0.495	0.503	197162280.0
2008-06-24 14:00:00	NVDA	Stock	0.5028	0.5112	0.5028	0.5058	177008960.0
2008-06-24 15:00:00	NVDA	Stock	0.5058	0.506	0.4982	0.5	166234320.0
2008-06-24 16:00:00	NVDA	Stock	0.4995	0.5008	0.4984	0.4992	3912720.0
2008-06-24 17:00:00	NVDA	Stock	0.4992	0.5008	0.499	0.5008	64000.0
2008-06-24 18:00:00	NVDA	Stock	0.5013	0.5013	0.5013	0.5013	20000.0
2008-06-24 08:00:00	AMZN	Stock	3.95	3.9575	3.94	3.9575	14160.0
2008-06-24 09:00:00	AMZN	Stock	3.975	4.0	3.945	3.95	21152880.0
2008-06-24 10:00:00	AMZN	Stock	3.95	3.9545	3.8815	3.931	31565880.0
2008-06-24 11:00:00	AMZN	Stock	3.9315	3.9785	3.913	3.968	26696500.0
2008-06-24 12:00:00	AMZN	Stock	3.9675	4.014	3.9505	3.999	14496240.0
2008-06-24 13:00:00	AMZN	Stock	3.9995	4.02	3.98	4.0155	13343100.0
2008-06-24 14:00:00	AMZN	Stock	4.014	4.0395	3.9675	3.9915	10254180.0
2008-06-24 15:00:00	AMZN	Stock	3.9925	3.9985	3.9615	3.9805	18638660.0
2008-06-24 16:00:00	AMZN	Stock	3.9805	3.992	3.9288	3.982	2682000.0
2008-06-24 18:00:00	AMZN	Stock	3.969	3.969	3.969	3.969	8820.0
2008-06-24 09:00:00	TLT	Stock	90.38	90.6	90.37	90.59	368313.0
2008-06-24 10:00:00	TLT	Stock	90.59	90.81	90.4	90.4	1095462.0

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

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