PREVIEW / stock_1hour / 2009-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-27.parquet
  size:    884 KB
  rows:    42,470
  symbols: 3,405

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
2009-10-27 04:00:00	AAPL	Stock	7.2139	7.2139	7.2139	7.2139	2800.0
2009-10-27 06:00:00	AAPL	Stock	7.2089	7.2089	7.2089	7.2089	5600.0
2009-10-27 07:00:00	AAPL	Stock	7.2143	7.2143	7.1825	7.1982	147308.0
2009-10-27 08:00:00	AAPL	Stock	7.2125	7.2218	7.1961	7.1964	800212.0
2009-10-27 09:00:00	AAPL	Stock	7.1968	7.2432	7.1386	7.1464	73814020.0
2009-10-27 10:00:00	AAPL	Stock	7.1368	7.1686	7.0304	7.1425	193874800.0
2009-10-27 11:00:00	AAPL	Stock	7.1425	7.1432	7.0921	7.1179	53866596.0
2009-10-27 12:00:00	AAPL	Stock	7.1179	7.1275	7.0864	7.0868	39757928.0
2009-10-27 13:00:00	AAPL	Stock	7.0868	7.1016	7.0304	7.0546	83683040.0
2009-10-27 14:00:00	AAPL	Stock	7.0557	7.0786	7.0354	7.0654	84549864.0
2009-10-27 15:00:00	AAPL	Stock	7.0654	7.0768	7.0161	7.0493	107885960.0
2009-10-27 16:00:00	AAPL	Stock	7.0457	7.1044	7.0332	7.0536	11072516.0
2009-10-27 17:00:00	AAPL	Stock	7.0536	7.2314	7.0493	7.0671	772408.0
2009-10-27 18:00:00	AAPL	Stock	7.0675	7.0679	7.0396	7.0679	1425788.0
2009-10-27 19:00:00	AAPL	Stock	7.0679	7.0739	7.065	7.0739	189952.0
2009-10-27 20:00:00	AAPL	Stock	7.2314	7.2314	7.2314	7.2314	473200.0
2009-10-27 07:00:00	MSFT	Stock	28.58	28.58	28.58	28.58	500.0
2009-10-27 08:00:00	MSFT	Stock	28.58	28.65	28.53	28.59	30167.0
2009-10-27 09:00:00	MSFT	Stock	28.68	28.88	28.62	28.73	8170730.0
2009-10-27 10:00:00	MSFT	Stock	28.73	28.78	28.45	28.67	15569676.0
2009-10-27 11:00:00	MSFT	Stock	28.66	28.75	28.48	28.685	7088931.0
2009-10-27 12:00:00	MSFT	Stock	28.69	28.72	28.55	28.58	4409085.0
2009-10-27 13:00:00	MSFT	Stock	28.58	28.62	28.48	28.55	7852017.0
2009-10-27 14:00:00	MSFT	Stock	28.55	28.68	28.44	28.65	7068955.0
2009-10-27 15:00:00	MSFT	Stock	28.65	28.66	28.485	28.61	14068560.0
2009-10-27 16:00:00	MSFT	Stock	28.61	28.75	28.54	28.59	2444531.0
2009-10-27 17:00:00	MSFT	Stock	28.68	28.73	28.5	28.54	5998.0
2009-10-27 18:00:00	MSFT	Stock	28.59	28.59	28.52	28.57	55636.0
2009-10-27 19:00:00	MSFT	Stock	28.56	28.6	28.54	28.6	7451.0
2009-10-27 20:00:00	MSFT	Stock	28.68	28.68	28.68	28.68	1024800.0
2009-10-27 06:00:00	NVDA	Stock	0.322	0.322	0.322	0.322	8000.0
2009-10-27 08:00:00	NVDA	Stock	0.324	0.3245	0.3238	0.3238	52000.0
2009-10-27 09:00:00	NVDA	Stock	0.3233	0.3278	0.3188	0.3188	72729440.0
2009-10-27 10:00:00	NVDA	Stock	0.3188	0.3208	0.315	0.3163	163520440.0
2009-10-27 11:00:00	NVDA	Stock	0.316	0.3185	0.315	0.317	59873720.0
2009-10-27 12:00:00	NVDA	Stock	0.317	0.3173	0.3148	0.315	44155520.0
2009-10-27 13:00:00	NVDA	Stock	0.315	0.3168	0.3103	0.3123	97315280.0
2009-10-27 14:00:00	NVDA	Stock	0.3125	0.3155	0.311	0.3155	46008600.0
2009-10-27 15:00:00	NVDA	Stock	0.3154	0.3155	0.3128	0.3135	93688880.0
2009-10-27 16:00:00	NVDA	Stock	0.3135	0.3155	0.3123	0.3135	13034440.0
2009-10-27 17:00:00	NVDA	Stock	0.3245	0.3245	0.313	0.3135	71520.0
2009-10-27 18:00:00	NVDA	Stock	0.3135	0.3135	0.3135	0.3135	4000.0
2009-10-27 05:00:00	AMZN	Stock	6.192	6.192	6.192	6.192	2000.0
2009-10-27 06:00:00	AMZN	Stock	6.2025	6.205	6.198	6.2	30780.0
2009-10-27 07:00:00	AMZN	Stock	6.193	6.212	6.1875	6.1985	93960.0
2009-10-27 08:00:00	AMZN	Stock	6.1975	6.2	6.153	6.1615	1053960.0
2009-10-27 09:00:00	AMZN	Stock	6.1625	6.213	6.1025	6.1534	75104740.0
2009-10-27 10:00:00	AMZN	Stock	6.1515	6.2	6.1125	6.1495	83698760.0
2009-10-27 11:00:00	AMZN	Stock	6.149	6.15	6.036	6.0615	74041340.0
2009-10-27 12:00:00	AMZN	Stock	6.064	6.0875	6.0255	6.026	30069080.0

> showing 50 of 42,470 rows — these rows as CSV

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